Inserting in forms
From: Keith E. Jennings <kej2_at_Ra.MsState.Edu>
Date: 22 Jul 1999 16:47:04 GMT
Message-ID: <7n7hu8$rsi$1_at_nntp.msstate.edu>
[Quoted] [Quoted] how can I insert into a table from a form with just 2 of the 5 columns used for insertion? I have a form with the data block for a table "borrows" containing only 2 of the 5 columns. the other three columns I want to insert with computed values (sysdate for example). My problem is that I don't know how to override the form's insert procedure and use mine. i've tried writing a procedure, but either I've written it incorrectly or i haven't used the correct trigger (I've tried the "insert-procedure" and "query-procedure" triggers)
Date: 22 Jul 1999 16:47:04 GMT
Message-ID: <7n7hu8$rsi$1_at_nntp.msstate.edu>
[Quoted] [Quoted] how can I insert into a table from a form with just 2 of the 5 columns used for insertion? I have a form with the data block for a table "borrows" containing only 2 of the 5 columns. the other three columns I want to insert with computed values (sysdate for example). My problem is that I don't know how to override the form's insert procedure and use mine. i've tried writing a procedure, but either I've written it incorrectly or i haven't used the correct trigger (I've tried the "insert-procedure" and "query-procedure" triggers)
any help would be much appreciated
thanks
keith
kej2_at_ra.msstate.edu
-- Keith E. Jennings THE FunkomaticReceived on Thu Jul 22 1999 - 18:47:04 CEST