Home » Developer & Programmer » Forms » a form extract data from a table & save in another one (only at insert) (10g)
a form extract data from a table & save in another one (only at insert) [message #326883] Thu, 12 June 2008 23:29 Go to next message
amdabd
Messages: 91
Registered: November 2007
Location: My Computer
Member
hi,
how could I implement this situation

./fa/4428/0/

the form based on TABLE EMP2 (insert, update, delete, query, save)
only at insert process the data is extracted from TABLE EMP1 according to my criteria to be modified and saved in TABLE EMP2.

thanks

  • Attachment: 1002.JPG
    (Size: 24.62KB, Downloaded 216 times)
Re: a form extract data from a table & save in another one (only at insert) [message #327250 is a reply to message #326883] Sun, 15 June 2008 12:56 Go to previous messageGo to next message
amdabd
Messages: 91
Registered: November 2007
Location: My Computer
Member
OK,

how to create and use cursor for query a table and reuse data within a form ?

thanks
Re: a form extract data from a table & save in another one (only at insert) [message #337081 is a reply to message #327250] Tue, 29 July 2008 21:07 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did you solve your problem?

David
Re: a form extract data from a table & save in another one (only at insert) [message #337976 is a reply to message #326883] Fri, 01 August 2008 18:55 Go to previous message
amdabd
Messages: 91
Registered: November 2007
Location: My Computer
Member
hi, dear David
thanks for your concern,
I used a cursor within a button to get data .
thanks again.
Previous Topic: Forms 10g installation
Next Topic: PL/SQL equivalent of ROLLBACK in Oracle Forms
Goto Forum:
  


Current Time: Thu Dec 08 04:04:35 CST 2016

Total time taken to generate the page: 0.07598 seconds