1. Hey Guest Did you know you can win an Honor 10 phone worth ₹33,000 and an additional ₹70,000 in paytm vouchers, just by replying to some threads and taking part in the discussions happening in the Honor Hub?

    What are you waiting for? Start commenting and start winning! Remember to read the instructions posted here.

    Dismiss Notice

Doubt

Discussion in 'QnA (read only)' started by Trinity, Apr 30, 2006.

Thread Status:
Not open for further replies.
  1. Trinity

    Trinity New Member

    Joined:
    Feb 10, 2004
    Messages:
    125
    Likes Received:
    0
    Trophy Points:
    0
    Hi,

    wat does this mean?

    ->>> Number values should not be enclosed in single quotes, coz implicit conversion may take place for numeric values assigned to NUMBER data type columns if single quotes are included.

    Can u plz explain the last sentence , as to how does it convert and to wat?
     
  2. Ishan

    Ishan New Member

    Joined:
    Jun 12, 2005
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Bharuch,Gujarat,India
    I think that if this is an error it would be given by some programming language,
    as much as i understood from this is: the numbers should not be written in single quotes (in the field of datatype NUMERIC ) becoz if done so it may consider the single qoute as any operator and some undesired result may come(due to the cals which would occur due to that operator)..
    rest i can tell if u give the whole discription.
     
  3. sknowonweb

    sknowonweb New Member

    Joined:
    Nov 10, 2005
    Messages:
    134
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    CHENNAI
    '2321' => means 2321 is considered as a string, i think u r using a variable which was assigned this type of string for some numeric calculation .
    better declare the variable.(such as int , dim..,.. )

    a soln may be a=2321 ( instead of a='2321')

    ps) Does this error is from a SQL statement
     
Thread Status:
Not open for further replies.

Share This Page