General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using Views in Select Code Into Cursors
Hi,
This may be a dumb question but it is baffling me. I'm new to using views, not FoxPro and I am converting an existing system. I have a main form which I can select a stored document and Merge certain fields into WORD from the current record. The Main form called Statmain (a View-Statmain_lv), has numerous child views within it. It works fine but I am have a problem getting the Child data into the Merge form. The connecting tag is nFileNo N(9). I'm using Promatrix Framework and all the relations are stored in their DD.
After selecting the Document to Merge I call the Merge.prg. I can reference all the fields from the Main Statmain Form but cannot seem to open any of the child views. I use the Open/Requery functions and it doesn't seem to work. This is my select statement to get child records from a Mortgagor's Table:
SELECT * FROM Mort_lv WHERE Mort_lv.nFileNo = Statmain_lv.nFileNo INTO CURSOR Merge_C
I then browse and get no Child records. The Mort_lv is filtered but the Promatrix Data Handler should return all records if no parameters are passed using their OPen/Requery Function.
Any suggestions would be appreciated. I'm probably missing something simple.
Thanks,
Bill
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only