Contents

I. AutoDBGrid
1) How can I make the columns sorted descendent ?
2) I can't create the sorted columns for AutoDBGrid. 
3) I can't make to work the AutoDBGrid with AutoQuery.
4) My DBGridDateBtn doesn't work.

II. Visual Filter Components
1) My filter of the AutoTable doesn't work.
2) I don't want to change my macros at design time.

III. DBReference
1) How can I add controls to the bottom of the DBReference popup form ?
2) I can't understand how to display reference Text.


I. AutoDBGrid

1) 
Q.
How can I make the columns sorted by descendent
A.
If you use AutoQuery it is not a problem but as I understand you use the Table as DataSet for AutoDBGrid and you have the ascendent index for that field. In this case you have to add the index file for the field which have to be descendent and AutoDBGrid is smart enough to allow the user sorted as ascendent and as descendent. 
PS: Use AutoQuery and you will not have the problem and in this case you will be able to sort any field as you want.

2)
Q.
I can't create the sorted columns for AutoDBGrid. I use AutoDBGrid and  AutoQuery.
A.
You have to create the DBGrid columns or Query Field at design time. To create the sorted column just press Ctrl and press the Left mouse button.
Why you have to do it ?
Because we need save the information about sorted columns. We save it in this case:
If the first character of the column label is '+' then the sorted is ascendant,
if it is '-' then descendent, other is not sorted. 
You also can create it at runtime  (see help file: The main features -> Sorted TAutoDBComponent for more information) 

3)
Q.
I can't make to work the AutoDBGrid and AutoQuery. Always the error:
 'Invalid use keyword. Token BY' is appeared. I do as in example:
Add to AutoQuery macro '&Orderby', drop FilterLink and link the AutoDBGrid with the macro of the AutoQuery. What is happen ? Is it a bug ?
A.
You forgot to assign the TextBefore property of the AutoFilter of the AutoDBGrid: AutoDBGrid.AutoFilter.TextBefore := 'Order by ' (don't forget to add the space to the end of the string). It works in this case: 
AutoQuery.MacroByName('orderby').Text := AutoDBGrid.AutoFilter.Text;
Where AutoDBGrid.AutoFilter.Text = AutoDBGrid.AutoFilter.TextBefore + AutoDBGrid.AutoFilter.Value  + AutoDBGrid.AutoFilter.TextAfter, where AutoDBGrid.AutoFilter.TextBefore = 'Order by ' and AutoDBGrid.AutoFilter.Value = '<sortedfieldname> [DESC]'. 
Of course the FilterLink is smart  to do it itself, without adding code.

4) 
Q.
My DBGridDateBtn doesn't work.
A.
You have to create the DBGridColumn at design time and your DBGridDateBtn will be work perfectly.


II. Auto Visual Filter Library
1)
Q.
My filter of the AutoTable doesn't work.
A.
The typical error is when you try to compare the macro with the constant. The macro is the constant and BDE doesn't allow to compare the constants in BDE filter. Don't try to create a complex expression in Filter property.
Use the Params in Query (AutoQuery) and your filters will be worked perfectly.
2)
Q.
I don't want to change my macros at design time. Can I do something with it ?
A.
Yes it is very simple. Set the MacrosFreeze to nfDesigning.

III. DBReference

1)
Q.
How can I add controls to the bottom of the DBReference popup form?
A. 
For this purpose we've created TReferencePanel. You can place on it any Delphi controls (especially useful to place the Visual Filter Control on it) and then assign it to the ReferencePanel property of the DBReference. Use component Editor 'Change Style' of the ReferencePanel and you'll understand how to add the controls to the popup form at design time.

2)
Q.  
I can't understand how to display reference Text.
A.
At first set the property VisibleText to True (You also can use the 'Change Visible Text' component editor). Then Set the PatternText (use property Editor). For more information see help for PatternText property.