by Try the following construction in a VB5 Program
Dim Sql as string
Sql ="Select <field1> From <table> Where <field1> ='<value1>' and <field2>
= '<value2>'"
<rdo>.Sql=Sql
<rdo>.Refresh 'assume there is 1 record in the resultset!
<rdo>.ResultSet.Edit
<rdo>.Resultset(<filed1>) ='value3'
<rdo>.ResultSet.Update
after having done that, in the whole table <field1> is changed from <value1>
to <value3> for all records having
<field1>=<value1>!!
If <field1> is a joinfield then adios database
That error occurs even with the latest MDC V1.5 ODBC Drivers
Hi D. Harig
