vid_insertforhandleobject_freeze

Question

Hello, 
 we are migrating to V7.1.1. 
 I can't find the function vid_insertforhandleobject_freeze in the database. 
 How can we trigger an Dataset Insert / Update via SQL ? 
 We have special programming in SQL, so DataImporter is no alternative. 
 exec vid_insertforhandleobject_freeze 'Insert', 'Department', '', 'FullPath','USU Migration', 'DepartmentName','USU Migration', 'UID_ParentDepartment',@UID_ParentDepartment, @ProcID=12345 
 Best regards 
 Bernd

Barry Jackson · Accepted Answer

Hi Bernd, 
 
Just FYI the syntax I gave you is correct. There is no option for bulk processing with this SP. To process many you will have to have many exec QBM_PJobCreateHOInsert statements. 
 
Regards, Barry.

Barry Jackson · Answer

Hi Berndt, 
 
Take a look at the stored procedure: 
 
QBM_PJobCreateHOInsert 
 
I think that's what you are looking for. 
 
Regards, Barry.

Barry Jackson · Answer

Hi, 
 
I looked inside the stored procedure QBM_PJobCreateHOInsert and then googled user-defined table. 
 
In short the QBM_YParameterList allows you to pass a number of values rather than one in the form of a table. 
 
See this page: blogs.msdn.microsoft.com/.../ 
 
In order to get a single insert to work I did this: 
 
declare @ObjectKeysAffected QBM_YParameterList 
exec QBM_PJobCreateHOInsert 'Department','12345',@ObjectKeysAffected,null,null,1,'DepartmentName','Test' 
 
HTH, Barry.

Endpoint Privilege Management

vid_insertforhandleobject_freeze