Issues updating a logical field using an ODBC connection

G

ggriffit

New Member
OK All,

I have read the other newer issue on this and none of its suggestions are working. Can someone let me know what might be wrong with this syntax? I update SQLServer and mySQL databases all the time and none of those instructions seem to work on this Progress database I am using for this project. Any help is greatly appreciated!

UPDATE pub.Accounts SET Accounts.PaperBill = 1 WHERE Accounts.AcctNumber = '002000####' AND Accounts.CompanyCode = '002'

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[DataDirect][ODBC PROGRESS driver][PROGRESS]Syntax error (7587)
/new/processcommand.asp, line 376

Line 376 is the update query above. I have tried using true, false with and without single quotes, I have tried yes or no also with or without quotes. Normally a 1 or 0 work fine...

Thanks,
Grant Griffith
 
Yes, we finally figured things out... Remove the table name from the set statement... It works just fine then.

UPDATE pub.Accounts SET PaperBill = 1 WHERE Accounts.AcctNumber = '002000####' AND Accounts.CompanyCode = '002'
 
You must log in or register to reply here.
Back
Top