NULLS NOT ALLOWED

[Peter Bateman]

Hi all:

If you are still using 710 you may want to get rid some
unexpected nulls by giving each column a default value
in your database.

Situation:-

1) 'NULLS NOT ALLOWED' is specified in a 710G dictionary

2)  I do not reference an  Oracle/Rdb  column in a QUICK srceen

3) The corresponding element does not have a initial value

then QUICK 710G does NOT insert a value for the column.

If I do have a non-default value initial value then QUICK does
insert it!
e.g.
Suppose X is a column in an Oracle/RDB table.
   Ele x c 6 initial 'QERTY'
then QUICK 710G does insert 'QERTY'

However, Ele x c 6 initial '      '
then QUICK 710G does NOT insert '     '

Workaround:

  Ensure that each column in the database has a declared default value.

or reference each column in the screen.
e.g. FIELD X SILENT

_________________________________________________________________
Enter to win a night a VIP night out at TIFF 
http://redcarpet.sympatico.msn.ca/