menu
Daily Bits Email

The email you entered is already receiving Daily Bits Emails!

PC
Today's DealsMost PopularFuture DealsExclusives
AudioBusiness & FinanceDesign, Photo & GraphicsDesktop Customization
DevelopmentHobby, Educational & FunInternetProductivity
SecurityUtilitiesVideo
Mac
Today's DealsMost PopularFuture DealsExclusives
AudioBusiness & FinanceDesign, Photo & GraphicsDesktop Customization
DevelopmentHobby, Educational & FunInternetProductivity
SecurityUtilitiesVideo

Virus Scan for Query Pro

Write More SQL Queries Faster Than Ever

Query Pro is a standalone application that boasts a powerful autocomplete engine that gives you the power to write SQL queries super-fast.

Our virus scan reports this download is 100% Clean Free Download

Download Virus Scan - Query Pro

Scanning File... loading

Website Malware/Phishing Scan - Spectral Core

We've scanned spectralcore.com using a variety of antivirus software and can bring you the following results.

Website 100% Clean Badges

Let your website visitors know that they can trust your download is 100% safe by using the following badges on your website.

Query Pro Virus Scan Report
Query Pro Virus Scan Report
Query Pro Virus Scan Report
Query Pro Virus Scan Report
Query Pro Virus Scan Report
Query Pro Virus Scan Report

What are people saying about Query Pro

No Name I downloaded the software to evaluate, and it asks for a key. How do I evaluate it? And I noticed that you apparently use online activation... if you go out of business, what happens to my software as far as activation?
Mar 22 2010 at 10:06am Copy Link
0
Damir Bulic There was accidentally direct download link which didn't provide activation code. Download again to get the code.
We are in business since 2001 and have no intentions of going out of business anytime soon, thank you. It's interesting how customers who purchase our applications for hundreds (or thousands) of dollars never ask such questions, but people who need to part with $29 are concerned about protecting their investment.
Spectral Core - Mar 22 2010 at 10:17am Copy Link
0
No Name Very interesting, since I've been at quite a few places that have been in that situation, and I've seen it asked before more than once because of protection of investment, especially in this economy. Intent or no, it happens, and just happened to me recently, so it is of interest. So what kind of support can we expect in such a case?
Mar 23 2010 at 8:16am Copy Link
0
Roger Thomasson @ Charles

I'm curious -- in the recent experience you speak of what was the result support-wise?

-roger
BitsDuJour Admin - Mar 23 2010 at 8:20am Copy Link
0
Damir Bulic Charles, your question is legitimate, of course - just, it came as surprise (I can't remember when someone asked me this).
Anyway, you might have noticed our applications cost $150-$4k. Let's say we for some reason there is no way we can support anything anymore (I get hit by a truck, for example, and my developers all go somewhere else). There are 2 possibilities:
a) There is no support, but site still sells apps (everything is automatic, so this is a reasonable scenario). Certain percentage of users are unhappy without support and ask/get refund, but most know how to use our applications without asking for help. Anyway, a single sale pays for server hosting for half a year so you can bet license server will be up and running.
b) My wife sells the company. She knows I would haunt her from another world if all our users lose all the licenses, so she insists that new owner services existing users (i.e. doesn't shut down license server).

P.S. I am careful when crossing the street, especially if trucks are approaching... :)
Spectral Core - Mar 23 2010 at 10:33am Copy Link
0
Alan Damir,
I had sent a general response to you about your other product that was on BDJ at one point but hadn't heard back yet.
I am interested in purchasing this product and your other one so if you get time can you answer my original question so I know how to proceed?
Thanks,
Alan
Mar 24 2010 at 12:50am Copy Link
0
No Name @Roger

I used IdeaMason from MasonWare for a while for research purposes; what I had written wasn't too important, it would have been just annoying to have to recreate, but a friend had her thesis written in it, on my recommendation, which was becoming due. She had upgraded her computer and found out she couldn't activate the software. Thankfully, MasonWare had the integrity to release a non-activated version for their registered customer.

I've also worked more than once for a lawyer that dealt with technology related issues almost exclusively. These jobs that I worked for him on involved verifying source that was put into escrow for larger companies purchasing from smaller companies just in case the smaller company went out of business, so maybe I'm more aware of it than most- I'm not sure.

