Re: Inserting in forms

hi
I am guessing that the two columns you have in the form app should be base table items . If so then add rest of the columns in the same block as base table item but since you donot want user the view them set their display property to false. Then the rest will be easy as piece of cake.. just manipulate or compute the data that you want to insert and put the values into the respected items utilizing pre-insert trigger. to my experience you should be fine
HTH
pradhan

Keith E. Jennings wrote in message <7n7hu8$rsi$1_at_nntp.msstate.edu>...
>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 Funkomatic
Received on Thu Jul 22 1999 - 23:57:45 CEST