Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy database
Message
From
03/09/2019 01:52:49
 
 
To
02/09/2019 08:39:01
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01670502
Message ID:
01670521
Views:
38
>You cannot use concat() for a table name.
>
>
>If SQLExec(m.con1, textmerge("SELECT TABLE_NAME"+;
> " FROM [<<m.db1>>.INFORMATION_SCHEMA.Tables]"+;
> " WHERE TABLE_TYPE = 'BASE TABLE'"),'tablist') >0
>
Thanks Doctor Cetin Basoz for helping but
your codes displays this error message

Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'at20.INFORMATION_SCHEMA.Tables'.

but when I run the following code in sqlserver management query then it work fine as shown in attached image
SELECT TABLE_NAME FROM at20.INFORMATION_SCHEMA.Tables WHERE TABLE_TYPE = 'BASE TABLE'
Please
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform