How to update record using Pervasive SQL?

[ozero]

I have installed the Pervasive SQL 8.6 trial and success
to setup it and connect to my Peachtree data, which mean
using select statement in browseing is OK. But I have
problems when I try to update record with where statement.

For example I am success to update the Chart table by using :
"update Chart set LastYrPer12Net = 200"
It updated all the field in Chart which mean the data is
not read only.

However, when I run follow SQL which generated by SQL Data
Manager :
"update Chart set LastYrPer12Net = 200 where AccountID = '10000'"
or
"UPDATE "Chart" SET "Chart"."LastYrPer11Net" = 200 WHERE ("Chart"."AccountID"='10000')"

It have follow error :
ODBC Error
ODBC Error: SQLSTATE = S1000, Native error code = -4953
Access to the requested file is denied(Btrieve Error 46)

It is strange that I able to select record by
"Select LastYrPer12Net from Chart where AccountID = '10000'"
but fail to update with where statement.

Anyone can give me a hint how to solve it?

Thanks in advance !

 

[dgillz]

You should probably post this in the Pervasive forum.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz