Hi all,
I am facing weird behavour of SQL View (local and remote).
In one of my data entry form I am using local views. The form has a print button which prints details of current record. In click event of I have written
SELECT Vendor.cVendNm,....... FROM v_vendor,.....
INTO CURSOR cRepCursor
Resultant cursor(cRepCursor) does not show right values When I
modified somedata and click the print button without saving it. It shows original retrieved data from the table. This happens with SQL Server Remote views as well.
SCATTER MEMVAR works well and gives current values.
BTW View has Optimistic Table Buffering (5).
Please help me out.
Waiting for quick responce.
Thanks in advance
Jayesh
- Jayesh