SQL Flush Buffers

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
liveitupmore
Junior Coder
Posts: 22
Joined: Wed Nov 16, 2005 3:58 am
Location: Gold Coast, Australia

SQL Flush Buffers

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

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts