Oracle Forms -- special query???

From: <ddreams_at_my-dejanews.com>
Date: Thu, 30 Jul 1998 17:50:17 GMT
Message-ID: <6pqbop$emc$1@nnrp1.dejanews.com>

Hi! I'm fairly new to Oracle Developer/2000 and have what I think is a simple question.

I've got a form with multiple fields (one row per page); users need to be able to search for records to update. Currently they can simply execute a query
(button bound to 'execute_query') and retrieve all the rows, or enter some
criteria and retrieve rows matching those crieteria.

The user wants to be able to enter a primary key and do one of two things, either navigate forward and backward (ie, retrieves all rows, but starts at the one they entered), or be able to navigate forward from that pk onle
(starts on their entered pk, retrieves where pk > entered_pk).

Is there a good way to do this??? How?

Thanks!

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 30 1998 - 12:50:17 CDT