Active Query Builder support area

Make a preview of query results

Avatar
Anonymous
  • updated
  • Completed
Replies 9
Avatar
0
SARA EDWARD

ok good

Avatar
0
Anonymous

We've choosen another option of the component's UI improvement. We plan to transpose the Query Columns Grid and add the query results preview to the bottom of it. The new UI will be mainly operated by taps or mouse drag'n'drop operations. This is our task for the next major version.

Avatar
0
Anonymous
Below is the code from the new demo project "Subquery Results Preview" that was added in the latest version of AQB VCL Edition:

     // limit query results to 10 rows for preview purposes
     tempQueryBuilder := TacQueryBuilder.Create(nil);
     try
       tempQueryBuilder.WorkOffline := true;
       tempQueryBuilder.SyntaxProvider := queryBuilder.SyntaxProvider;
       tempQueryBuilder.Sql := queryToExecute;
       tempQueryTransformer := TacQueryTransformer.Create(nil);
       try
         tempQueryTransformer.queryBuilder := tempQueryBuilder;
         tempQueryTransformer.ResultCount := '10';
         // get modified query
         queryToExecute := tempQueryTransformer.Sql;
       finally
         tempQueryTransformer.Free;
       end;
     finally
       tempQueryBuilder.Free;
     end;
Avatar
0
Anonymous
Dear Joe,

This functionality is added to the demo project of .NET edition. VCL Edition has the demo project with the same functionality as the .NET "Full-featured MDI demo" (except the ability to preview sub-query results). It can be found in the "Demos\DemoApp" folder. We will send you the sample source code for Delphi to implement this functionality. This code is based on the QueryTransformer API.
Avatar
0
DAVID GRIFFIN
Where do we (registered user of the VCL Standard edition) download the "Full-featured MDI demo" ?  The demo is compiled so we cannot see the code samples.

Thanks,
 ... Joe
Avatar
0
Anonymous
We have added the ability to preview query and sub-query results to the Full-featured MDI demo. Anybody who wants to add this functionality to his application can copy the code sample from this demo to implement the same.
Avatar
0
Anonymous

For those who voted for this feature, could you please let us know, for what edition of Active Query Builder you want this feature to be implemented? Why the standard grid does not satisfy your needs? What additional functionality you want to see in this preview?

Avatar
0
Anonymous

This looks like a good idea. We will start implementing this feature from the ASP.NET version.

Avatar
0
Anonymous

This could be a good idea. We will start implementing of this feature from the ASP.NET version.