Hi

We currently have auditing processing on the database using the triggers in the DBISAMEngine, which are working fine and have been for quite a while but I have just realised that it is treating memory tables the same way.

So my question is is there a way to determine if the table passed through is a memory table. I can see a simple way is to formulate a naming convention for our memory tables but that requires going over and restructuring a bit so im trying to avoid this.

As an example we have the table "Employee" if we need to create memory version we would probably call it "\memory\Employee" so when passed we cannot tell the difference.

procedure TDBISAMAudits.DoOnAfterInsert(Sender: TObject; TriggerSession: TDBISAMSession; TriggerDatabase: TDBISAMDatabase;
 const TableName: string; CurrentRecord: TDBISAMRecord);


hope that makes sense...

ClockOn


Simply check the database - if its Memory its an in-memory table.

Roy Lambert [Team Elevate]

lol thanks Roy

*slap to forehead...