SQL and newid()
-
I have a table which has a field "ID". The default ID of the field calls the newid() function and generates a GUID. This all works fine. I would like to return the new record ID to my app after adding a record via ADO AddNew. How can I do this. I have tried trying to get the value from the field after the call to AddNew but it returns a VT_EMPTY. I've tried doing it after the Update call but that is also VT_EMPTY. This is the code I'm using, Recordset.Create(); Recordset.Open("calls", *m_pConnection, littleADO::adOpenDynamic,littleADO::adLockOptimistic,littleADO::adCmdTable); variant_t vt; try { Recordset.AddNew(); Recordset.m_pRecordset->Fields->Item["Ref"]->Value = pData->m_sRef.c_str(); Recordset.m_pRecordset->Fields->Item["PoliceForceID"]->Value = pData->m_sPoliceForceID.c_str); Recordset.m_pRecordset->Fields->Item["DivisionID"]->Value = pData->m_sDivisionID.c_str(); Recordset.m_pRecordset->Fields->Item["LocationID"]->Value = pData->m_sLocationID.c_str(); Recordset.m_pRecordset->Fields->Item["CustodyID"]->Value = pData->m_sCustodyID.c_str(); Recordset.m_pRecordset->Fields->Item["CustodyDesc"]->Value = pData->m_sCustodyDesc.c_str(); Recordset.m_pRecordset->Fields->Item["CallTime"]->Value = COleVariant(pData->m_CallTime); Recordset.m_pRecordset->Fields->Item["Status"]->Value = pData->m_nStatus; Recordset.m_pRecordset->Fields->Item["UserName"]->Value = pData->m_sUserName.c_str(); // try and get the id here vt = Recordset.m_pRecordset->Fields->Item["ID"]->Value; Recordset.m_pRecordset->Update(); vt = Recordset.m_pRecordset->Fields->Item["ID"]->Value; } Michael :-)
-
I have a table which has a field "ID". The default ID of the field calls the newid() function and generates a GUID. This all works fine. I would like to return the new record ID to my app after adding a record via ADO AddNew. How can I do this. I have tried trying to get the value from the field after the call to AddNew but it returns a VT_EMPTY. I've tried doing it after the Update call but that is also VT_EMPTY. This is the code I'm using, Recordset.Create(); Recordset.Open("calls", *m_pConnection, littleADO::adOpenDynamic,littleADO::adLockOptimistic,littleADO::adCmdTable); variant_t vt; try { Recordset.AddNew(); Recordset.m_pRecordset->Fields->Item["Ref"]->Value = pData->m_sRef.c_str(); Recordset.m_pRecordset->Fields->Item["PoliceForceID"]->Value = pData->m_sPoliceForceID.c_str); Recordset.m_pRecordset->Fields->Item["DivisionID"]->Value = pData->m_sDivisionID.c_str(); Recordset.m_pRecordset->Fields->Item["LocationID"]->Value = pData->m_sLocationID.c_str(); Recordset.m_pRecordset->Fields->Item["CustodyID"]->Value = pData->m_sCustodyID.c_str(); Recordset.m_pRecordset->Fields->Item["CustodyDesc"]->Value = pData->m_sCustodyDesc.c_str(); Recordset.m_pRecordset->Fields->Item["CallTime"]->Value = COleVariant(pData->m_CallTime); Recordset.m_pRecordset->Fields->Item["Status"]->Value = pData->m_nStatus; Recordset.m_pRecordset->Fields->Item["UserName"]->Value = pData->m_sUserName.c_str(); // try and get the id here vt = Recordset.m_pRecordset->Fields->Item["ID"]->Value; Recordset.m_pRecordset->Update(); vt = Recordset.m_pRecordset->Fields->Item["ID"]->Value; } Michael :-)
I've changed my code to use a stored procedure which returns the value of the ID back as an output parameter. This works pretty well. I'd still be interested to know if it is possible via AddNew though. Michael :-)