How can I UPDATE a record when processing multiple records in While result.next loop

[JoostM]

I have created a nice application with LibreOffice BASE with the aid of many examples that I have found on this forum. Thanks for that. But what I could not find is how I can update a record within a loop where I process multiple records based on a resultset of a query that returns multiple rows.

After an update, the DB pointer changes and the following result.next fails.

I must admit that I my last programming was in COBOL using DB2 as DBMS, To process all records that qualify a specific SELECT statement, you have to define a CURSOR. Within this CURSOR you can perform an update using the WHERE clause "WHERE CURRENT OF ". Then the DB pointer will not be corrupted after the UPDATE and you can continue with the next record within the original resultset of the query (CURSOR).

Does HSQLDB has something similar? UPDATE WHERE CURRENT… How does this work?

Thanks in advance
Joost

[Villeroy]

Documentation of the embedded HSQLDB, version 1.8 of 2005: Chapter 9. SQL Syntax

[JoostM]

Thanks, but it does not give me a clue. i now have avoided the need to perform an UPDATE within the result.next loop, but I still would like to know whether HSQLDB offers the functionality I was looking for…

[Villeroy]

https://www.pitonyak.org/database/