Re: Advice requested

Q2. Try to make a WHEN-VALIDATE-ITEM on your non DB field:

Set_Block_Property( 'Your_DB_Block', DEFAULT_WHERE, 'Where clause' ); Go_Block( 'Your_DB_Block' );
Do_Key( 'Execute_Query' );

Regards,
Aleksandr Kononov

In article <3a3f80ab.1208718425_at_nntp.uunet.ca>,   pbeliveau_at_avcorp.com (P B) wrote:
> I am using an old database and I want to transfer to Oracle. I need
> advise on how to setup the database.
>
> Q1: Should I create my new db as normalize as possible or should I try
> to fit it to my application. And if I create it normalize, should I
> create a view that will fit each application or go without view (what
> are the pro and con) ?
>
> Q2: I've ask how to create a form on which there is a field that
> contain a primary key. If I enter something into that field, the
> EXECUTE_QUERY will be done automatically. To do that, I had to create
> two data block, one with a non-database block and the other with a
> database block. Then in the trigger WHEN-NEW-BLOCK of the database
> block, I put the EXECUTE_QUERY. It work fine, but it is painfull to
> create form that way. Is there another way to do that? (meaning
> automatically loading a record when enter a primary, for example, if I
> type a part number, I what the description to show beside it and I
> want to be able to modify it)
>
> Q3: I've bought books and start reading them, but I miss some simple
> yet tangible example. Can you point me to some good example.
>
> THANKS VERY MUCH
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 21 2000 - 08:56:51 CET