Thanks in anticipation ...
Code: Select all
TMyQuery* Query2 = new TMyQuery(0);
Query->Connection = MyDBSession;
Query->SQL->Clear();
Query->SQL->Add( "select"
" LAST_INSERT_ID() SeqNo"
" from txqueue" );
Query->Open();
if ( !Query->Eof )
SeqNo = Query->FieldByName( "SeqNo" )->AsInteger;