Hi...Anyone out there?
I am using VPM 9.1 and creating Views for tables with filters. The app is a conversion from an existing system. All the forms and relations work well and are setup in the DD. I have a program that is run from the main form that merges data from current record and child views. They are related by nFileNo. The code is in a program that is called after a document is selected for the merge.
The issue is that no matter what I do I cannot get the View to give me ALL records, bypassing the filters. Everything is setup correctly in DD and the SQL Find Form works and gives me ALL records when no parameters are entered when using the app.
The code is supposed to do a SELECT with the view and just give me child records for the current record. This is the code that I used to test: ( I need to do this to 19 views as I merge data)
(gnKeyNo is File No of Current Rec)
_SCREEN.oApp.oVPMDataHandler.REQUERYView('Mort_lv')
SELECT * FROM Mort_lv WHERE Mort_lv.nFileNo = gnKeyNo INTO CURSOR Merge_C
SELECT Merge_C
BROWSE &&Displays EMPTY CURSOR
All I get is an EMPTY Cursor. When I use the underlying Table, it works fine. I thought the REQUERY Function with no Filter Array will produce ALL Records. Any suggestions as to why this is happenning and what code is needed to give me the View with all records?
Thanks,
Bill