Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seek a record in myView1
Message
 
To
14/03/2000 23:37:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00345204
Message ID:
00345691
Views:
15
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform