• State Verified Answer
  • Locked Locked
  • Replies 6 replies
  • Answers 2 answers
  • Subscribers 93 subscribers
  • Views 7677 views
  • Users 0 members are here
Options
Related
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

nicklaus
over 7 years ago

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

Parents
  • 0 over 7 years ago
    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.
Reply
  • 0 over 7 years ago
    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.
Children
No Data