CompuServe Messages

SBPro4 questions…

    07-Jun-92 16:26:47
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