Not Get Table Name from ODBC-Sql Server Database(*.mdb) Or(*.xlsx)

Recommended Posts

I have a database and i am able to read write the data in tables of database.

Now i want all tables name in DAQFactory.

so, how to get table name in String Channel using sql query?

Following query i try but not work

qr = db.Query(dbase,"SELECT name FROM sys.Tables")

Share this post

Link to post
Share on other sites

That is going to depend on the database you are using, not DAQFactory.  Test your select statement in your databases user interface / command line tool first to make sure it works, then try it in DAQFactory.  Also, I recommend using db.queryToClass() instead of db.Query().

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now