🚀 go-pugleaf

I'm doing a Db program using ADOExpress, updated n' all, but have run into a
slight annoyance .. the table in question is using a rowguid as primary
index. Now, I can do an Insert just fine, but I need to update a connected
table when the first one is updated, and lo and behold, in neither AfterPost
or similar routines is the rowguid field actually -updated- and I can't do a
requery since I need the rowguid to determine *which* record to reload
anyway ?

Bit of a catch 22, or have I missed something?

I'm using data aware controls and a DBNavigator to enter the "insert" mode,
and also using the DBNavigator function for the "Post". Neither the Action
events in DBNavigator, nor the AfterXXX events on the ADOQuery seem to be
able to update the rowguid field - they DO update for autoincrementing
numbers, which make it even more strange.

Code snippet:

void __fastcall TData::dbUsersAfterPost(TDataSet *DataSet)
{
  AnsiString test1 = Data->dbUsers->FieldByName("UsersID")->AsString;

  A simple breakpoint here shows that ADO believes this field is
000000-0000-0000-0000000000 or similar - a "zero" guid which isn't what is
put into the Db. So how can I "refresh" the ADOQuery recordset with the
actual inserted value and access it? *can* I do it in the first place?

/Micke