Re: [SQL] Moving around in a SQL database

2006-04-29 Thread WillemF
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)-

Re: [SQL] Moving around in a SQL database

2006-04-21 Thread Florian Reiser
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

Re: [SQL] Moving around in a SQL database

2006-04-20 Thread Florian Reiser
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