Re: Nope, Pre_Insert trigger dosen't work...
From: ACJohnst0n <acjohnst0n_at_aol.com>
Date: 09 Oct 2000 20:43:52 GMT
Message-ID: <20001009164352.25182.00001126_at_ng-da1.aol.com>
Date: 09 Oct 2000 20:43:52 GMT
Message-ID: <20001009164352.25182.00001126_at_ng-da1.aol.com>
Richard,
If, for example you want to use the sequence number to populate a column when the record is created (and saved), then use the pre-commit trigger on the record's block to fetch the sequence_no and assign the value to the base-table field which is to hold the sequence_no.
If you want to display the records when the form starts up, use the
when-new-form-instance trigger and code something like this
"query_details('MyBlock');" if the query_details function is present, or
"go_block('MyBlock'); execute_query;". If the block you want is the only
block or first block, just code "execute_query;"
Hope that works for you. Happy coding
Cheers
AJ
Received on Mon Oct 09 2000 - 22:43:52 CEST