Forums

by Rory White >> Tue, 2 Nov 1999 2:17:15 GMT

Does anyone have any experience of updating a JADE database via ODBC?

What I'm looking at doing is retrieving JADE data via ODBC and a relational view, e.g.
"select customer.number, customer.name from customer where number = 2" and then updating that data e.g.
"update customer set date_of_last_purchase = '1-Jan-1999' where number = 2"
The first statement works fine but the second one comes up with:
"This SQL Statement is not supported"
Fair enough, but is there some (hack) way that I could implement this?

Thanks,

by Krull >> Tue, 2 Nov 1999 5:30:05 GMT

Does anyone have any experience of updating a JADE database via ODBC?

Rory,

The JADE ODBC driver is a read-only driver; updating SQL statements are not supported.

Can you perhaps explain why you need to update a JADE database using SQL? Perhaps there is an alternative depending on what the actual business requirements are.

There are very good (practical and philosophical) reasons why directly updating JADE objects (or objects in any OO database for that matter) via ODBC/SQL is not a great idea.