So, the choices are to edit the @ item in the dict & add all of the columns, or write a basic program that reads Rec, then outputs Rec<1>, Rec<2>, etc. A third solution would be to copy the F1 dictionary item to F2, F3, F4, etc., change the attribute (column) field to match, then list 'em all, maybe in a proc. Sounds like you have options...
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Evan Carroll Sent: Wednesday, January 20, 2010 7:05 PM To: [email protected] Subject: [U2] UniVerse RetreiVe how do I query a file for all of its column's values? This is a repost from a stackoverflow question I asked: http://stackoverflow.com/questions/2068026/universe-retreive-how-do-i-query- a-file-for-all-of-its-columns-values === START REPOST === In UniVerse you can't query a file for all of its columns unless the @ phrase in your file's dictionary is set to all of the tables columns. If it isn't how do you query a table for all of its column's values? So I can get the total column listing (column name & display name) using: LIST DICT file NAME This will return a listing of all columns and their display names. How do I then query the table for all of the columns it has? LIST file Will only query it for LIST file @id (@id is the only thing in @). .... === END REPOST === I'd like to follow up with a request to see if anyone has a copy of a BASIC program that does this, I imagine it is something every heavy universe must keep in arms reach. Thanks a ton, -- Evan Carroll System Lord of the Internets _______________________________________________ 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
