In BASIC EXECUTE "SELECT VOC LIKE A...", OUT. > MY.NEW.VARIABLE, SELECT. > MY.LIST
-----Original Message----- From: Holt, Jake <[email protected]> To: u2-users <[email protected]> Sent: Fri, Mar 29, 2013 1:07 pm Subject: [U2] Retrieving SQL result I am guessing this is a basic question, and It's probably simple but is there a way to retrieve or redirect the result of a sql query in a UniBasic program? For example: if I run the query 'SELECT SUM(CAST(F37 AS NUMERIC)) AS SALES.TOTAL WHERE YEAR = "2010" AND BILL_TO = "122"' Can I redirect the output to a variable? Thanks, Jake Holt l samsill l Information Technology Director (817) 536 - 1906 x 217 l [email protected] <mailto:[email protected]> www.samsill.com <http://www.samsill.com> _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
