Frequently asked questionsI want to upgrade to the latest version.
When you purchase the license, you also get a one year of free product updates. After that if you wish to be able to use the new product versions you need to buy the annual software maintenance subscription. It will cost you about 20% of regular product price per year.
Can I pay by purchase order?
Yes. Just click on "Buy now" button and select "Purchase order" in the "Payment method" field.
Is it possible to export/save query result to Excel, text file or some other formats?
It is possible but EasyQuery will not help you with this task just because it does have such functionality.
EasyQuery itself just provides a friendly user interface for query building and
generates SQL statement by user input. You can do with that SQL statement anything you want.
In our demo application (placed at www.easyquerydemo.com) we just execute
generated SQL and show the result of execution in a grid. I think it will not be
difficult to add code that export query result into some format (Excel, text, PDF, etc) or print it.
There are many other solutions which allows to do it.
What SQL dialects do you support? MS SQL Server, DB2, Oracle, MySQL, etc?
EasyQuery.NET can generate result for all most used SQL servers. At least all listed in this question are supported.
Our Query component has several properties which allow to specify the format of date/time values, the syntax of table links, quote symbols and other options which help you to "tune" the result SQL syntax for necessary dialect.
What about protection from SQL injections in EasyQuery.NET?
Actually EasyQuery.NET only generates SQL statement but does not execute it - so you can check generated statement before execution.
Besides that our components prevent any possible attempts to include additional SQL commands into generated statement. All values, entered by user will be quoted in case of using string type or an exception will be raised if something abnormal is entered for numeric or date/time values. How could I construct queries with GROUP BY clause with EasyQuery.NET?
You do not need to worry about GROUP BY when create a query in EasyQuery.NET.
It will add this clause automatically when you use at least one aggregate column in query results. To make a column aggregate in QueryColumnsPanel you should add it first, then click on the button near it and select "Aggregate" in the menu that appear.
|
|
|
