Gettting a strange issue with sqlexec when pulling a small subset of the data... our keyfield is a C(10) field and is the last field in the fields list. pulling a small subset of a table (550 records) generates 2 sets of 2 records with the same keyfield. One record in each set has the correct keyfield data. What is causing this? Is this a known issue?? Subsequent viewing of the backend data shows the data to be correct in SQL Server. Needless to say this could cause quite an issue...moving the keyfield to the first position in the field list emliminates this problem...any thoughts would be appreciated..

thanks in advance,

Mike