I am trying to run this staement from pervasive control center on
Pervasive.SQL 2000i:

UPDATE HPFYE.RM00103
SET HPFYE.RM00103.TTLSLLYR = HPFSAMPLE.RM00103.TTLSLYTD
WHERE HPFYE.RM00103.CUSTNMBR = HPFSAMPLE.RM00103.CUSTNMBR


I am getting the following error:

ODBC Error: SQLSTATE = 37000, Native error code = 0
Syntax Error: UPDATE HPFYE.RM00103

SET HPFYE.RM00103.<< ??? >>TTLSLLYR = HPFSAMPLE.RM00103.TTLSLYTD

WHERE HPFYE.RM00103.CUSTNMBR = HPFSAMPLE.RM00103.CUSTNMBR

Can someone help? Thanks!

While this syntax is definitely valid for PSQLv9, I'm not sure if this
is valid syntax for the PSQL2000 engine or not.
BB

Darren Woodbrey wrote: