This could be a good idea. We will start implementing of this feature from the ASP.NET version.
This looks like a good idea. We will start implementing this feature from the ASP.NET version.
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?
// 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;
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.