[RESOLVED] Database field format in FlexGrid

[DataMiser]

Is using the Flexgrid a requirement? As far as I know there is no way to auto format the data in a flex grid but this can be done easily in a DBGrid. Would you be able to use that instead?

[dglienna]

He wants to CHANGE THE FONT.

[DataMiser]

He wants to CHANGE THE FONT.

Where did you see this? I see no reference to changing font anywhere in the thread except your post. I see that he wants to change the format which is simple with the dbgrid, you can afaik also change the font for the dbgrid as a whole.

[jggtz]

Have you tried to write all the fields of the record instead of use the *
Example
SELECT Fieldname1, Fieldname2, Format(Fieldname3,"dd/mm/yyyy" ), Fieldname4 FROM ...

[dglienna]

Edited to say FORMAT rather than FONT. Don't know what CG did to the edit...

[WoF]

Sorry for late replying, still suffer from sickness.

@jggtz: I have selected the fields to go to the list all by name. No "*".
I will try this:
SELECT Fieldname1, Fieldname2, Format(Fieldname3,"dd/mm/yyyy" ), Fieldname4 FROM ...
although I never saw something like a format statement embedded in an sql query. Thanks.

@DataMiser and David: I used MSHFlexGrid, because I was already familiar to it. I might try DataGrid if you say it can change the format for a column, but I have one thing in common to all lists in the program: I have made sorting occur when clicking on the column headers. Should be able to handle this in a similar way with DataGrid. I will take a look to that control, thanks.

[dglienna]

Normal Flexgrid lets you intercept click events. Look for the FLOATING TEXTBOX examples to replace actual cells with input.

[jggtz]

Right syntax

SELECT Fieldname1, Fieldname2, Format(Fieldname3,'dd/mm/yyyy' ) As Exprname3, Fieldname4
FROM    Tablename1

https://www.google.com.mx/#hl=es-419...iw=800&bih=457

[dglienna]

Why post TWICE?

[WoF]

Seems because there is a link now to the source of the information.

I don't need to change data while in grid view. It is only for display.

[WoF]

Ok, fine.
jggtz, your solution works perfect. I have to change the final query string just before I open the recordset, though, but this is a minor change in the end.

Very good. Thank you.

[HanneSThEGreaT]

good work jggtz

Unbelievable