Hi Mark,
I assume the data file is on the same machine as the application? This
is usually the only time that this is a problem.
In the BDE Administrator (in the Control Panel), you need to change one
of the Configuration entries. Find the System - INIT entry on the
Configuration page. You will see an entry that says "LOCAL SHARE", this
needs to be set to TRUE.
I have even seen the problem persist after doing that, so something else
you can try is setting up a sbust'd drive to a local drive/directory,
and make it think that the data file is on a network drive - that might
work.
Also, you could try a Flush (can't remember the exact name) - that's
supposed to force any changes to be written to the database immediately.
Regards,
Bevan
> Mark Howard wrote:
>
>
> John Christenhusz asked on the DUG_DB list (how did he post there - it
> seems to be defunct?)
>
> G'day folks,
>
> This is paradox question. When I modify a record from a table and post
> it,
> the physical table has not been updated yet. I assume the DBE keeps it
> in
> memory till the application is shut down or that there is enough
> changed
> data worth starting the actual save procedure.
>
> 1. Is this assumption correct ?
>
> 2. How can this be solved so that the physical table is updated when I
> want
> it to be available for other external purposes? (note that an close
> table -
> open table doesn't seem to work).
>
> 3. Is there any way to detect if the physical table is not updated
> yet?
>
> TIA
>
> John.
>
> My (bounced) response was:
>
> John
> I'm sure you will get a more complete answer from someone else, but in
> the
> meantime:
> In my code I have used
> DBISaveChanges(Handle);
> immediately after each Post.
> although I discovered later that a much better way is to put that code
> into
> the TTable's After Post event.
> My understanding is that doing the above will update the database
> files on
> disk but it will still not notify other users that the table has been
> updated - that is another whole question (which is way beyond me at
> this
> stage)
> Hope this is of some use.
> Mark
--
Bevan Edwards mailto:[EMAIL PROTECTED]
Achieve Software Limited http://www.achieve.co.nz
Phone: (64-9) 444-4210 ICQ: 732011
Fax: (64-9) 444-4201
Mobile: (64-21) 979-603
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
