Home » Developer & Programmer » Forms » How to Identify changed records after querying? (Oracle Forms 10.1.2.0.2, Oracle 11g DB)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: How to Identify changed records after querying? [message #651479 is a reply to message #651478] |
Wed, 18 May 2016 11:19   |
 |
adfnewbie
Messages: 54 Registered: January 2016
|
Member |
|
|
cursor c1 is select a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r from x,y,z where x.a=y.b and y.c=z.d and x.e='123';
This is my query to pull the data. Let's assume it gives me 10 records. User will always work with these 10 records, he cannot create an eleventh one. This data is only for informative purpose. Looking at this data, user will decide for which record he wants to insert/update by making selections from the 2 lov's provided. Problem is, user will not know if that record exists in system or not, it's for me to handle that if a record corresponding to user's selection is available/present in the table, it should simply update, if not, it should create a new one.
|
|
|
|
|
Goto Forum:
Current Time: Mon Jun 02 15:08:16 CDT 2025
|