var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Select and Update one row at a time
Can someone please help me with this.
I have a table with the following columns (example in XML format)
I'm trying to select and update a single row in a table at a time. I think the select will be something like this:
Not quite sure how to do the update though?
select * from cpdta10ua.OCC where RECSTS = 'N' order by TSTAMP fetch first 1 rows only
Normally you would do an UPDATE statement as :
UPDATE cpdta10ua.OCC SET [ColumnName]=[Value]
WHERE RECSTS = 'N'
Do you also mean to return a recordset to the client?