In BASIC EXECUTE "SELECT VOC LIKE A...", OUT. > MY.NEW.VARIABLE, SELECT. > MY.LIST
-----Original Message----- From: Holt, Jake <jh...@samsill.com> To: u2-users <u2-users@listserver.u2ug.org> 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 jh...@samsill.com <mailto:jh...@samsill.com> www.samsill.com <http://www.samsill.com> _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users