Hi Helen,

I agree with you, but I've a lot of clients using my software and the
NULL string field was not important when the software was developed.
I'll have a lot of work and perhaps problems with validations if I alter
my database defining all string fields as NOT NULL and the default value
as a empty string.

If I alter the database I'll need to import the actual database to a new
and do the validations of null fields.... It'll give me a lot of work!

I stay surprise with this because it doesn't occour in Oracle databases.

Thanks

Fabrício F. Kammer

-----Mensagem original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Helen Borrie
Enviada em: segunda-feira, 9 de janeiro de 2006 20:21
Para: firebird-support@yahoogroups.com
Assunto: Re: RES: [firebird-support] String Concatenation with null
field


At 06:22 PM 9/01/2006 -0300, you wrote:

>OK Martijn Tonies,
>
>But this is the unique form? My scripts will increase a lot in size

with

>this.

The other alternative is to define as NOT NULL any fields that you want
to
concatenate and enforce an empty string as the DEFAULT.

<sermon>
Basically, if you have one business rule that requires a column to be
non-nullable - e.g. your concatentation requirement - then another
business
rule that violates that rule - e.g. the column definition allowing nulls
-
is a design fault. The fact that, since Fb 1.5, you could work around
such
design faults by using COALESCE() does not mean you have cured the
original
design fault.

Potentially any design fault is going to cost you extra keystrokes in
DSQL,
in perpetuity, to work around it, as well as the constant risk that some

time, some developer is going to forget that the fault exists. Is it
worth it?
</sermon>

./heLen




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++





SPONSORED LINKS
Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+supp
ort&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w
4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Micro
soft+technical+support&c=6&s=196&.sig=-XIO8GxY6hqd3NaD5WSEyw> support
Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Techn
ical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+
support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support
&w6=Microsoft+technical+support&c=6&s=196&.sig=B29J78SYXnNTjjMFBMznqA>
technical support Compaq
<http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w
1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+tec
hnical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+
support&w6=Microsoft+technical+support&c=6&s=196&.sig=7_je1A94xs82CFXUjE
qA6g> computer technical support
Compaq
<http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technic
al+support&w2=Computer+technical+support&w3=Compaq+computer+technical+su
pport&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w
6=Microsoft+technical+support&c=6&s=196&.sig=2zMAuRCo5cJrVBr1Bxa3_w>
technical support Hewlett
<http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w
1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+tec
hnical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+
support&w6=Microsoft+technical+support&c=6&s=196&.sig=_ytYU7aXb57AVaeUfm
vLcA> packard technical support Microsoft
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+technical+support&w1=Tech
nical+support&w2=Computer+technical+support&w3=Compaq+computer+technical
+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+suppor
t&w6=Microsoft+technical+support&c=6&s=196&.sig=4hRo6NXYavRAbTkaYec5Lw>
technical support

_____

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

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


_____




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