Syntax import to SQL server

Forum Home › Forums › Understanding the Software › Syntax import to SQL server

Tagged: 

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • August 25, 2021 at 3:07 am #9425
    Nguyen
    Participant

    Please help me! Can you give me a correct syntax ?
    insert into Table_Test (Myfield) Values (@iTag1)
    @iTag1 : My tag of chanel input in Device1
    https://ibb.co/Zg7jpH9
    https://ibb.co/K5qrSPh

    • This topic was modified 2 years, 8 months ago by Nguyen.
    August 25, 2021 at 3:14 am #9427
    Nguyen
    Participant

    https://ibb.co/SfCDtTY

    August 25, 2021 at 12:01 pm #9428
    Nguyen
    Participant

    Please help me! thanks.

    August 25, 2021 at 12:37 pm #9430
    Mikhail
    Moderator

    Command example:
    UPDATE table SET column1 = @cmdVal WHERE column2 = @cmdNum

    You can find it in the driver description in Administrator.
    In your case
    insert into Table_Test (Myfield) Values (@cmdVal)

    August 25, 2021 at 1:06 pm #9433
    Nguyen
    Participant

    Thank for you help! So what is the @cmdVa. Where can I find the @cmdVa ?

    August 25, 2021 at 1:13 pm #9434
    Nguyen
    Participant

    syntax : insert into Table_Test (ID) Values (3)
    It is working. But I want myValues is Tag of Input chanel.

    August 25, 2021 at 5:48 pm #9435
    Nguyen
    Participant

    Thank you very much! I can do it!

    August 26, 2021 at 1:51 pm #9443
    Mikhail
    Moderator

    @cmdVal is a variable that contains value of the command being sent. The variable is filled by the driver.

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.