Hi, Bill is correct here,
I just wanted to bring to your attention that the @@resultset from a DirectDBMS is different from a Search action with regards to column names The resultset from a search action returns the column names into the row zero of the array whereas the directdbms doesn't So to access the data in an array that is a resultset of a directdbms is done by an index number (column count) and not the name of the column. This is always the case even though the select statement in the directdbms is a simple select with column named reference. Sample table Table1 Col1 Col2 Col3 Extract data from @@resultset -Under Search action @@resultSet[1,Col2] -Under DirectDBMS @@resultSet[1,2] Hope this helps :-) Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bill Downall Sent: Monday, December 09, 2002 4:27 PM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Database View On Mon, 9 Dec 2002 18:19:12 -0600, Fogelson, Steve wrote: >Are the results of >the Direct DBMS action stored in @@resultSet? > >As far as the alternate, do you mean create a view within R:Base or create a >view with a Direct DBMS action? > >Are R:Base views accessible from Witango? Yes, the result is still in @@local$resultset. Create the view in R:Base, and be sure to use column aliases (in parentheses, before "AS SELECT") and reload your tables in the Witango editor. It will work just like a table. Bill ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
