Just doing a SELECT in SQL style on UV gives you a crt display of the result set. But if you use the SLIST extension, you can then access the select list (see System Description manual) as "normal" for the UV environment.
--
Regards,
Clif
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678 Web: www.oliver.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On May 1, 2004, at 18:01, Steven M Wagner wrote:
I will be the first to admit that I know next to nothing about SQL in the UV/UD world.
Can you use the output of the SQL SELECT in UV/UD?
Thanks.
Steve
At 05:14 PM 5/1/04 +1000, you wrote:Gordon J. Glorfield wrote:
> In that case, I'm sorry to say, there is no way to logically > do what you're asking with UD.
Gordon, you should now better! ;^)
sql> SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE UNION SELECT NAME
ADDRESS CITY STATE ZIP FROM ORDER_FILE_OTHER;
All you need here Ed is a VOC pointer to each file that is SQL compatible -
ie no "." dots etc.
There is no need to build a schema or set up ODBC or do anything complicated
in UniData just to query a file with SQL from the command line.
Cheers,
Ken
>> -----Original Message----- >> From: Burwell, Edward [mailto:[EMAIL PROTECTED]
>> LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP >> >> or >> >> LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP >> >> How would a virtual dictionary know which file to get the >> NAME ADDRESS CITY and STATE from?
-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
------ Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America
-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users