SQL Flush Buffers

liveitupmore · Post by **liveitupmore** » Sat Feb 23, 2013 6:32 am

I am writing a script using the SQL functions of Macro Scheduler with a FoxPro DB with a great deal of success.

If I use the debugger and stop the macro before the the close Database function is used, any external changes to the database are not reflected into my script until I shutdown Macro Scheduler and restart it. Does anyone know how to flush the buffers in memory from within Macro Scheduler.

Does anyone know how to pack the DB once records have been removed, maybe a connect string option.

My connection string is
let>connstr=Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=%DDrive%;Exclusive=No; Collate=Machine;NULL=NO;DELETED=YES;BACKGROUNDFETCH=NO;

Alistair