@Damir

Thank you for your response.
Mar 24 2010 at 12:58am Copy Link
0
Damir Bulic Hi Alan,
I replied to you, but it seems you didn't get my message. Full Convert is no more available for purchase at the 90% discounted price. While sale at BitsDuJour.com was a success (almost a hundred sales in a single day), we won't offer Full Convert at this price anymore. Contact me directly at dbulic@ourdomain and I will give you a discount for Full Convert as you missed BDJ sales day. We do plan to offer a successor to our DataSync product at BDJ soon, though - don't miss it!
Spectral Core - Mar 24 2010 at 1:04am Copy Link
0
Alan What is the licensing on the product?
I couldn't find on the website if it's a per computer license, or per user..
Alan
Mar 25 2010 at 8:54am Copy Link
0
Damir Bulic @Alan,
Licensing is per named user. Each user can install on desktop and on laptop machine. License can be moved from one machine to another. Simply uninstalling on old machine and installing on new one takes care of proper licensing handling.
Spectral Core - Mar 25 2010 at 10:54am Copy Link
0
Michael R. When reading that your product has integrated the access to all major databases without the need of having the appropriate programs to have installed, I'm wondering, if it would be possible to execute a script via command-line (and so be able to integrate the appropriate call into a localy-used program).

Of course this script should be able to output the result somehow, e.g. CSV- of PDF-file...

Is this possible?
Apr 3 2011 at 2:16am Copy Link
0
Damir Bulic Hi Michael,
Rapid Query doesn't currently have the feature you wish, but it's an interesting idea. However, thinking about it a bit, it seems usage might be complicated (as connection information must be passed via command line) and a lot of output formats will inevitably be asked for. I have a feeling it would make more sense to make an .NET API or a dedicated command-line application for this purpose. We would need to research that a market need exists for such a product.
So, in short - currently this is not possible, but if more people start asking for something similar, we will make it possible.
Spectral Core - Apr 3 2011 at 6:51am Copy Link
0
Michael R. Thanks for the answer. Yes, probably there would be some questions about other formats too, but a minimum-output-format like CSV would your tool allowed to be used in an additional new way. And since you already have the data, I suppose it would be not extremely time-consuming to implement this. (People, who want different database-format as output, would probably rather install the original database-programs themselves).

Btw.: Is creating databases/tables and setting indices - directly and/or via SQL-statements like CREATE - also possible from within your program or is it only usable for already existing databases?
Apr 3 2011 at 5:28pm Copy Link
0
Damir Bulic As is a standard behavior in database admin tools, you can create new database, then use GUI designer to create new tables. You can also use SQL queries to do whatever you wish, of course.
Spectral Core - Apr 3 2011 at 8:23pm Copy Link
0
Roberto im a navicat user. your app look great, i go to download the trial version.
Apr 3 2011 at 9:00pm Copy Link
0
Damir Bulic Hi Roberto,
thanks for the kind comment!
You may want to download again tomorrow as we are releasing new version in a matter of hours - it will feature data generator, database documenter and some improvements all over the application.
Spectral Core - Apr 3 2011 at 9:09pm Copy Link
0
Stephane M Hi Damir,

I just installed the trial version and once SQL statements are formatted the auto-completion stops working.

We actually need to be on the same line after the SQL keywords (like SELECT, WHERE and so on) to have the auto-completion working.

Here is an example to illustrate what I am saying:

