Hi Dennis,
Not is good way, becase you must rewrite your application, if you got datatype char instead number.
IMHO, safety is using older ODBC driver.
MartinaJ
>Hi Martina,
>
>I changed option=13684 (Treat BIGINT columns as INT columns) to option=536870912 (Bind BIGINT parameters as strings).
>
>select 4000000000 yielded "4000000000 " -> a 20 character string.
>
>So I guess option=536870912 is way better?
>
>Dennis
>
>
>>Hi Denis,
>>
>>ODBC driver converts number 4000000000 to -294967296?
>>
>>Hmm,
>>
>>
>>?CAST(4000000000 as int)
>>
>>
>>IMHO, the ODBC driver got 4000000000 as bigint, but VFP don't know bigint datatype and convert to signed int.
>>Question is why ODBC driver ignore NO_BIGINT flag?
>>
>>
>>
>>select CAST(4000000000 AS DECIMAL(20))
>>-- select CAST(4000000000 AS INTEGER) -- converts to bigint - by documentation
>>
>>
>>MartinaJ
>>
>>>Hi Martina,
>>>
>>>I tried the different select's you told me to do:
>>>
>>>
>>>select 1
>>>select 10
>>>select 10000
>>>select 4000000000
>>>
>>>
>>>The first 3 yielded the same numbers, except for 4000000000, which yielded -294967296 !!!
>>>
>>>Why is this so? Pardon my ignorance.
>>>
>>>Regards
>>>Dennis