Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this a bug???
Message
 
 
To
26/05/1998 16:13:18
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00102045
Message ID:
00102106
Views:
28
It seem like the function needs a little push the be right

>Per my previous post, I am not sure that you can expect the
>the SEEK function to detect uncommitted changes. With
>Table buffering you do not update the indexes on disk until
>the TableUpdate.
>
>I have not had any experience with your 'EOF(), skip, and retry the SEEK working'
>-myron kirby-
>==================================
>>What i am trying to say here, is that the SEEK function is buggy, I have a table with a key field and a primary index on that field.
>>When i use the table in optimistic table buffering and seek a value, replace it with an another value, DELETE the current record, I seek the initial value and the seek function still finds it!
>>
>>If you go to eof(), you skip, and you retry the seek function, it works!!
>>and will work every time afterward.
>>
>>
>>
>>
>>
>>>The browse window is not just like using a grid in a form. It
>>>is behaviors all its own. I do not think you can implemented
>>>table buffering outside of a form. Therefore, I believed
>>>what you are experiencing is what is expected for row
>>>buffering.
>>>
>>>From the command window try the following:
>>>
>>>
>>>SELECT tblName
>>>
>>>? CURSORGETPROP([BUFFERING], ALIAS()) && Save buffer mode
>>>=CURSORSETPROP([BUFFERING], 3, ALIAS())        && Optimistic row buff
>>>
>>>? CURSORGETPROP([BUFFERING], ALIAS()) && Save buffer mode
>>>
>>>=CURSORSETPROP([BUFFERING], 5, ALIAS())        && Optimistic row buff
>>>? CURSORGETPROP([BUFFERING], ALIAS()) && Save buffer mode
>>>
>>>
>>>-myron kirby-
>>>============================
>>>>Try it and see!!!!.
>>>>
>>>>
>>>>>Are you sure in the browse window you have table buffering?
>>>>>-myron kirby-
>>>>>=========================
>>>>>>How come it works well with the browse window open ????
>>>>>>
>>>>>>
>>>>>>
>>>>>>>Since you have table buffering do you not have
>>>>>>>to do a TableUpdate for your change to committed
>>>>>>>and your indexes updated?
>>>>>>>-myron kirby-
>>>>>>>==============================
>>>>>>>>Create a table with a field call key LEN 10 char
>>>>>>>>Add a index on that field call key
>>>>>>>>add 5 records with the SYS(2015) function
>>>>>>>>
>>>>>>>>Table test example
>>>>>>>>Field key
>>>>>>>>_RTE10A1W7
>>>>>>>>_RTE10A1W9
>>>>>>>>_RTE10A1X1
>>>>>>>>
>>>>>>>>
>>>>>>>>Defective code
>>>>>>>>SET DELETED ON
>>>>>>>>USE TEST.dbf IN 0 SHARED
>>>>>>>>=cursorsetprop('buffering',5) && RETURN .T.
>>>>>>>>set order to 1
>>>>>>>>? seek('_RTE10A1W9') && RETURN .T.
>>>>>>>>replace key with 'Hello'
>>>>>>>>delete
>>>>>>>>? seek('_RTE10A1W9') && Still return .T.
>>>>>>>>
>>>>>>>>
>>>>>>>>This only append with buffering 4 and 5
>>>>>>>>
>>>>>>>>This behavior dissapear if you have a browse window open with this table in it.
Luc Nadeau
lnadeau@neova.ca

"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)
Previous
Reply
Map
View

Click here to load this message in the networking platform