SELECT (here auto-completion is working)
Col1 (here it's not)
FROM (here it's working)
Table1 (here it's not)
WHERE (here it's working)
Col2 = 1 (here it's not)

Hope you follow me ;)
Thanks.
Apr 4 2011 at 3:47pm Copy Link
0
Damir Bulic Hi Stephane,
I just tried this and auto-completion works as expected, regardless on which line you are. Try pressing space to invoke the autocompletion.
Spectral Core - Apr 4 2011 at 6:41pm Copy Link
0
Stephane M Damir,

I did more tests and it is inconsistent. Sometimes it works and sometimes not, especially after FROM and WHERE. But most of the time it is not working for me.

A simple example:
if I type SELECT return and space on the new line, I am not getting a list of tables, space again, still nothing. Now if I go back with backspace then I get a list of tables. But even that is not working all the time.
And for FORM and WHERE it is even harder to get a list with space.

I tried different types of databases (MSSQL and MySQL) in case it might be related to the database, but it is the same.

I also had a few errors while I was playing with it so I sent the report, I am not sure you guys are receiving something but it said to me it was sent.

I have also started to notice different features not properly working like the "properties" button in the Database ribbon.
If I click on it, nothing happens.
The "properties" item in the contextual menu works though but if I choose a color for a database, when I go back into "properties" the color I chose is not selected anymore.
Also, when I click on the "new database" in the Connection ribbon, nothing happens. Are there any special requirements for that? Is it a trial version limitation?

I like the idea of being able to connect to different types of databases within the same tool without hassles and also the neat UI style, but I found it pretty buggy so far.
It might be related to my system, I do not know. I am running Win XP SP3 to do my tests.

Thanks.
Apr 5 2011 at 2:26am Copy Link
0
Damir Bulic Stephane, this is not a place for support issues. We have live chat, support area on our site, support emails automatically create support tickets etc.
So please send an email to support@oursite and we will see what and why happens on your machine.
Spectral Core - Apr 5 2011 at 2:30am Copy Link
0
Stephane M Damir,
I was just giving an overall feedback and more details on my issue as I started to talk about it here.
But there is no problem I will send an email to the support.
Thank you.
Apr 5 2011 at 3:18am Copy Link
0
Ken Koehler Like Michael R, I really need a tool that will do queries from the command line. A simple but usable example is Microsofts free SSEutil.exe for MS-SQL. I'm sure you could improve on the output formatting but even the same would useful. Others here and myself use SSEutil heavily to monitor our applications.
1) The biggest problem is that we have no such tool for other systems like DB2 on our AS/400.
2) Better output formatting would be a great help to us, like CSV for functional use and PDF for user friendly reporting.
I would buy it for the features above. All of the auto-complete stuff would just be a bonus.
Apr 5 2011 at 3:54am Copy Link
0
Damir Bulic Ken, we will consider adding command-line side-application to Rapid Query Pro. We can discuss what exactly do you need later on.
We can't join tables from different servers. It is doable, of course, but isn't a good solution for many reasons. I suggest using our Omega Sync to synchronize databases so they are all on one server, then you can use native database joins from multiple local databases.
Spectral Core - Apr 5 2011 at 5:16am Copy Link
0
Nelson Therrien Try the application...

For now, in my opinion, the biggest feature is the ease of creating queries (i.e. Rapid Query). There are certainly other tools, like creating and modifying tables, but you can have them in other tools... So, it's really the "auto-complete" that allows you to write faster, with less chances of mistakes.

So it's more targetted to people who make a lot of queries, I guess...

Whether you like it or not, one thing that is really sure: I've never seen somebody so eager to improve their products. Always open to ideas, really quick to reply and always asking for feedback to improve...

Great developer, Damir!
Apr 6 2011 at 5:13am Copy Link
0
Damir Bulic Hi Nelson,
thanks for the kind words!
Spectral Core - Apr 6 2011 at 5:25am Copy Link
0
Faisal Humayun I became a huge fan of Spectra Core since their phenomenal "Omega Sync" went on sale here at BDJ. Boy what a time saver that was! While I wished their single product license would good for my Desktop and Laptop (running only 1 at a time), it's still too good of a 'steal' to fuss over.

Rapid Query Pro current deal gives you the kind of query writing power that other products (such as Red Gates SQL Prompt, Navicat premium) and even RQP's normal pricing plan would otherwise be too cost prohibitive.

I'm used to using SQL Server Management Studio and MySQL Workbench for platform specific SQL writing and really welcome this lighter-weight, robust application in my arsenal because I can deploy my queries to either db (and many more) from within just this application: Priceless.

The auto complete feature is very handy and mirrors the MS intellisense product, but I think it would be outstanding if RQP's would even autocomplete SQL Keywords/operators too. One thing while I adore about the RQP auto complete is how it adds table qualifiers (something the MS intellisense doesn't do by default).

Since the product is for Rapid Query Writing, it's understandable for the UI to follow that intended goal. Result sets are displayed in a new tab, which is slightly less convenient than the split screen result set display of the other products I've mentioned. I hope future versions of RQP will allow for customized views.

The reformat option is EXCELLENT and instantly pretties up the code. I have a habit of going all lower case, and fudging up indent spacing. Here: 1 click = all fixed!

Spectral Core has a clear understanding of the tribulations endured by those who learn and practice database services and each of their product is an undeniable gem (and like gems cost a helluvalot until such times as BDJ sales).

Well that's 2 down - I'm already anxiously awaiting to see if they can strike a deal for their other products !

Endorsed whole-heartedly.
Apr 6 2011 at 11:42am Copy Link
0
Stephane M Could someone tell me if the license for Rapid Query is per user or per computer? I cannot find the formation.
Thanks!
Apr 6 2011 at 1:56pm Copy Link
0
Faisal Humayun @Stephane M -- Its per computer. They do offer the option to deactivate the license on the primary computer so that you can activate on another... a hassle no doubt.
Apr 6 2011 at 4:11pm Copy Link
0
Stephane M Yep not the best...thank you Faisal!!
Apr 6 2011 at 4:13pm Copy Link
0
Faisal Humayun Anytime! To be honest, I found this program to be so compelling that paying out $60 for 2 licenses is still a remorseless buy considering the normal asking price of $100. And, of course, the product overall is waaaaay cheaper (not inferior) to Navicat Premium and Red Gate's SQL Prompt (which run about $200 for their Pro versions).
Apr 6 2011 at 4:57pm Copy Link
0
Damir Bulic License is per computer, but there is no hassle. If you uninstall on one machine, we automatically deactivate its license. So unless your hard drive crashes, you will never have to contact us to deactivate on old computer for you.
I am glad to see some of our users are really passionate about Rapid Query and praised it in comments above! We will certainly keep improving Rapid Query based on your feedback. Thanks!
Spectral Core - Apr 6 2011 at 5:53pm Copy Link
0
bvssunnydale Hi, does this include support for FileMaker? Thx.
Sep 19 2011 at 6:35am Copy Link
0
Damir Bulic Hi,
no FileMaker support, sorry.
Spectral Core - Sep 19 2011 at 8:44am Copy Link
0
Tore Hoyem Normally I avoid products with "online activation, hardware footprint, 1 installation" type licenses, but this looks quite interesting.

How does one go about moving a license to another computer?

Is there a provision in place to handle the (un-thinkable!) event of your company going out of business vs. license transfers?


Edit:
I just noticed that most of what I asked has been answered previosly
Sep 20 2011 at 6:31am Copy Link
0
Damir Bulic Hi Tore,
I assure, if we happen to go out of business, we will protect your $29.70 investment as fiercely as we will protect our other customers who purchase our $999 products.
Spectral Core - Sep 20 2011 at 12:09pm Copy Link
0
Damir Bulic Forgot to reply to your license move question - just uninstall on one machine and reinstall on another, everything magically works. If old machine's HDD dies so you can't uninstall, you can send us an email and we will deactivate it for you.
Spectral Core - Sep 20 2011 at 12:10pm Copy Link
0
Stefan Weber Did I understand it right, to install it just only onto 1 (one) Machine?
I've a Desktop and for to go a notebook and don't want to buy two licenses for this.
Sep 21 2011 at 4:43am Copy Link
0
Damir Bulic Exactly for this reason we allow two copies for each license.
Spectral Core - Sep 21 2011 at 6:33am Copy Link
0
Tore Hoyem I won't be home until late tonight, so I won't be able to test the demo.
The product appears to be quite new, so Google doesn't find any reviews, either.

In the meantime, I'm hoping for a mini-review from someone who's taken Rapid Query for a spin ..... ;-)

