Showing results 1 to 4 of 4

Thread: How to log multiple varables to a single record?

  1. #1
    nsko Gast

    Cool How to log multiple varables to a single record?

    Hello

    Is it possible to record a set of variables from zenon as one row/record?
    The goal is to insert a number of manually entered values as one data set to the SQL Server. The data set will consist of measured values like:

    ID - Identification of the data set
    Meter - to locate where on the pipe the data set refers to
    WT - an array holding 8 measured values (wall thickness)

    I would like to create the data set as a structured datatype in zenon and log this as one record to the SQL Server - to a table with identical format, like:

    ID Meter WT1 WT2 WT3 WT4 WT5 WT6 WT7 WT8
    1001 500 9.8 9.7 9.8 9.5 9.5 9.5 9.8 9.7

    Is this possible and how can it be done?

    Best rgds, Niels

  2. #2

    Default Re: How to log multiple varables to a single record?

    Hello,

    zenon is very open system and supports a lot of standards like SQL. With the standard zenon functions which deal with connections to databases e.g. Archive, Export, Process Gateway the structure of the database is fixed and optimized for the purpose to fulfil.

    Is it the main goal to have the values in exact that structure on the database?

    If you think further, what should happen with this data from the database?

    Maybe an SQL evacuated archive could also meet your needs?

  3. #3
    nsko Gast

    Default Re: How to log multiple varables to a single record?

    Hi
    The purpose is to record manually entered values during production (manually measured).
    Another way to do this could be to create VB forms, call them from zenon and communicate with a SQL Server by use of ADO. What do you think of this idea?
    Do you see any problems with this approach?
    How would you handle this in zenon?
    Thanks, Niels

  4. #4

    Default Re: How to log multiple varables to a single record?

    Hello,

    the best way int that case would be the solution via vba. Additionally to the input fields of the manual values the available values from zenon can be inserted automatically to the vba form. After inserting all values the vba has to insert the values directly to the sql server.

Similar Threads

  1. Multiple monitors
    By prasadkh in forum zenon Supervisor
    Replies: 18
    Last Post: 21st June 2018, 08:00
  2. Multiple monitors on Vista
    By micko in forum zenon Supervisor
    Replies: 2
    Last Post: 23rd May 2008, 11:33

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •