VFP stores Numeric data type in a table as a string. It requires 2 additional positions to store sign and decimal point.
>Querying a SQL Server table using SQLEXEC() and I notice that every numeric field is 2 digits larger in the VFP cursor than the actual SQL Server table.
>
>If I look at the columns using the following 2 calls, I see that the VFP cursor is using the Buffer_Length and not the Column_Size.
>
>=SQLCOLUMNS(lnsqlhandle, "ADDRESS", "FOXPRO", "addsqlvfp")
>=SQLCOLUMNS(lnsqlhandle, "ADDRESS", "NATIVE", "addsqlnative")
>
>Any suggestions on how to correct this behaviour?
--sb--