Cheers.
Sep 22 2011 at 1:07am Copy Link
0
HJ B This application is not ready for release:

1. Documentation is difficult to follow because of English grammatical errors. The documentation also does not adequately convey the procedural flow of the program.

2.Since I was not able to get the program to do much, it is not clear whether that is because of my inability to understand the program flow or because the authors overstate its ease of use.

3. ON my system, running Sys 7-64 ultimate (1680x1050), some of the windows are distorted, so that buttons and captions are partially off the screen.

4. Following installation, I notice a drag on the system reaction time. While I cannot say, for certain, that it was this program that caused it, I have not previously had such a problem. I rebooted and I think the problem has disappeared, but I am not certain.

5. It is quite easy to provide documentation in pdf format. I wonder why so many authors limit themselves to help screens. In this particular case, a pdf document could also include bookmarks that were generated by the program.

It seems to me that Bit du jour should have some kind of standard with regard to the adequacy of documentation.
Sep 22 2011 at 2:33am Copy Link
0
Jerry Ruggiero Any discounts for Full Convert Enterprise?
Sep 22 2011 at 5:21am Copy Link
0
Damir Bulic I guess documentation could be improved quite a bit, we will take care of it in the following months. Nobody complained about lack of PDF, so although it's few clicks to recreate PDF, too, I don't see why to add another 1 MB to installer for something nobody asks for.
Spectral Core - Sep 22 2011 at 6:26am Copy Link
0
Damir Bulic Full Convert won't be on BDJ, that's our main product - sorry!
Spectral Core - Sep 22 2011 at 6:26am Copy Link
0
Charlie N This may seem like a simplistic question but I am used to desktop products like dbase, foxpro, access. Question: Can I use Rapid Query from the desktop to connect to an online database on a website and query, edit, update it?

