Re: 1 Datablock/Multiple Datasources

Derek,

    Been away from Forms for awhile, but try this: set the claim_sysid item as a non-database item, and then populate it in the post-query trigger on the block. You can also programmitcally handle the inserts/updates/deletes using the ON-UPDATE, etc. triggers.

Chris

On Fri, 2 Mar 2001 13:16:35 -0500, Derek Sedillo <dereksurfs_at_MailAndNews.com> wrote:

>Hello
>
>I have a case in which I need to point a datablock(PR_INSRD) at 1 of 2
>different tables, depending on user input. I am doing this programatically
>thru using the SET_BLOCK_PROPERTY function for DATA_SOURCE_NAME. This works.
>
>These two tables are identical except for "1 column" (claim_sysid). This is
>a
>required column for one of the tables(cp_insrd). Because it does not exist
>in
>both tables I cannot use it as a database item in this block (PR_INSRD).
>
>How can I programatically include or exclude this column/or
>item(claim_sysid)
>in this data block when performing queries, inserts, updates,etc...?
>
>The easiest way to do this would be include a claim_sysid item in the
>datablock and change the Database item:no/yes programatically. But there is
>no
>set_item_property for this.
>
>Any ideas on this issue would be appreciated.
>
>Thanks,
>Derek Sedillo
>
>------------------------------------------------------------
> Get your FREE web-based e-mail and newsgroup access at:
> http://MailAndNews.com
>
> Create a new mailbox, or access your existing IMAP4 or
> POP3 mailbox from anywhere with just a web browser.
>------------------------------------------------------------
>
Received on Fri Mar 02 2001 - 22:44:06 CET