Mega Code Archive

 

Categories / Delphi / Examples

 

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;