--- t <[EMAIL PROTECTED]> wrote: > hi, > > I'm trying to load my database tables into a > scrolling field, I > connected to the database but I can't find a command > to get the > tables. > > Is there a command that stores the tables in an > array or a scrolling field. > > thanx, > -- > t >
Hi T, There is an undocumented function 'revdb_tablenames' that will give you the table names for a given connection. Example: -- put revdbconnect(...) into tCOnnectionID put revdb_tablenames(tConnectionID) into theTables -- Unfortunately, it doesn't work for all databases, but if it doesn't, other database users might be able to give you a hand to construct the SQL needed to extract the information. E.g. for MS-Access, the SQL is something like: -- SELECT name FROM MSysObjects WHERE type IN (1,6) AND name NOT LIKE 'MSys%' -- Hope this gets you a little closer to the solution, Jan Schenkel. Quartam - Tools for Revolution <http://www.quartam.com> ===== "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) __________________________________ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail _______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
