'Possible limitation with updating a field in Advantage Database?

I'm trying to update a field in a table and am unsure if I'm just completely wrong or if it's a possible limitation of using Advantage Database.

My Script:

UPDATE myTable SET myField = REPLACE(myField,substring(myField,myNumber,mynumber),'<>') Where myField = '<>';

The error I receive is "Expected lexical element not found: -- Missing table name. You are missing the table name after the keyword UPDATE. -- Location of error in the SQL statement is: 8"

sqldatabaseadvantage-database-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions