Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy database
Message
De
03/09/2019 01:52:49
 
 
À
02/09/2019 08:39:01
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01670502
Message ID:
01670521
Vues:
37
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform