>Hi !
>I have a problem with a view :
> I create a cursor in VFP on a SQL Table by using SQLCONNECT,...
>And after I have done some updates in my cursor, I check the data in the cursor :
> With the « browse command », my updates are there, but if I check them with the command « Select * from my_cursor », the updates are not there until I do a TableUpdate.
>
>Can I see the updates in my cursor with a « Select * » before I do a TableUpdate.
>
>Thanks in advance ! !
>
>Stef :)
Stef,
No, you cannot do it through SELECT, but you can use the workaround with COPY TO ARRAY.
In this sample the cursor tmp_categs is created from the table buffered cursor containing some changed categories information, but not TableUpdated yet.
=AFIELDS(laCategs, "CATEGS")
CREATE cursor tmp_categs from array laCategs
SELECT lv_categs
COPY to array la_lv_categs
SELECT tmp_categs
APPEND from array la_lv_categs
HTH,
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison