Active Query Builder support area

Make a preview of query results

Avatar
  • updated
  • Completed
Avatar
Anonymous

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

Avatar
Anonymous

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

Avatar
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
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
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
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
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
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
SARA EDWARD

ok good