How to list tables in an SQL database

[Roger Kingston]

Jan,

Thanks for your guidance.  I'll give it a try shortly.  Just to clarify,
when you say, "use the name of an existing query" do you mean the ID
number generated by a RevDBquery or are you referring to an automatic
query from the Rev Query Builder?

Sorry for submitting this question three times, but I was getting
'mailbox full' rejections.

Regards

Roger Kingston
8 Parsons Walk
Clifton Campville
Tamworth
B79 0DL

email: roger.kingston at ntlworld.com 

-----Original Message-----
From: Jan Schenkel [mailto:janschenkel at yahoo.com] 
Sent: 19 January 2004 16:52
To: roger.kingston at ntlworld.com; How to use Revolution
Subject: Re: How to list tables in an SQL database


--- Roger Kingston <roger.kingston at ntlworld.com>
wrote:
> All,
> 
> I've had a good deal of success using Rev 2's revdb functions, but 
> would like to be able to get a list of tables belonging to
> a database that I
> have connected to.
> 
>   Looking in the code behind the Rev Database Query
> builder, there is a
> function:
> revTableNamesOfQuery() which looks promising, but it
> is not documented
> and I'm too dumb to figure out how to use it.
> 
> Any suggestions?
> 
> Roger Kingston
> 

Hi Roger,

The trick is to use the name of an existing query that
connects to the database whose table names you want ;
so suppose you have a query "Foobar" :
  put revTableNamesOfQuery("Foobar") into tNames
  answer tNames

Hope this helped,

Jan Schenkel.

=====
"As we grow older, we grow both wiser and more foolish at the same
time."  (La Rochefoucauld)

__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus