SQLDrill.com - Excel Addin for using SQL

Microsoft® Excel® based database addin

 

Go Back   SQL Drill Excel Add-in > SQL Drill General Forum > Suggestions for Improvements

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-18-2010, 02:21 PM
Junior Member
 
Join Date: Jan 2010
Posts: 1
Default Counts

Hi,

I've been using this nice tool to a few weeks and have just registered here to give you a few suggestions to make SQL-drill even better.

1. In the result-view please how me the number of columns and rows that the query generated !

2. Make an easy way to verify if a table or view contains anything. Currently I'm working on locating specific information in a database where 80% of all tables are empty so being able to right-click on a table and select 'Show count(*)' would be a lifesaver.

Apart from these suggestions I also have a problem with embedding ... I simply cannot get SQL Drill to embed my query. I can execute and see the results just fine. I can also paste them to Excel ... but if I ask it to embed the query it gives me an error every time (CommandEmbed_Click ... etc).
Reply With Quote
  #2 (permalink)  
Old 01-29-2010, 01:06 PM
admin's Avatar
Administrator
 
Join Date: Apr 2008
Posts: 325
Default

Hi !

Thanks very much for the suggestions. These are both really good. We do have number 1 in the list already. The 2nd suggestion is great too - thank you. I am hoping to get some movement on the next release soon. For the past while I have not had too much time.

For the issue with the embedded query I would first check to make sure the problem is not workbook specific.

IF you still have a problem in an empty workbook. Then I would try to use MS Query to embed the query. If MS Query fails too then there is a general type of issue (maye part of the mdac installation How to check for MDAC version).

If you can use MS Query but can't use SQL Drill - then please could you send me the full error.

One other thing is that - if you can try the same on a different machine that you can get access on... Basically check if is machine specific..

Please let me know how it goes and I will do my best to help. Also, thanks alot for the suggestions.
__________________
SQL Drill Support
www.sqldrill.com

Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Counts Nordic Miscellaneous Excel Subjects 4 08-02-2009 10:30 PM
Counts Matt Dawson Queries 4 03-23-2009 09:32 PM
Counts more than one dTHMTLGOD Programming (VBA, VB, C# etc) 2 01-28-2009 05:57 AM
Counts Ange Programming (VBA, VB, C# etc) 1 01-20-2009 05:34 PM


All times are GMT. The time now is 04:07 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0 |Website Pricer