🚀 go-pugleaf

Got a little problem here: I need to get to value of an autoincrement after 
its posted.

My previous method was something like this.

using an ADOTable with the fields:
AutoInc    	    	Table_ID;
varchar(255)    	Description;

my code would be something like this:
...
table->Open();
table->Insert();
table->FieldByName("Description")->Value = "Test";
table->Post();
table->Refresh();
int id = table->FieldByName("Table_ID")->AsInteger;
...

This works ok most times. But on a large dataset the refresh method causes 
the calling app to hang...

I've applied the ADO updates and CBuilder5 updates and still no joy.

We are using MySQL via ODBC.

I really hope someone can help with this as I am aging prematurely.

Thanks,
    	Steve Clarke.