Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GO to a negative recno in a optimistic table buffered cu
Message
 
To
12/07/2005 11:09:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
Miscellaneous
Thread ID:
01031593
Message ID:
01031732
Views:
17
Strange, I remeber well this happens. Unfortunately I can't test it now because I didn't have VFP6 installed. May be in versions before SP5 it behaves that way?


>>Fabio, in what version of Fox you test this? Because I had a similar problem when I used VFP6.
>>
>
>VFP6SP5,VFP8SP1,VFP9
>
>>>>Hi
>>>>
>>>>My grid has a optimistic table buffered cursor to it. Now the new records I add are -1, -2 and so on. If I store the recno and the I try to goto it I get an error.
>>>>
>>>>How can I tackle this. I tried locate recno() = mysavedrecno but that did not position the pointer back to the newly added record.
>>>>
>>>>What am I doing wrong.
>>>
>>>You have other problems, GO is OK:
>>>
>>>CLEAR
>>>SET MULTILOCKS ON
>>>
>>>CREATE CURSOR testnegregno (pk i,tx c(20))
>>>CURSORSETPROP("Buffering" , 5)
>>>APPEND BLANK
>>>TABLEUPDATE(.T.)
>>>APPEND BLANK
>>>rn=RECNO()
>>>GO 1
>>>? RECNO()
>>>GO m.rn
>>>? RECNO()
>>>
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform