Very Computer

> Hi,

> Question:
> How can the BDE (AND WINDOWS!) be told to flush record buffers and harddisk
> buffers?

> Background info:
> When posting a record to a Paradox table, the database updates are not
> really done on the fysical DB files. Of coarse this is done to speed things
> up.
> But in this case I want to be absolutely sure that a posted record is really
> on the harddisk, and not just floating in some cache in RAM. Also any index
> file must be fully updated.

> Why?
> I'm using Crystal Reports 7 to print data from some Paradox tables.
> But sometimes the CR print engine will crash down with some error in
> Spool32.
> This results in my application* also.
> Only way out is CTRL-ALT-DEL and 'End Task' my app.
> But by doing this I loose the last 10 (or so) posted records in the
> database!

> Temporary solution:
> Until I find out what is happening in CR, I want to flush any buffered data
> to the hard disk so that I don't loose data when CR crashes.

>> Hi,

>> Question:
>> How can the BDE (AND WINDOWS!) be told to flush record buffers and harddisk
>> buffers?

>> Background info:
>> When posting a record to a Paradox table, the database updates are not
>> really done on the fysical DB files. Of coarse this is done to speed things
>> up.
>> But in this case I want to be absolutely sure that a posted record is really
>> on the harddisk, and not just floating in some cache in RAM. Also any index
>> file must be fully updated.

>> Why?
>> I'm using Crystal Reports 7 to print data from some Paradox tables.
>> But sometimes the CR print engine will crash down with some error in
>> Spool32.
>> This results in my application* also.
>> Only way out is CTRL-ALT-DEL and 'End Task' my app.
>> But by doing this I loose the last 10 (or so) posted records in the
>> database!

>> Temporary solution:
>> Until I find out what is happening in CR, I want to flush any buffered data
>> to the hard disk so that I don't loose data when CR crashes.

>The "DbiUseIdleTime" API-call was used .. and I believe it still is used
>.. to ensure that dirty buffer-pages are written to disk.  It is
>designed to be called by an "Application.OnIdle" routine and by a
>timer.

> > Hi,

> > Question:
> > How can the BDE (AND WINDOWS!) be told to flush record buffers and harddisk
> > buffers?

> > Background info:
> > When posting a record to a Paradox table, the database updates are not
> > really done on the fysical DB files. Of coarse this is done to speed things
> > up.
> > But in this case I want to be absolutely sure that a posted record is really
> > on the harddisk, and not just floating in some cache in RAM. Also any index
> > file must be fully updated.

> > Why?
> > I'm using Crystal Reports 7 to print data from some Paradox tables.
> > But sometimes the CR print engine will crash down with some error in
> > Spool32.
> > This results in my application* also.
> > Only way out is CTRL-ALT-DEL and 'End Task' my app.
> > But by doing this I loose the last 10 (or so) posted records in the
> > database!

> > Temporary solution:
> > Until I find out what is happening in CR, I want to flush any buffered data
> > to the hard disk so that I don't loose data when CR crashes.

> The "DbiUseIdleTime" API-call was used .. and I believe it still is used
> .. to ensure that dirty buffer-pages are written to disk.  It is
> designed to be called by an "Application.OnIdle" routine and by a
> timer.