Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seek a record in myView1
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00345204
Message ID:
00345244
Views:
17
>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é
Previous
Reply
Map
View

Click here to load this message in the networking platform