>Hi, all
>
>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.
>
>Thank's in advance,
>
>João Batista
>(Beginner VFP 6.0)
Joao,
You could use the LOCATE FOR command. Or index your view on its PK and then make a seek. But since views are mostly intended for small record sets, the best way, in my opinion, would be a parameterized view:
Suppose the value of the PK you want to search is "XYZ"
vp_pk = "XYZ"
SELECT...
WHERE myPk =?vp_pk
This will retrieve the matching record.
José