Questions 2: will the queries integrate with my HTML code (copy paste) with interactive web apps? Or is it better for ad hoc queries by the devloper?

Thx,
Charlie
Sep 22 2011 at 7:50am Copy Link
0
Faisal Humayun As someone who needed a light-weight, fast-performing front end to a variety of SQL databases (I manage a few MySQL/SQLSevers), I decided to take the plunge and invest into this product and the company. Happily, RapidQuery & Spectral Core have exceeded all my expectations and the product has evolved itself into a very compelling SQL toolbox.

The company is very responsive to all feedback, bug reports, and feature requests.

Here's the RQP changelog/version history:
http://www.spectralcore.c...istory.php

I'm delighted to report that many of the changes since version 1.5 was a direct consequence of various exchanges I've had with Damir. As RQP barrels towards a 2.0 release, I look forward to each new release.

RQP's nearest competitor is Navicat Premium ( http://www.navicat.com/buynow/store.html ) Once you get over the sticker shock, you won't hesitate to pick up 1, 2 or even 3 licenses of RQP.
Sep 22 2011 at 8:59am Copy Link
0
Techtoysavvy I just ordered but there was a message that someone may call me to verify the order. This is fine but the telephone number is my home telephone which is needed for the credit card verification. I am not currently at home.

This is the first BDJ deal I have done which required phone verification of orders.
Sep 22 2011 at 10:06am Copy Link
0
or Navicat? The hint at Navicat is exactly the point. Is there any comparative review of the two programs, or can anybody do such a mini-comparative review on the spot?
Sep 22 2011 at 11:31am Copy Link
0
R M Not quite ready for primetime.

1. Should have the option of hot key execution
2. Can't close query result tabs
3. Excel output is weak. Defaults to xls with no option for other versions. App will crash if over 255 columns. You can manually change to xlsx but excel won't open it due to format issues.
4. Can't read selected database due to black text in dark blue highlight.
5. The "Intellisense" doesn't recognize functions (SQL Server) nor highlight the keyword. There should be an option to set the editor up accordingly.

-Not worth the money. There are other tools out there for similar $$ with better functionality.

This has potential but still has a ways to go.
Sep 22 2011 at 11:42am Copy Link
0
Damir Bulic For some reason I didn't get notification of comments in the last few hours.
Rapid Query is for ad-hoc queries, we didn't make any efforts for web developer integration as we feel it is not its true purpose.

Faisal, you are one of our most cherished customers, you know that :)
Spectral Core - Sep 22 2011 at 11:57am Copy Link
0
Damir Bulic RML
1. Ctrl + E, that's standard hotkey
2. Query result tabs are not in a way, they are just tabs, so navigate back to SQL script and you don't see them anymore.
3. We can look into it - we support Excel (all versions) in all our apps, nobody complained about it in RQ
4. Never noticed that - perhaps it's color scheme on your machine. We'll check, though.
5. It does recognize functions, and in fact, it offers immediate help right away as you type.
Seems there is something in your database config that causes issues. Write to support at our domain, we will take a look.
Spectral Core - Sep 22 2011 at 12:01pm Copy Link
0
naveed I've been playing with the trial and the autocomplete is obviously the big part of Rapid Query, however, the key required to activate an item is "Enter" only which is different from most other software, where it is "Tab". An option to change this key would be really great.

