Thank you Daniel

Franky

-----Oorspronkelijk bericht-----
Van: Daniel Rail [mailto:daniel@...]
Verzonden: vrijdag 5 december 2003 15:09
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] Limit size of a field in Delphi


Hi,

At December 5, 2003, 08:37, Franky Brandt wrote:

> 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

Look at the editmask field property. The edit mask to limit the entry
to 20 characters would be: cccccccccccccccccccc. You can search in
Delphi's help for TEditMask type to find what kind of syntax taht you
can use in a mask.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12ceuhnla/M=267637.4116732.5333197.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1070719796/A=1853618/R=0/*http://www.netflix
.com/Default?mqso=60178338&partid=4116732> click here

<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egrou
pmail/S=:HM/A=1853618/rand=616549795>

________________________________________________________________________
___
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
________________________________________________________________________
___
http://www.ibobjects.com <http://www.ibobjects.com> - your IBO
community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .