Flushing Buffers

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