Runtime Error 5334 - Bad or Missing UPDATE data (ViP Specific)
At 04 NOV 1997 11:55:34AM John Seto @ MMT-Computing.co.uk wrote:
We have a module within an application which is querying @All using an SQL Selection formulae.
NOte: we are using the data.lso classes, no physical data objects
This brings back a recordset.
Then we do an .edit method
Set a value using the .setvalue method and the updated it using the .update method.
Then we get …………………
Runtime Error 5334
Error in Expression "0099D". Bad or Missing UPDATE data.
Right the field we are updating is of type TEXT, the value we are writing is TEXT.
can anyone help us?
At 06 NOV 1997 04:10PM John Averell Revelation wrote:
The first thing to check is your SQL statement for defining the record set. You must include the column $NoteId in the returned columns in order to update a row. Without that, you will get the error you see.
It would be instructive to set up a data object the same way (@All), and query, edit, and update the row. It is a little easier to see what is going on when the data is in front of you. Frankly, if this is all you want to do, you are better off not to use DATA.LSO, which does add overhead to the process.