Re: [SQL] Stepping/Paging Through Rows

On Mon, 22 Feb 1999, Dan Parker wrote:

> I learned about cursors and they solved part of the problem - I created a
> form with Perl/Tk with buttons to move forward a row and backwards a
> row and that seems to be fine.
>
> There are a couple of features I would like to have that I can't figure
> out how I'd implement. For example, lets say I want to add a new row to
> the table. I press an 'Add' button, the form goes blank, and I key in all
> of the information. I press an 'Update' button and behind the scenes
> things whirl around and update the record in the database. No problem.
> But let's say now I want to return the user back to the browsing form and
> place them on the row they just entered (while still being able to "page"
> through the rows with the forward and back buttons). I'm stuck. If I
> create a new cursor, I'm back at the beginning of the table - there
> doesn't seem to be a way to find a particular row and placing the
> cursor there after creating the cursor.

Have you looked at pgAccess yet? It's an application written in Tcl/Tk
that allows you to build and administer PostgreSQL databases in a manner
very similar to MS-Access (hence the name, I guess...) The author of
that software has probably already done a lot of what you are trying to
do. It can be found at http://www.flex.ro/pgaccess. I believe there may
even be a mailing list for it, but you can definitely get more direct
information on the INTERFACES mailing list.

Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
Love at first sight is one of the greatest labor-saving devices the
world has ever seen.

----- BEGIN GEEK CODE BLOCK -----
Version: 3.12
GAT dpu s:-- a C++++ UL++++$ P+ L+++ E W++ N- o K- w--- O@ M-@ !V PS+++
PE Y+ PGP- t++ 5- X+ R+@ tv b+++ DI+++ D+ e>++ h+ r++ y++++
------ END GEEK CODE BLOCK ------