• State Verified Answer
  • Locked Locked
  • Replies 4 replies
  • Subscribers 93 subscribers
  • Views 10207 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

VBscript example using VI.DB.Entities.Query class with a join

ermes.crico
over 6 years ago

Hi all,

Someone has an example how to execute a sql query with join on a vb script ?

I try with the code like:

            Query = Query.From("SAPUserHasParameter", "UP") _
            .Join("SAPParameter", "Par").On(f.ColumnsComparison("UP.UID_SAPPaameter", "Par.UID_SAPParameter"))

but it gives error.

Thank you very much and best regards

Ermes

Parents
  • 0 over 6 years ago

    What is the error?

    Where or better in what kind of statement are you trying to use the Query object?

  • +1 over 6 years ago in reply to Markus Weiss-Ehlers

    Hi Markus,

    I am create a custom task for SAP connector

    I would like to have the SAP the "ParamID" on table SAPParameter of a SAPUser.

    Obviously I can retrive before all UID_SAPParameter from "SAPUserHasParameter" and after retrive all ParamID from "SAPParameter"

    but If I can retrvie all value on a single query it is more efficient.

    I would like to have a collection like:

    SAPUserHasParameter.UID_SAPParameter - SAPParameter.ParamID -  SAPUserHasParameter.ParameterValue

    Thank you very much and best regards

    Ermes

  • 0 over 6 years ago in reply to ermes.crico

    I am still not understanding where are trying to use your Query object and what the error message is.

    Are you trying to use the Query object in a scripted property of an SAP sync project? Can you post the error message?

Reply Children
No Data