Publish Filter Expression in FilterDialog
Francisco A Alvarado
Joined: 02 May 2015
Topic: Publish Filter Expression in FilterDialog
Posted: 15 May 2015 at 11:52pm
I'm using custom sorting in DBAdvGrids. A query must concatenate three elements:
"SELECT * FROM DBTable" following by a filter condition "WHERE xColumn = 'ABC' " and a order clause "ORDER BY yColumn"
The second element is now obtained from Scalabium's SMDBFilterDialog component. It has a property -Expression- that contains the filter built in the dialog. So the task is easy: SELECT * FROM DBTable ' + ' WHERE ' + SMDBFilterDialog1.Expression + OrderClause.
The Order Clause is from OnCanSort event from the DBAdvGrids1.
I hope I explained the usefulness of publishing Filter Expression in your component.
Joined: 11 May 2010
|Post Options Quote Reply Posted: 17 May 2015 at 8:03pm|
The event DBAdvGrid.OnSetQueryOrder is triggered that passed this expression as event parameter.
|Forum Jump||Forum Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum