Re: trigger to generate primary key.

[ericadelong@xxxxxxxx]

     Yes, the trigger executes before any database validation rules are 
     checked. 
     
     Eric DeLong


______________________________ Reply Separator _________________________________
Subject: trigger to generate primary key. 
Author:  <MIDRANGE-L@midrange.com > at INTERNET
Date:    7/17/98 9:42 AM


Quick question,
     
Can you use a "before" trigger to generate the key value of a file?
     
In other words, say an sql statement does an "insert" into a uniquely 
keyed file, with the key field of zero.  The trigger program then gets 
the next available key field number and updates the "out" buffer with 
it.
     
Thanks in advance,
     
Rick
+---
| 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 
+---
     


+---
| 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
+---