datatype confusion

Please Login or Register  to view this content.

If G18 (svendor) contains 12345, no probelm. If G18 contains abcde, run time error. Where in this code is datatype specified other than string??

Thanks in advance for your help...

I suspect the SQL would require the string variable be encased within ' ' ... it will work for a numeric string as is as you can use

SELECT 123 FROM TABLE WHERE 1=1

whereas you can not use

SELECT Apple FROM TABLE WHERE 1=1

it would expect Apple to be a field name in the TABLE - this is seemingly not the case here...

SELECT 'Apple' FROM TABLE WHERE 1=1

(syntax may vary pending backend platform)