How to manage large SQL data sets - reply

[mfstuart at cox.net]

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
================================================