Thursday, February 25, 2010

Advantage v10 Delphi SQL Property Editor

One of my favorite new features in Advantage version 10 (beta at the end of March) is the new TAdsQuery.SQL property editor in Delphi/C++Builder. No longer will users be greeted with the default Delphi string list editor:

 

boring

 

Instead, you will see the familiar SQL Utility from the Advantage Data Architect:

 

qeditor

 

What does this mean? Now, without leaving your work flow in Delphi/C++Builder, you will have:

  • syntax highlighting
  • code templates
  • access to the query plan
  • ability to create indexes to help optimize the query
  • ability to export the query results
  • find and replace functionality
  • ability to run and preview query results
  • ability to verify query syntax
  • ability to debug SQL scripts

Write your query, preview it, and debug it. Then just click OK and the query is saved to your TAdsQuery instance. It’s all ball bearings these days.

Another cool feature is this is the exact same interface you use inside the Advantage Data Architect (ARC), no need to learn any new functionality, it will all be familiar.

To preview some of the other upcoming features in Advantage version 10 be sure to register for Chris’s upcoming webinars.