I am creating a Foxpro free table recordset within VB, modifying a column and then calling its Update method. The problem is if I create the recordset with the following statement:

"select * from table where col1 = value1 and col2= value2"

which returns one record, the Update method will fail with a message that the SQL statement is too long. Based on a hunch, I change the statement to

"select col3, col4, col5 from table where col1=value1 and col2 = value2"

the Update method works. I assume the problem using the first statement is that the Update method is building an Update SQL statement verifying that none of the other (40+) columns in this table have changed. Looking at ADO docs it appears that the "Update Criteria" dynamic property would allow me to force ADO to just verify col1 & col2 -- but the VFP ODBC driver does not appear to support this property.

Any ideas or do I have to build my own Update Statement?
Thanks in Advance.
Zev