Currency not on a record -1603

[jrponline]

Hi There,

I am trying to run the query below in the Pervasive SQL V8.6 Data Manager.

UPDATE "TEST1" INNER JOIN "TEST2" ON "TEST1"."PARTNUM" = "TEST2"."PARTNUM" SET "TEST1"."DESCRIPTION" = "TEST2"."DESCRIPTION"

I get the following error:

"ODBC Error: SQLSTATE = S1000, Native error code = -1603
Currency not on a record."

The user manual says to add a group by or order by to solve the problem, but I don't know how to add one in an update query. Can you help?

 

[Linda84]

You don't want to use Inner Join like that. You want to do something like:

UPDATE "TEST1" SET "TEST1"."DESCRIPTION" =
(SELECT "TEST2"."DESCRIPTION" FROM "TEST2"
WHERE "TEST2"."PARTNUM" = "TEST12"."PARTNUM")

Linda
Pervasive Software

 

[jrponline]

Thank you, Linda!

 

[Linda84]

You're welcome - but don't cut and paste, there's a typo in my WHERE clause. It should be TEST1 not TEST12 after the =.



Linda
Pervasive Software