Hi,

I'm working with SA 10 (with latest patch over Windows) and I'm getting a
problem with a SP that worked fine in previous versions of ASA, now the SP
is returning a SQLCODE 734 "Cannot update or delete an all-NULL row from
table"... The query is an update to a PROXY table which is in the same
server and the connection is working since I can select all the rows from
the table. Now this update statement has a subquery from a local table, the
statement looks like this:


UPDATE PROXY_TABLE
SET col1 = ( select col_01 from LOCAL_TABLE where col_02 = @col_02 ),
col2 = @col2
col3 = 0,
col4 = 1
FROM
PROXY_TABLE
WHERE
col6 = @col6 AND col7 = @col7

The subquery will return *ALWAYS* only one record, and the statement will
update *ALWAYS* one record.

I didn't find anything related in the "Changes and Upgrading" documentation
for SA 10...

Thanks!

~Luis