February 7th, 2014, 08:04 AM
Record Pointer not moving when the "next" button is clicked.
The front-end forms are build in open office v.4.0.0 and the backend database and tables are in postgresql. When the "next" buitton is clicked in the front-end form of open office, the second record is not displayed in the form but the previous displayed records (i.e. records no. 1) continuous is still displayed. Even if one continues to click the "next" button a number of times, the display is still sown for records no. 1. It looks like the records point on the table does not move but is stuck on records no. 1. The total no. of records in this table is approx. 40, but only the first record is shown.
February 7th, 2014, 08:17 AM
This has nothing to do with Postgres - that's an OpenOffice problem. Please post to this to an OpenOffice forum
Btw: in Postgres there is no such thing as a "record pointer" and no such thing as "record no.1" - actually there is no such thing as a "record". In a relational database you store "rows"
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
Tips on how to ask better questions:
February 8th, 2014, 01:46 AM
Yes, I got it. after new form creation it started to work as per our requirement.
thanks for help.
Originally Posted by shammat