RE: Retrieving value of auto_increment field from SQL at time of insert

2003-02-20 Thread John W. Holmes
> I have a table that includes an auto_increment field. > > This is used to build up an audit trail of the passage of a file through > my > server. As a file is received from a remote system I create the first > entry > for that file in the audit trail table. I build up an sql INSERT command > (I'

Retrieving value of auto_increment field from SQL at time of insert

2003-02-20 Thread Dubery
Hi all, I have a table that includes an auto_increment field. This is used to build up an audit trail of the passage of a file through my server. As a file is received from a remote system I create the first entry for that file in the audit trail table. I build up an sql INSERT command (I'm updat