Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Finding fields in tables
- Thread starter LilRed12
- Start date
You'll have to query the system tables (if supported for the type of database). Go to File>Options>Database tab, and check the box next to 'System Tables'.
For example, if your database is MSSQL Server, you would add the syscolumns and sysobjects tables, join on so.id = sc.id, and your record selection formula would be:
{syscolumns.name} = "ClientID"
-dave
For example, if your database is MSSQL Server, you would add the syscolumns and sysobjects tables, join on so.id = sc.id, and your record selection formula would be:
{syscolumns.name} = "ClientID"
-dave
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question