nTableID - I cFieldName - C(30) nKeyField - I nUpdatable - I cUpdateName - C(50) cCaption - C(50) cComment - M cDataType - C(10)This table contains a row for each field in each table in our database (about 1500 rows in total), all of our tables have been given a unique numeric table id, it looks like this :
1 | cField1 | 0 | 1 | Table1.cField1 | Field Caption 1 | memo | C(10) 1 | nField2 | 1 | 1 | Table1.nField2 | Field Caption 2 | memo | I 1 | tField3 | 0 | 1 | Table1.tField3 | Field Caption 3 | memo | T 1 | cField4 | 0 | 1 | Table1.cField4 | Field Caption 4 | memo | C(50) 1 | nField5 | 0 | 1 | Table1.nField5 | Field Caption 5 | memo | IThe problem we are having is that when we run a select such as the following using SQL Passthrough:
select * from FieldDetails where ntableid = 1approximately 3/4 of the time the result will be returned with columns showing a value from a different row such as the following (look at the caption column row 2 and 3, and the type column row 2 and 4):
1 | cField1 | 0 | 1 | Table1.cField1 | Field Caption 1 | memo | C(10) 1 | nField2 | 0 | 1 | Table1.nField2 | Field Caption 3 | memo | C(50) 1 | tField3 | 0 | 1 | Table1.tField3 | Field Caption 2 | memo | T 1 | cField4 | 0 | 1 | Table1.cField4 | Field Caption 4 | memo | I 1 | nField5 | 0 | 1 | Table1.nField5 | Field Caption 5 | memo | IWhenever the problem occurs it is always with different rows, never to the same row.
Visual FoxPro 7 Service Pack 1 SQL Server 2000 Windows XP and Windows 2000 Service Pack 2 VFP ODBC Driver Version 6.01.8629.01 SQL Server ODBC Driver 2000.81.7713.00If anybody has any ideas on what might be causing this, we would love to here them.