How to Retrieve Table Name from Statement Handle

I am creating a simple tool that will query one table and retrieve the data. Then this tool will turn the data into insert statements.

I was wondering if there was a way to retrieve the table name from the statement handle?

Similar to print "SQL statement contains $sth->{NUM_OF_FIELDS} columns\n";

but like this

print "SQL statement table name is $sth->{TABLENAME} \n";


Joseph Lamb



____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
.

Relevant Pages

  • Re: On ADSI and LDAP
    ... the problem is how can I retrieve the value for myuser using the ... would be more efficient to use ADO to query AD for the attributes values. ... For more on using ADO, ... Dim adoCommand, adoConnection, strBase, strFilter, strAttributes ...
    (microsoft.public.scripting.vbscript)
  • Re: Internet class differences...
    ... The database and web interface to the server is produced by a different ... Initially a WebClient class was used. ... This worked fine for submitting the query. ... retrieve the results but, instead, is sent to a login page from which it ...
    (microsoft.public.dotnet.general)
  • Re: Column Order Problem
    ... I understand the reasons for not using the BLOB data types but as I ... >> I'm working on required extending an existing query to retrieve some ... The query is written correctly and returns the ...
    (microsoft.public.data.ado)
  • Re: Returning only a subset of groups in AD
    ... Output.WriteLine "There are no members in this group." ... I assume that ADSICommand is an ADO command object, ... value assigned to the CommandText property, which is the ADO query. ... ' Comma delimited list of attribute values to retrieve. ...
    (microsoft.public.scripting.vbscript)
  • Re: VBScript INT Type Mismatch
    ... Here is how I am trying to retrieve the ... The script errors out on that exact line with: ... If I run the query in Query Analyzer it returns a numeric value. ... Dim strConnect, adoRecordset, strQuery, strGroupLocation, intLocation ...
    (microsoft.public.windows.server.scripting)