Re: simple (?) problem with forms45

[Quoted] In article <6rv1ph$r5f$1_at_platane.wanadoo.fr>,   "Fabrice Burghgraeve" <Fabrice.Burghgraeve_at_wanadoo.fr> wrote:
> Hello.
> 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.
>
> 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...)
>
>

[Quoted] Hello Fabrice, you could do what you described, but you'll have to write all [Quoted] the functionality yourself. Create your block manually - not based on the db [Quoted] table. Place your code in the ON-CHANGE trigger for CODE item to determine if [Quoted] this is new or existing data. If new - populate two other items ..... and so [Quoted] on. You have a good start here. If you need further help - don't hesitate to [Quoted] post questions. Good luck, Igal

[Quoted] -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 26 1998 - 17:13:36 CEST