SQL

A community portal about SQL with blogs, videos, and photos. According to Wikipedia.org: SQL is the most popular computer language used to create, modify, retrieve and manipulate data from relational database management systems. The language has evolved beyond its original purpose to support object-relational database management systems. It is an ANSI / ISO standard.

Write an Article

Join

RSS

A5 V9 feature peek #39: SQL query guide

Written by rrabins on

From: alphasoftware.blogspot.com

Many of you depend on Alpha Five's genies. (Because -- let's face it -- they're awesome.) In Alpha Five Platinum, we wanted to give the SQL query genie window a big boost. And boost we did.

Here's a list of all the changes we made:

1. The new SQL query genie can be displayed as a MDI window.
2. Several instances of the query genie window can be opened simultaneously.
3. The SQL query genie can now be opened directly from the tools, external databases menu command when the control panel has focus.
4. The toolbar has a connection string dropdown that allows you to easily execute a query against different databases.
5. The Action button on the toolbar brings up a dialog that lets you to perform an action with the SQL query you specified.

And now there are even more actions supported when you click the Action button. You can copy SQL to clipboard, import the data from the query as an Alpha Five table, create a passive-link table from the data in the query, and create a new layout (report, label, or letter) with the data in the query.

So click away, developers, because now you'll be getting real action from those SQL query genies.

	Camera Buying Tips A picture is worth a thousand words, but not all cameras are worth a thousand bucks.
	Can Blackberry or Palm gives Apple a run? The iPhone is the new kid on the block, but its popular for a reason.
	Add Borders to Images Borders around images can give your site a cleaner look.