Also, keeping with the shortcut keys, I'd like to see an option to be able to change the key to run a script. Ideally I'd like to see 2 keys: 1 to run the whole script, another one to only run the script where the cursor is placed (between previous and next semi-colons)

I really like the dark theme options, however they are incomplete - the script editor doesn't change and the table and column names on the left side are still in black. It's hard to read against a dark gray background, the text there should be white as well.

An ability to change the script editor font is essential. I hate Courier.
Sep 22 2011 at 12:08pm Copy Link
0
Damir Bulic Naveed,
good suggestions.
Spectral Core - Sep 22 2011 at 12:11pm Copy Link
0
Charlie N Thx
Sep 22 2011 at 3:17pm Copy Link
0
GTD The coupon code seems to be not working now. It worked earlier, but I got interrupted before I could complete the checkout process.
Sep 22 2011 at 3:30pm Copy Link
0
Roady Roadworker Where's the coupon code?
redirected to the payment page bij BDJ and the main website,,but it still shows the full price...
Sep 22 2011 at 4:05pm Copy Link
0
s p same, i tried to buy but it i sno longer working.
Sep 22 2011 at 6:10pm Copy Link
0
Roger Thomasson Hmm... definitely something funny going on here with the coupon code. Apologies for the inconvenience folks, working on this now!

-r
BitsDuJour Admin - Sep 22 2011 at 6:27pm Copy Link
0
Math Mike At 4 hours and 20 minutes to go, when I clicked on To Buy, message came up saying the deal was not available today. So I tried again and website's order page came up with the full price and no way to discount. Please advise.
Sep 22 2011 at 7:42pm Copy Link
0
Steven Avery Can I use this in reverse, to build from scratch a small flat file database and enter, add, update records, view and sort, and then later use a more sophisticated app ? (Your product or other.) e.g. Alpha 5 and Magic and some other database products might support a MySQL database (is that what we work with here ?) and thus could pick up from what is started with RQP ? If I am making sense. When I played with the 5 or so standard products, NaviCat stood out, (ease if use, sensible price) so if you are in that league that is a good sign, especially with the Bits special.

====

Ok, I see you have a "Table Designer" and support for * Access
* SQL Server * Oracle * MySQL * PostgreSQL * Interbase
* Firebird * ODBC sources

So that looks like a tentative yes. Presumbably the Table Designer can start from scratch. I do not expect it, but are there any relational capabilities at all in RQP ?

Steven
Sep 22 2011 at 8:38pm Copy Link
0
Gerald Montgomery I tried coupon code too. Got this message: "not valid coupon code". Oh well, time for bed.
Sep 22 2011 at 9:03pm Copy Link
0
Douglas ONeill I was really interested in this - but the only coupon code I see says it is for the trial download? What is the code to purchase at $29.70
Sep 22 2011 at 9:58pm Copy Link
0
Damir Bulic Sorry guys, I messed up coupon expiration. It works again.
Spectral Core - Sep 22 2011 at 10:43pm Copy Link
0
Damir Bulic Table Designer can start from scratch. What exactly do you mean by relational capabilities?
Spectral Core - Sep 22 2011 at 11:12pm Copy Link
0
Douglas ONeill Any chance due to the coupone technical difficulties yesterday of offering again?
Sep 23 2011 at 6:52am Copy Link
0
Gerald Montgomery @Douglas O'Neill It's early next day and coupon code just worked for me! I guess, try it.
Sep 23 2011 at 7:04am Copy Link
0
Damir Bulic Douglas, send me a mail at support @ spectral core domain and I will send you direct purchase link with discount. Applies to all people who couldn't purchase yesterday evening.
Spectral Core - Sep 23 2011 at 9:00am Copy Link
0
Michael Guilfoyle I see you have table designer coming soon - when and how will that work. Will it be drag and drop in a graphical environment and edit tables directly or be dialog based?

