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?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.