--- Mikey <[EMAIL PROTECTED]> wrote:
> I'm looking all over but I can't find SQL commands
> to use with ODBC to
> extract the table names for a database, and once I
> have those to
> extract the column names for a table. My SQL is
> pretty darn rusty, in
> case you couldn't figure that out already.
>
> TIA.
>
Oops, I forgot to explain how you can fetch the column
information; the following code is rather crude, but
it does the trick until we get full schema
information:
##
function qrtdb_TableColumnNames pConnectionID,
pTableName
local tQuery, tCursor, tColumnNames
put "SELECT * FROM" && pTableName into tQuery
put revdb_query(pConnectionID, tQuery) into tCursor
if tCursor is a number then
put revdb_columnnames(tCursor) into tColumnNames
get revdb_closecursor
end if
return tColumnNames
end qrtdb_TableColumnNames
##
Put the above somewhere in a library stack script, and
then call it like this to extract the information from
a single table:
##
put qrtdb_TableColumnNames(gConnectionID, "images")
into tColumnNames
##
Like I said, it's a crude approach, and some databases
will be rather unhappy if you ask them to prepare an
entire table for a cursor, only to use the cursor
information.
But it has always worked for me - of course, depending
on the database, you can wirte specific queries to
extract column information. But those queries are
again database-dependent.
Hope this helped,
Jan Schenkel.
Quartam Reports & PDF Library for Revolution
<http://www.quartam.com>
=====
"As we grow older, we grow both wiser and more foolish at the same time." (La
Rochefoucauld)
____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the
tools to get online.
http://smallbusiness.yahoo.com/webhosting
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
