Field Title Description URGENT

[sfxcc]

How can i create field description , or title for each field on firebird.
And how can i get it ... i suppose it is with metadata but dont undestand meta data yet

What i want to do is :

When i assign to a dbgrid a dataset want to set a readable name on title and not the fieldname...

In case off "CL_CLIENTES" i want "NOME CLIENTE" in dbgrid Caption Title and not "CL_CLIENTES"

So there exist anything similar to this
CREATE TABLE CLIENTES(CL_ID,CL_CLIENTES description "NOME CLIENTE" bla bla )


Does zeus already does this for me ?????

. .. ????

[mdaems]

Code: Select all

select cl_clientes as "Nome Cliente" from clientes

should do the job. "AS" is optional.

[sfxcc]

Thanks for your answer.


The problem is i have a ztable and a dbgrid.
and i wanna do ztable.open. and the db grid title dont be the field name and "i dont wanna do it manualy on dbgrid".

I want to save it on db with the field.

Like create table ( myfield integer "mydecription",....);

and get it with metadata or so thing??

ant least to do
for aa:= 0 to ztable fieldcount-1 do
begin
dbgrid.columns[aa].title.caption := ztable.metadata.field[aa].description; witch is "mydescripton" on the create table.
end;

Any one have an idea to do similar to this this ????

[mdaems]

I'm afraid this can't be done with zeoslib 'out of the box'.

Mark

[sfxcc]

Ok this solved tehre is a fb SQL command witch is COMMENT so comment fields