Flushing Buffers

[jwright479]

I have a stored procedure that saves a record in an Advantage table.

execSQL;
AdsFlushFileBuffers;
close;

When I make a select statement looking for the same record in different procedure it returns no records. I'm guessing it's because the buffer has not been flushed. I'm running ADS 11 and Delphi Seattle.

Any ideas for work arounds?

TIA

[joachim_drr]

AdsFlushFileBuffers forces ADS to write all modifications to the file. Running ADS (not ALS) should not need this API function in order to get refreshed data. Are you using transactions? If so, you need to commit first.

The snippet and the description above is not enough to recreate the problem.