Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this a bug???
Message
From
26/05/1998 16:13:18
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00102045
Message ID:
00102089
Views:
27
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.
----------------------------------
-myron kirby (mkirby2000@gmail.com)-
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform