var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Currency not on a record -1603
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."
Both tables have PARTNUM set as a primary key with no duplicates allowed.
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?