Knowledgebase: Tutorials
[QODBC-Desktop] Troubleshooting - ODBC driver doesn't support this statement. Updating existing record
Posted by Jack - QODBC Support on 30 March 2016 10:35 AM

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'))"

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).