Hi, I have a customized file which has 1Lakh records. We are using an ERP tool. We created an object in that tool using this customized file. So when we open that object in the view, it will list out all 1 Lakh records. Now I am updating only 10 records. So it will update in my file. At the end of the day users will try to update some other files using these customized files, so we provide an icon for them to update their files
1. Using Cursor we can do this-but SQL not allowed (we can't use) 2.Reading my customized file and updating their files- Due to 1 lakh records, performance will be very slow. So I need to go with some other technique. Please give me some idea.