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
================================================
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
