Troubleshooting - ODBC driver doesn't support this statement. Updating existing record

Problem Description:

I'm trying to programmatically make Inventory Items In-Active after a sale or Active after voiding a sale.

I would have thought that the following SQL statement would have worked fine but I get error 214217887(80040e21) saying the ODBC driver doesn't support this statement.

sSQL = "UPDATE ItemInventory SET ItemInventory.IsActive = True " & _
"WHERE (((ItemInventory.ListID)='ED0000-1173904787'))" 

Solution:

As QODBC doesn't support the Table name being used in the SET columns. So you need to remove table name before column name in SET condition. For example:

sSQL = "UPDATE ItemInventory SET IsActive = True " & _
"WHERE (((ListID)='ED0000-1173904787'))"