DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How to get a table name from a Recordset

  1. #1
    Pat Guest

    How to get a table name from a Recordset


    Is there a way to get the table name that the Recordset is opened for?

    Thanks
    Pat

  2. #2
    Lanny Guest

    Re: How to get a table name from a Recordset


    Pat,

    You might try parsing the SQL statement looking for the table name after
    the FROM keyword, as in:

    SELECT * FROM Products WHERE ProductID = 12

    This could get tricky if the tablename contains spaces and it is surrounded
    by quotation marks. The SQL statement that generated the recordset is found
    in the Source property of the recordset object.

    Lanny

    "Pat" <pwang@uclink.berkeley.edu> wrote:
    >
    >Is there a way to get the table name that the Recordset is opened for?
    >
    >Thanks
    >Pat



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center