SunnyByfleet
Technical User
Hi,
I am trying to do some under the bonnet work on a Sage Line 100 dataset. You can access this via ODBC, and performing SELECT queries causes no issues.
However, if I try and perform an UPDATE query, like so:
[tt]
UPDATE 'S'.'STOCK_CONTROL_FILE'
set 'MINIMUM_STOCK_LEVEL' = 0
GO
[/tt]
I get the following error:
[tt]
<eb1>Syntax error: Invalid key word specification
State:37000,Native:0,Origin:</eb1>
[/tt]
As far as I can see it, I am doing nothing wrong. Does anybody know how to perform an UPDATE query using the Sage Line 100 ODBC driver?
Help!!
I am trying to do some under the bonnet work on a Sage Line 100 dataset. You can access this via ODBC, and performing SELECT queries causes no issues.
However, if I try and perform an UPDATE query, like so:
[tt]
UPDATE 'S'.'STOCK_CONTROL_FILE'
set 'MINIMUM_STOCK_LEVEL' = 0
GO
[/tt]
I get the following error:
[tt]
<eb1>Syntax error: Invalid key word specification
State:37000,Native:0,Origin:</eb1>
[/tt]
As far as I can see it, I am doing nothing wrong. Does anybody know how to perform an UPDATE query using the Sage Line 100 ODBC driver?
Help!!
