>>What's the way i seek a record in myView, i have her PK and i want to find him and get their values to local vars.
>
>You can do a LOCATE or first build the index programmatically, then do a regular SEEK(). You could also do another SELECT - SQL to return only record you want.
Joao, note also that you cannot index the view in Table buffering mode, but if you need it, you may switch your view buffering to Row with CURSORSETPROP("Buffering", 3, "myView1"), index it and switch back to Table buffering with CURSORSETPROP("Buffering", 5, "myView1")
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