Re: Trigger question - Null Fields

["Nelson C. Smith" <ncsmith@xxxxxxxx>]

John,

Is  SQL the only way we have to create a field as being null capable in the
first place or is there a DDS equivalent?  Can you change an existing field
to or from being null capable?

Also, I asked on an earlier post which no one responded to, whether anyone
had any experience using the new user defined field objects.  Do you know of
anyone working with them?  They are very interesting to me, since if  I
understand it correctly, we could perhaps move some of the trigger
record-level editing on down to the actual field level.  Also, apparently
this is what the rest of the SQL world uses instead of field reference
files? Is that correct?  If so, how would you control and/or catalog a large
number of them.  Create a whole separate library for them maybe?  Also, I
assume you have to have the C compiler to write code for them too?

----- Original Message -----
From: "John P Carr" <jpcarr@tredegar.com>
To: "MIDRANGE-L" <MIDRANGE-L@midrange.com>
Sent: Saturday, February 05, 2000 12:48 PM
Subject: RE: Trigger question - Null Fields


>
> Yes the Null-capable field will still have "Valid" data for the
> type of field it is even when the associated Null Flag is set to "YES".


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---