DelphiFAQ Home Search:
General :: Programming :: Delphi :: Database
Database development with Delphi. Includes issues with BDE, ADO and InterBase.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

This is the FULL list of all articles in this category.

Featured Article

Customizing the display of IBObject queries

If you use IBObjects for your InterBase client application, you can use the powerful TIB_Cursor and TIB_Query to modify how your query results will look for example in a grid. Take a look at the sample source code below.

Note:
All those settings can be made via the object inspector, but when the SQL property is updated at
runtime with a new query, some of these properties seem to get wiped out.
Therefore it's better to set them at run-time in code.

begin
   with TIB_Query1 do
   begin
     FieldsVisible.Add('ID=F');
     FieldsVisible.Add('SLNR=T');  { not really necessary }
     FieldsCharCase.Add('LAND=UPPER');
     FieldsDisplayLabel.Add('COMMENTS=Your Comments');
     FieldsDisplayWidth.Add('COMMENTS=200');
   end;
 end;
 
 
You don't like the formatting? Check out SourceCoder then!
Generated 12:01:16 on Jun 4, 2020