Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views and recno()
Message
From
05/08/2002 14:58:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Views and recno()
Miscellaneous
Thread ID:
00686281
Message ID:
00686281
Views:
75
Hi!

Something kind of weird Have been happening to me using Views.
Here is the scenario: I began playing with a view, every time
I got new records for display I wanted the pointer remained in
the same record after adding the new ones, So I used a little
routine applying recno() and it worked well. Then I decided to
apply the same code in a more complex view (conformed by a cursor
and another view), but unfortunately the code didn't work, now
it turns out that the record number changes dynamically as I Add
new records to the view, that is to say, that the record that once
was number 1 now could be 3 and so on, with this problem is im-
possible to remain in a determined record after updating a view,
I even could go to an unexisting record in case the number of
records of the view get reduced.

What am I doing wrong?

Could be that the complexity of the view makes the record number
changes dynamically?

Could this problem be related with the keyfield property of the
view?


TIA
Next
Reply
Map
View

Click here to load this message in the networking platform