>I am doing a query via a cursor adapter into Sql Server. I have a table named systems that has a column sysid that is of type BIGINT. When I check my cursor after teh .Fill() below the column type on sysid is now C. In fact all my bigint columns are being converted to C. here is the code snippet any one knpw why this is happening? Is it because they are type BIGINT in Sql and Fox cannot interpret them?
Yes. VFP does not support 8 byte integers (bigint in SQL Server).
--sb--