yes, i have full control about app and database

the datatype for the limited range is numeric and varchar for the
unlimited one

i will think about your idea, it's interesting, thx

Le 04/11/2011 16:40, Milan Babuskov a écrit :

>
> Tetram Corp wrote:
> > I thought about this solution but hoped there was a better one because
> > of, you're right, in my case the field has a restricted range but i've
> > an other similar case where there's no limit in value range
> >
> > too bad. I will use this trick for my first case, and think again about
> > app design for the second one
>
> Do you have a complete control over database and application?
>
> What is the datatype of column?
>
> Here are some ideas: If you have a varchar column, you can solve it by
> increasing the column size by 1 character and make sure default uses all
> characters. For example, if your field is normally char(3), you can
> increase it to char(4) and set 'XXXX' as default. Restrict the data
> entry in application to only allow 3 characters.
>
> --
> Milan Babuskov
>
> ==================================
> The easiest way to import XML, CSV
> and textual files into Firebird:
> http://www.guacosoft.com/xmlwizard
> ==================================
>
>

[Non-text portions of this message have been removed]