SBPro4 questions…
07-Jun-92 16:26:47
Sb: #40213-SBPro4 questions…
Fm: Neil Robinson 100016,2775
To: Jim Joslin 72275,747
Jim,
First off, the request type you should be using in that case is type 24 (I
think this is available, I don't have the docs for the Amiga version yet).
The request type 24 presents a picklist to the user using the current
filter. Also, the reason it takes so long is that your query is not
optimized (I would guess). If you are using something like the following,
then it is *not* optimized:
SELECT WHERE LastName LIKE UserAnswer$
To optimize it, do the following:
z$ = "SELECT WHERE LastName LIKE " + UserAnswer$
EXECUTE z$
This results in the value of UserAnswer$ being evaluated *before* it is
passed to the filter system, which will make it dramatically faster than
passing it a variable. Also, obviously make sure that you have an index on
the LastName field.
As for scrolling transaction lines, it is a complex procedure best
described by the OCTS Advanced Workbook for Superbase 4. Although the book
is primarily intended for the IBM/Windows audience, much of what it has to
offer is applicable to the Amiga version.
Ciao, Neil