Martina
"I did try MySQL 8.0.30 and ODBC connector 8.0.30 and number 4000000000 was coverts to string automaticaly (I don't set flag in connection string)."
I now removed the option clause and it now returns to string automatically, which means that option is not required all along! So weird.
Dennis
>Hi Dennis,
>
>You test MySQL 8.0.29, but latest version is 8.0.30.
>I did try MySQL 8.0.30 and ODBC connector 8.0.30 and number 4000000000 was coverts to string automaticaly (I don't set flag in connection string).
>
>MartinaJ
>
>>Hi Martina,
>>
>>Already did the changes. It is part of my base class so it is easy on my part.
>>
>>Also, I think we should really change it since using option=13684 (BIGINT) from MySQL will only convert it to VFP integer data, which we know has a limit.
>>
>>At least, using option=536870912 gives us the real values; we only need to convert using VAL().
>>
>>However, my problem still remains:
>>
>>ERROR [01000] [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.29]The number of attributes is larger than the number of attribute values provided
>>
>>
>>I shall go back to using MySQL ODBC 8.0.30 and Server 5.7.39 for now.
>>
>>Regards
>>Dennis
>>
>>
>>>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
