Jayesh,
SQL only reports data that has been committed. This includes
when you do a SELECT against a view which has uncommitted
changes.
-myron kirby-
===============================
>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