Actually, Actuall there is an internal buffer for data during
modification. It action is controlled by the SET CLEAR ON/OFF
command. Following is from RSyntax.com
"Syntax: SET CLEAR ON/OFF
Default: ON
Mode: Single-user
SET CLEAR determines when R:BASE clears the internal buffers and
transfers the data to disk.
When CLEAR is set on, the internal buffers are cleared and data
is transferred to disk after each modification. Setting CLEAR on
does not always make R:BASE automatically write each new or
changed row to disk. For example, when you use a form, R:BASE
writes the edits to disk when you finish using the form.
Set CLEAR off to write modified data to disk only when the
buffer is full, a database is closed, or you exit R:BASE. If
CLEAR is set off, repetitive modifications to a database can run
faster, but you could lose all of your changes stored in the
buffer if an accident, such as a fluctuation in power supply,
occurs.
In multi-user mode, the CLEAR setting has no effect and always
acts as though it is set on. "
Jim Bentley
--- [EMAIL PROTECTED] wrote:
> >..... and there's no buffer anywhere in R:Base that will
> cause it _not_ to
> read the most current information from the table in question
> -- imagine the
> problems that would ensue if that were the case!
>
>
> I have to disagree with that statement. I have seen it happen
> before. I had
> a form that recorded sales; if you entered or changed the
> amount, an exit eep
> went out to find out if there was enough inventory to cover
> the sale. Here
> was the problem scenario: if you had the form up and it
> looked up the
> inventory once; while still on that row in the form another
> session changed the
> inventory; if you did something to make that same row look up
> inventory again it did
> not find the new inventory. I fixed it by doing a dummy
> update to the
> lookup table before my select. And yes, it did totally cause
> me to panic when I
> saw it happen. I wondered where else this might be causing
> problems, but
> haven't seen anything.
>
> Karen
>
>
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
