Customised search and displaying results
Date: 12 Nov 2001 06:26:09 -0800
Message-ID: <7a76da19.0111120626.138283e_at_posting.google.com>
ello All:
This is one of the requirements for a corporate phonebook search that I am currently working on:
"If the search does not return enough records to fill the user's display and the search has used last name as the search criteria, enough closely matching records to fill the screen will also be displayed, sorted by last name (half above the hits, half below). Records that matched the search criteria exactly will be prominently highlighted."
What it means:
Searching for last_name = 'Smith'
They want to see it on the screen in this fashion:
....... --so on, so forth, "enough to fill up a display"
Smithers
Smithe
Smith --highlighted Smith --highlighted Smith --highlighted Smith --highlighted Smith --highlighted
Smithson
Smithtsky
........ -- so on, so forth, "enough to fill up a display"
Is this doable with Oracle Forms 6i?
The client wants speed : there will be only one table with ~5000
records to search and required response time is 0.5s. I am affraid
that this requirement can compromised it.
Could anyone help, please.
Thank you
Roman Received on Mon Nov 12 2001 - 15:26:09 CET