On 5/5/06 7:19 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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]
_______________________________________________
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
