Hi

V3.6D
IB_Query
Manual tx tiCommitted
A few fields connected to IB_Edits

I have a table with a composite PK on fields account_no and co.
Update SQL = 'update customer set ... where account_no=:old_account_no and
co=:old_co'
The SQL is 'select * from customer where account_no=:acno and co=:co for
update'
Key links has
customer.account_no
customer.co

The record is selected and co='A'

When updating the sql monitor has

PARAMS = [ Version 1 SQLd 5 SQLn 5
CUSTOMER.CUSTOMER_ADD_1 = 'aaaa'
CUSTOMER.CUSTOMER_ADD_2 = ''
CUSTOMER.CUSTOMER_ADD_3 = ''
[OLD_ACCOUNT_NO] = 3062
CUSTOMER.OLD_CO = <NULL> ]

with the error 'record not located for update'. Any idea what is
happening - why is old_co null, why are the 2 old_ parameters shown
differently, one in [] and the other 'customer.' ?

Regards
Paul