Subject | Limit size of a field in Delphi |
---|---|
Author | Franky Brandt |
Post date | 2003-12-05T12:37:21Z |
Hi,
I thought this would be simple but i can't figure it out :(
Let's say i have a field in a table of varchar(60) but i have a customer
who wants it to be 20 chars only.
I can't change the database or the updatescripts as it has to be 60 for
all other customers..and i'd prefer not to make a seperate version for
one customer.
With a IBOtable i can change the .FieldByName(afield).Size := 20; and
.FieldByName(afield).DisplayWidth := 20; from code but i can't set the
size of a field in TIb_Query
Any suggestions?
Franky
I thought this would be simple but i can't figure it out :(
Let's say i have a field in a table of varchar(60) but i have a customer
who wants it to be 20 chars only.
I can't change the database or the updatescripts as it has to be 60 for
all other customers..and i'd prefer not to make a seperate version for
one customer.
With a IBOtable i can change the .FieldByName(afield).Size := 20; and
.FieldByName(afield).DisplayWidth := 20; from code but i can't set the
size of a field in TIb_Query
Any suggestions?
Franky