simple (?) problem with forms45

From: Fabrice Burghgraeve <Fabrice.Burghgraeve_at_wanadoo.fr>
Date: Tue, 25 Aug 1998 21:05:05 -0000
Message-ID: <6rv1ph$r5f$1_at_platane.wanadoo.fr>



Hello.
[Quoted] I have a simple problem that i can solve with forms. for example, suppose the table is :
table names
code varchar2(3) promary key
first_name varchar2(30)
last_name varchar2(30)

I want to create a form, that displays the 3 fields, and that does the following :

The user enters the code and press enter (or tab...) If the codes exists, forms shows the actual data, goes to first name. The data will
then be modified
if it does not exists, forms goes to the first name, and can create the new entry
in the database.

The question can seem simple... I can't find a simple response... the aim is to avoid to press 1000000000 keys to go in query mode, execute query
and so on.
Our customers have this habit with our actual program, and we can't imagine the
reaction they will have is this habit change. We cannot do that. The way the program works actually seems the best.

[Quoted] Thank you for your help...

Fabrice Burghgraeve

Fabrice.Burghgraeve_at_wanadoo.fr
(excuse my poor english. I am french and have not written down english for monthes...) Received on Tue Aug 25 1998 - 23:05:05 CEST

Original text of this message