loop a database

[Guest_imported]

I would like to view all the database fields, when you know the table name and the column name it is simple.
for opening the table:
m_RecordSet->Open ( dbOpenDynaset,"select * from Package" ,dbReadOnly) ;
for viewing the fields:
m_RecordSet->GetFieldValue ( StrInputKolom, m_var);
But I would like to now all the tables in a database, and acces all the fields in different tables.
Thanks for help.

 

[hsk007]

Hi,

I think we can only have connection with the database. To have fields from any table in the database, we have to explicitly mention the name of the table. So to have all the fields from all the tables in the database, I think it is possible on through the explicit mantioning of the table names.

Regards,

hsk007

 

[Cagliostro]

This often deppend on database, but most Microsoft Database APIs has SQLInfo* or some other *Info* functions. John Fill

ivfmd@mail.md