Cannot run UPDATE query with Sage Line 100 ODBC driver.

[SunnyByfleet]

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!!

 

[edsuk]

The Sage driver only provides read only (SELECT) access. You cannot run update or append queries etc against the Sage Tables.

 

[SunnyByfleet]

Is there an alternative driver available?

 

[daveleggy]

Has anyone successfully done select queries to sage from asp?
if so can you tell me where the latest drivers are and an example of your code. This would be very much appreciated