myAdapter := OdbcDataAdapter.Create('select * from table where id =
          '+Val.ToString,Databases.DBConnection);

myBuilder := OdbcCommandBuilder.Create(myAdapter);
myBuilder.GetUpdateCommand;
myAdapter.Update(myDS,'TABLE');

---

 Comments

---

There was a general problem with the way the catalog functions were internally creating the metadata tables. Another symptom of this same problem was this error on the database server:

13/05/2005 10:34:59 AM [ERROR] Engine error [DBISAM Engine Error # 11308 An invalid or unknown request was made to the database server at ''] [Client Version: 4.20 User Name: admin Address: 192.168.0.26 Encrypted: No Request: REQUEST_CREATECURSOR Thread: 1436 Session: 38932488]

whenever any catalog functions were called in the ODBC driver.

---

 Resolution

---

Fixed Problem on 5/17/2005 in version 4.20 build 3

---

 Products Affected

---

DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source