Search results
-
G
Issues updating a logical field using an ODBC connection
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' -
G
Issues updating a logical field using an ODBC connection
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...