This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

vid_insertforhandleobject_freeze

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

  • Hi Berndt,

    Take a look at the stored procedure:

    QBM_PJobCreateHOInsert

    I think that's what you are looking for.

    Regards, Barry.
  • Do you have an example?
    What means QBM_YParameterList ?

    Operand type clash: varchar is incompatible with QBM_YParameterList

    exec Qbm_pjobcreate_hoinsert 'Department',
    '12345',
    '',
    'SingleTransaction',true,
    'p1','FullPath','v1','USU Migration',
    'p2','DepartmentName','v2','USU Migration',
    'p3','UID_ParentDepartment','v3',''
  • 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.
  • Hi,

    super it works !
    declare @ObjectKeysAffected QBM_YParameterList
    exec Qbm_pjobcreate_hoinsert 'Department','12345',@ObjectKeysAffected,null,null,1,'DepartmentName','Test'
    go

    Bye Bernd
  • Hi Bernd,

    Now I just need to work out the correct syntax for using @ObjectKeysAffected QBM_YParameterList to process multiples.

    Watch this space!

    Barry.
  • 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.