Home » Developer & Programmer » Forms » transfer data from one table to another (developer 6i second release)
transfer data from one table to another [message #291950] Mon, 07 January 2008 05:25 Go to next message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
Dear all
I have 2 tables the first one has information about a catogary (id,name,price,totals) the secon one has information for the buyer (name,id,name,price,qty,...)
can I get the information in table 1 to table 2 when i choose the id in table 2 (name,price)
by using a procedure????
best regards
Re: transfer data from one table to another [message #291953 is a reply to message #291950] Mon, 07 January 2008 05:28 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Can't simple insert with select serve your purpose?

By
Vamsi
Re: transfer data from one table to another [message #291973 is a reply to message #291950] Mon, 07 January 2008 05:59 Go to previous messageGo to next message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
please can u tell me how
Re: transfer data from one table to another [message #291979 is a reply to message #291973] Mon, 07 January 2008 06:06 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is the relationship between those two tables?

For example, if user selects "name and price in table 2" and these are "shraf_al_ani 100", what would you like to take from table 1 (which contains something like "1 - apples - 0.40 - 2234")?
Re: transfer data from one table to another [message #292409 is a reply to message #291950] Tue, 08 January 2008 21:53 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I assume that this is an assign question.

You need three tables "catogary", "buyer", and a 'cross reference' table that by storing the 'id' of the "catogary" and the 'id' of the "buyer" would then contain the number of items purchased and their date. The rest (total price, etc) you derive at run time.

(By the way you can't have two fields both called 'name' in the second table).

David
Previous Topic: Help: How do I display canvas banner/Graphic image from jar file
Next Topic: FRM-92101:there was failure in forms Server during startup
Goto Forum:
  


Current Time: Wed Dec 07 14:56:06 CST 2016

Total time taken to generate the page: 0.07316 seconds