Florian, Thank you so much for your time. You have given me a whole lot
to think about. I suspect you have defined most of the important
aspects of the solution to my problem. I will go and implement this.
Mit freundlichen GrĂ¼ssen, Willem
---(end of broadcast)-
Hello Willem,
you are writing an edit mask?
Then do the following. Feed the mask with the data from the record.
If the user changes anything and presses the save button, then issue an
UPDATE WHERE ID= to the database.
Always remember: you are working with a database, not with a dbf-file.
If
Hello Willem,
if its not too much data you could do an
select * from table an store the result in an array of rows.
Then you can iterate over it.
If this is too bloated then create a cursor with:
declare (refer to
http://www.postgresql.org/docs/8.1/interactive/sql-declare.html ).
Then use