Re: oracle interface

Do you own the VB app? If so, then just modify it, add a "create new plan from current plan" button and write the code behind it to set up a new plan with a new name as a copy of an existing plan updating/inserting as appropriate into all necessary tables that make up a plan.

If it's a 3rd party app that you really cannot modify, you will have to write a new application screen or routine in order to do what you want. If all the info for a plan is in 1 table, this is trivial. If not, then your routine will have to know what tables to insert/update with all the info from an existing plan except with a different name.

HTH

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR
"Opinions are my own and do not reflect
  those of Keane or my clients"
wyo <wyo_at_yoyo.com> wrote in message news:8jvv8c$dc9$1_at_news.cs.utexas.edu...


> hello everyone...i'm looking for a simple and cheap solution to my


> problem...

>

> problem: the current VB app i use to interface with my oracle database

 pumps


> data into my database and gives me the ability to view what is in it. i


> categorize the data in my database as "plans."  so i interface and name a

> plan and manually enter data, then i submit it into my database. to view

 it


> i click on the name of the plan and it spews out all the information i


> entered in manually.

>

> HOWEVER...if I want to create a new plan that is essentially identical to

 an


> old plan, I need to name the plan and enter in all the information again


> even though a lot of the information is in the database.

>

> I am looking for something that will

> 1) allow me to create copies of a certain "plan"

> 2) allow me to modify information in the new "plan"

> 3) work with oracle

>

> if anyone has any suggestions...i would be very grateful. thanks.

>

> Winston

>

>