WinCC 7.5 Insert Data into SQL

Поділитися
Вставка
  • Опубліковано 16 січ 2025

КОМЕНТАРІ • 31

  • @pramodtakkar
    @pramodtakkar 3 роки тому

    how are you saving time stamp in SQL database?I am able to save tag values .Didnt know how to save DateandTime along with data.

    • @StableAutomation
      @StableAutomation  3 роки тому +1

      Set in SQL , so it will take timestamp of data being inserted

    • @nestoraparra
      @nestoraparra Рік тому

      Can I question about timestamp, because the laboratory it’s ok, but timestamp i can’t enable

  • @polucovekpolukomarac
    @polucovekpolukomarac Рік тому

    cool video. Thanks,
    one thing i find hard to understand, in the script via the link I can see that the values you insert are with ' ' which means they are character type.
    Is that correct? Are the values set as characters?

  • @Janxkk
    @Janxkk 3 місяці тому

    Hi, I really liked the video and I've been working on this project. However, I'm able to insert data, but the date and time are not being added. Can you please help me figure out what to do? Null value in date and time column. Also mention data type ok these.

  • @fastabiqhidayatulah
    @fastabiqhidayatulah 2 роки тому

    Hi, why when I used script VALUES ('" & HMIRuntime.Tags("TAG_1") there is no value record to SQL. But when I used Values ("1234") it success to record. My data type value is Float.

  • @АлексейХолявин-д4ч

    Большое человеческое спасибо!

  • @gl2802
    @gl2802 3 роки тому +1

    Hello, how i can make it into auto logging without click insert button?

    • @StableAutomation
      @StableAutomation  3 роки тому

      Create event/ scheduled task

    • @gl2802
      @gl2802 3 роки тому

      May i know how to create? I'm new in this topic and still learn

    • @gl2802
      @gl2802 3 роки тому

      My friend, how to insert date and time in sql? When i look at your video, there is no script on VB

    • @StableAutomation
      @StableAutomation  3 роки тому

      @@gl2802 that you need to set in SQL , to add timestamp when data are inserted.

  • @mraine89
    @mraine89 3 роки тому

    could you inform what do i need license for this function?
    please thanks for video

    • @StableAutomation
      @StableAutomation  3 роки тому

      Wincc RT (runtime) license will be required.

    • @mraine89
      @mraine89 3 роки тому

      @@StableAutomation Thank for the reply but nothing other else doesn't required?

  • @farindn
    @farindn 4 роки тому

    Interesting! Could you please give me more explanation of where I can get the DSN name?

    • @StableAutomation
      @StableAutomation  4 роки тому +1

      You need to create manually. In ODBC connection.

    • @farindn
      @farindn 4 роки тому

      @@StableAutomation Thanks!

  • @whatacode
    @whatacode 3 роки тому

    How to check provider name

  • @vorapobautomation9760
    @vorapobautomation9760 4 роки тому

    Do you have C-Scripts for connect to SQL ?

    • @StableAutomation
      @StableAutomation  4 роки тому

      Sorry , I have not used C for ODBC connection.
      Any specific reason to use C script for this ?

    • @vorapobautomation9760
      @vorapobautomation9760 4 роки тому

      @@StableAutomation I just ask only but not important.
      Can you give me the project ?

    • @StableAutomation
      @StableAutomation  4 роки тому

      @@vorapobautomation9760 sure, will upload VB script and share shortly.

    • @vorapobautomation9760
      @vorapobautomation9760 4 роки тому

      @@StableAutomation Thank you.

    • @StableAutomation
      @StableAutomation  4 роки тому

      Now you can download script from link given in video description..

  • @ajayvarghese3873
    @ajayvarghese3873 4 роки тому

    How to save data automatically to database without insert button?

    • @NasirKhan-fg6op
      @NasirKhan-fg6op 3 роки тому +1

      Dear Ajay,
      did you get answer of this question. I also wants to save the data without inser button. Please share the solution if you know.
      Thanks in advance

  • @thienthanh7450
    @thienthanh7450 3 роки тому

    thank you. i like video

  • @prasadkrishna312
    @prasadkrishna312 3 роки тому

    Thanks bro