How to manage large SQL data sets - reply

[Ruslan Zasukhin]

On 5/5/06 7:19 PM, "mfstuart at cox.net" <mfstuart at cox.net> wrote:

> Ruslan, here's my script:
> ====================================
> global tConnectID,tCursorID,mySelection
> 
> on selectNames
>   if the label of button "NameViewOption" = "Active Names" then
>     put "SELECT last_name, first_Name, address, city, state, zip_code,
> phone_no FROM names WHERE active_flag = 'T' ORDER BY last_name, first_name"
> into tSQL
>   else
>     put "SELECT last_name, first_Name, address, city, state, zip_code,
> phone_no FROM names WHERE active_flag = 'F' ORDER BY last_name, first_name"
> into tSQL
>   end if
>   -- Get data
>   put revDataFromQuery(,,tConnectID,tSQL) into mySelection
>   put mySelection into fld "tableResults"
> end selectNames
> ================================================

RevDataFromQuery -- is not good choice in your case.
    it load everything into string of result

You need to use RevQueryDatabase

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]