Thanks, I figured it used the > character in some way, just couldn't get the syntax right.
Jake -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Wjhonson Sent: Friday, March 29, 2013 3:17 PM To: [email protected] Subject: Re: [U2] Retrieving SQL result 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
