Very Computer

1. Indexed-reposition in UIB

I am looking for a better or alternate method of accomplishing the
following using 7.3B with the UIB:

We use this method often in our applications.  We have a browser with, for
example, a name and phone number  Above the browser, we have a fill-in to
reposition the browser. i.e. 'search based on last name'.

        User types              Browser repositions to

        s                       top of last names beginning with s
        sm                      top of last names beginning with sm    
                        etc, etc.

We have a method that works, but it does have some drawbacks.  Here's what
we use presently:

--------------------------------------------------------------------------
--------------------------------------
in the main block before the 'pause 0 before hide' statement we put
--------------------------------------------------------------------------
--------------------------------------
on any-printable,backspace,delete-char of fil-in-search do:
        apply lastkey.
        run search_routine.  /* performs the find and repositions the
browser */
        return no-apply.
end.

--------------------------------------------------------------------------
--------------------------------------
Here's the search_routine.
--------------------------------------------------------------------------
--------------------------------------
find sports.customer where last_name GE fill-in-search:screen-value in
frame {&frame-name}  no-lock no-wait no-error.

if not available customer then leave.
reposition {&browse-name} to recid recid(customer).
====================================================================
This method is extremely slow on any decent sized database.  Performance
is increased if
we use indexed-reposition on the open query statement for the browser, but
this makes
the scroll-bar on the browser inaccurate.

If anyone knows a better method for accomplishing this task, it would be
greatly
appreciated.

        adva[thanks]nce

Daryl Williams
Leader Data Processing
Hazleton, PA 18201

Phone: 717-231-1606

2. Copying Word Documents To Filemaker

3. event reposition by data dao ok but event reposition by data ado?

4. xp_sendmail issue

5. Can not reposition objects

6. Warning ! SQL SRVR 6.5 - ANSI Syntax generates incorrect result set

7. Repositioning a Column

8. how do i hide the table names when i output a sql query to a file

9. Reposition cursor in a datagrid

10. Search & Reposition (DBGrid)

11. Can you reposition using ADO and DataGrid?

12. Edit Method and Reposition Event

13. Validate and Reposition events kick in twice