🚀 go-pugleaf

"Steve Clarke" <steve@h-a-s.co.za> wrote in message
news:Xns915E68F29D1CFstevehascoza19283746@207.105.83.65...
> 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.
Hi,

With MySQL one could get the last incremented value from a table by running
the following query:

SELECT LAST_INSERT_ID() FROM <tablename>

Regards
Philip du Toit