I am looking for a good DB designer.
Mar 20 2014 at 12:06am Copy Link
0
Damir Bulic Hi,
we actually have a dialog-based table designer, you can use it. I will see that we update description.
Spectral Core - Mar 20 2014 at 3:19am Copy Link
0
Damir Bulic See screenshots at http://www.spectralcore.com/rapidquery/
We need to update the website - latest build also has documentation generator, data generator and slightly different UI.
Spectral Core - Mar 20 2014 at 3:20am Copy Link
0
Mark Johnson I see the last update was in 2012; is this still actively under development?

I downloaded the product trial and am giving it a try against Sql Server 2012 databases on a server and a local MySql database and an Access database on a shared network folder...

The sql server 2012 and MySql did very well. In Sql Server I tried some fairly complex queries, including cross-database queries, and all performed nicely.

However, I do see some things I don't like much.... for one thing, the only way to autocomplete seems to be pushing enter. I am used to using 'Tab' for autocomplete in several other products, and really don't want to have to remember to push 'Enter' to autocomplete on one product.
Another thing -- the button to autosize columns vertically -- where is the option to do the same horizontally? I tried the button on a query where a varchar(100) column was fairly well populated, and ended up with a really huge vertical column instead of a logically sized horizontal and vertical column. That could be done a little better.

When I tried with Access...
After choosing the folder, I kept getting "RapidQuery has encountered a problem" and the application would close.
If I change the option from 'Show all databases' to 'Let me choose' I do get to the next screen, where it shows a list of Access databases in the selected folder. I then select a database, and again "RapidQuery has encountered a problem".
I have chosen the option to 'Send error report' twice now.
Choosing to ignore the error and try to continue just causes the error again.
I tried some different databases (all Access databases I have are ones i get from vendors, and they all appear to be Access 2003 format). I'm on Windows 8.1 Pro 64-bit. I also tried with an Access database on a local (non-networked) folder and got the same problem.
Mar 20 2014 at 11:08am Copy Link
0
Oscar Magallanes Hello,

I have some questions:

1) I understand that its possible to establish a remote connection with ssh tunnel, so is it possible a direct remote connection too?

2) About export data, is it possible to do it? Can I export records through an SQL Insert Syntax?

3) About Data generator,. do you have more information or an example?

Thank you in advanced.
Mar 20 2014 at 11:38am Copy Link
0
Bob Criswell I encountered the same problems with using Rapid Query Pro with access databases that Mark did. I could see all the databases in the remote folder I was accessing but whether all mdb (no accdb) were checked or just one the program would force close.

Connecting to a SQL Server 2000 database worked and the queries I ran worked fine.
Mar 20 2014 at 12:20pm Copy Link
0
Damir Bulic @Mark,
We didn't bother updating our product page for quite some time, bu there were quite a few updates. I will see what's going on with Access support and why does it crash. Horizontal widths are optimized by clicking 'Fit column widths'.

@Oscar,
Of course, direct remote connection is possible. You would use SSH tunnel only if your web server is locked for remote connections to connect as if you were on localhost. We currently don't export SQL inserts, but plan to add that in the future.
Regarding Data Generator, please download trial from our website and use it - it's pretty easy.
Spectral Core - Mar 20 2014 at 12:35pm Copy Link
0
Sam Hi,

Does it work with SQLite Databases?

Thanks,
Sam
Mar 20 2014 at 1:50pm Copy Link
0
TAPTRONIC "Does it work with SQLite Databases? "

was hoping to get an answer for this
Mar 22 2014 at 3:27pm Copy Link
0
Bob Criswell SQLite is not listed on the website as being natively supported. However it does list 'ODBC Sources' as supported.
Mar 22 2014 at 4:11pm Copy Link
1


Our virus scan reports this download is 100% Clean Free Download



BitsDuJour is for People who Love Software
Every day we review great Mac & PC apps, and get you discounts up to 100%
Deals
Software Download Deals Free Software Download Popular Deals Past Deals About our Giveaways
Communication
Daily Bits Suggestions Blog Recent Activity
Company
Contact About Link to Us Affiliate Program Promote Your Software
Follow Us
BitsDuJour on Facebook BitsDuJour RSS Feed
© Copyright 2025 BitsDuJour LLC. Code & Design. All Rights Reserved. Privacy Policy