(unknown charset) Re: creating text items as runtime in forms 6.0
Date: Mon, 02 Dec 2002 18:29:34 +0000
Message-ID: <3DEBA68E.94401B73_at_spammotel.com>
THIS IS A BASE TABLE BLOCK
[Quoted] Because you are saving the records to different tables I assume they come from different tables. So this form will be based on a view?
This still makes it a base table block.
[Quoted] You then need to override the insert, update and delete triggers on the block. With your own.
Making it non-basetable will mean forms will not bother trying to save anything to the database.
Luc Bosman wrote:
> On 29 Nov 2002 23:13:45 -0800, jimyjoshi_at_yahoo.com (DJae) wrote:
>
> >it is good that u r helping me out..but i thnk u dont get my
> >point..heres what i am doin and what i want.. i am trying to make
> >data entry form for an accounting package which i am developing...this
> >form is to be used for posting journal entries...the sample format of
> >the enteries is like this...
> >
> > TYPE | Account Head | AMT
> >--------------------------------
> > TO | Cash A/c | 2000
> > BY | John's A/c | 1000
> > BY | Ken's A/c | 1000
> >
> > now the number of TO's and BY's may vary depending upon the
> >type of entry..and the entries of type TO go in the credit table and
> >BY go in the debit table..so if u can help me out to create such a
> >form ...
>
> non table based multi record block
> and you'll have to write your own 'on-insert' trigger to insert
> in the right table
> You don't have to care about the possible number of entries
> --
> Luc Bosman
> DEV/2000 Software Engineer
> Database & Network Administrator
> l.bosman_at_iile.be
> ----------------------------------------------------
> | -°) (°- |
> | /\\ Linux the choice of the GNU generation //\ |
> | _\_v v_/_ |
> ----------------------------------------------------
-- Suzuki SV650S - plop. Gone. Kwak ZX-6R J2 - hear the roarReceived on Mon Dec 02 2002 - 19:29:34 CET