Query Labels Using Sql Follow

0
Avatar
Legacy Poster

Hello,
I would like to be able to simply dump SQL queries into a label format instead of building a database connection each time. I use TOAD or other query building tool to create the queries since my company has 500,000 tables and views and it take 10-15 mins each time to load through BarTender. I have tried using ODBC, Oracle, and SQL Server connections and it takes basically the same amount of time either way.

I'm using BarTender Enterprise 8.01 - Build 2179.

Any info or insight greatly appreciated.
Thanks in advance,

dbro34

4 comments

0
Avatar
Susan Chen
Moderator
Comment actions Permalink

Hi, dbro34:

The below instructions allow you to be able to execute a SQL query through BarTender.

1) Connect to your database in BarTender.
2) Go to the SQL tab in the Database Setup Dialog and select Use Custom SQL Statement.
3) Select Continue when prompted.

You now have a large edit box which has a SELECT statement in it. This edit box can contain the SQL statement you want to apply(for example: SELECT * FROM `Sheet1$`
)

I would suggest you test SQL statement in the SQL tool(for example SQL Server Management Studio) to make sure the SQL statement is correct.

Hope it provide some help for you.


Thanks!
0
Avatar
Legacy Poster
Comment actions Permalink

Thanks for the info. This is what I am doing, but it requires that I either add the tables by the populated list or enter the table names manually. Just trying to shorten the development time as it takes a while to load or get info from the server. Could be a WAN problem on this end....

Thanks again.
0
Avatar
Legacy Poster
Comment actions Permalink

One other question... After making a connection, how do you select on certain fields? Once I make a connection, the query wants to "SELECT *" from my source. I want to be able to only select a few fields.

Any further insight appreciated.
0
Avatar
paul tejano
Comment actions Permalink

Hi sir,

If i removed my SQL application. what would be possible errors?

 

thanks

Please sign in to leave a comment.