Doubt

[Trinity]

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?

 

[Ishan]

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.

 

[sknowonweb]

'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