Trim char field on select

From: James Garza (jgarza_at_tca.com.mx)
Date: 09/23/04 

Date: Wed, 22 Sep 2004 19:11:03 -0500

When I do a query on a table and display on a DBGrid or other dataaware
component
the string fields have a fixed length, with blank spaces, I think this is
because the fields are of char type on the table structure.

How can I display these fields without Trailing Blanks ? and without
modifying the table structure

James G.
Thanks

Relevant Pages

  • Local dataset show parts in two grids
    ... cursor), and I want to display some of the records in one DBGrid and the ... other in a second DBGrid depending on the value in one of the fields. ... just for display purposes, but these values change the way the grid cells ...
    (borland.public.delphi.database.ado)
  • detail table display order
    ... Using Microsoft Access 2000, ADO and D6 ... Am displaying data from a detail table in a dbgrid. ... composite primary key made up of a text field, ... When you display the detail table within access, ...
    (borland.public.delphi.database.ado)
  • Re: Capture controls to image from program
    ... I would like to capture a snapshot of a DBGrid from within my application and possibly display it in a TImage. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Capture controls to image from program
    ... I would like to capture a snapshot of a DBGrid from within my application and possibly display it in a TImage. ...
    (borland.public.delphi.thirdpartytools.general)
  • Problem with OnCalcFields() Event.
    ... The result J display in DBGrid. ... J need to have numbers on every record in DBGrid. ... My aproach was to make calculated field and write onCalcField event ... Prev by Date: ...
    (comp.lang.pascal.delphi.misc)