Link to home
Start Free TrialLog in
Avatar of koken
koken

asked on

query and dbgrid.

hello.
i am viewing in dbgrid my query results. but i want to see my integer column in ###.###.### (thousand separetor) format.

i can see with table ->dbgrid.
but i can not see query -> dbgrid.

thanks.
Avatar of kretzschmar
kretzschmar
Flag of Germany image

you must provide a display-format for the tfield
at runtime (maybe in the afteropen-event of your tquery

just from head now

for i := 0 to query1.fieldcount-1 do
  if query1.fields[i].datatype = ftInteger then
    TIntegerField(query1.fields[i]).displayformat := '#.##0';


meikl ;-)
ASKER CERTIFIED SOLUTION
Avatar of kretzschmar
kretzschmar
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Alone
Alone

... or try to set this TField property at design-time via Object Inspector... ;-)

WBR...
>or try to set this TField property at design-time via Object Inspector..
yes, of course, if possible
any problems, koken?
Avatar of koken

ASKER

thanks. kretzschmar.

good works.