I am developing an on-line screen program, where the user can select a view of the data from a list of "views". This is my first crack at embedded SQL,
Basically i issue the Prepare, declar the c1 scroll cursor, and then open c1, and then do the fetch. At this point I am loading the subfile.
First view displays fine..
Then they go to the selection window and select a different view. At this point I
- clear the subfile
-close the cursor (c1)
and go thru the same previoys steps, but the prepare is based on a select statement with a different LF view.
I get data displayed, but it is not in the correct order as the LF, and I have found some records missing. Not sure if I am missing something. If there is a good web-site that I could go to for further info, that would be helpful.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!