Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seek a record in myView1
Message
From
14/03/2000 00:22:37
 
 
To
13/03/2000 20:42:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00345204
Message ID:
00345223
Views:
16
>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)

Since views don't have indexes unless you specifically create them after the view is opened, you can't just SEEK(). Easiest way to find a record in a view is with LOCATE.

LOCATE FOR someField = Somevalue

You can create an index on a view after the view is opened using the same syntax used to create an index for a table. You just have to ensure that the view's buffermode is set to record buffering, using DBSETPROP().
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform