Search the Community
Showing results for tags 'SQL'.
Found 15 results
-
Hello, I noticed that unilogic has a function named " SQL_QUERY " for executing SQL queries using c language. I can see that it needs to be passed an array of a struct called " SQLParamData_t ". This struct it seems that it has three fields: one for the data type, another one for the data length and finally a third for the data itself. From some try and error I deduced some of this data types values (I hope correctly): unsigned char 1 signed int 4 unsigned int 5 volatile char* 10 Any ideas where I can find the rest of them, for example the value for volatile unsigned char* type? Thanks in advance and best regards, Juanan
-
Will the Unistream SQL drivers connect to MS SQL 2000 or am I just wasting my time? I can connect to MySQL 8.0 and SQLEXPRESS 14.0. (I know - just upgrade already...) Thanks, Norm
-
Hi guys, we need help for write data in SQL table , for build report. We don't be how type for use this variable. I try string (all types), but not work. In anexx my table where need write . Thanks in advance.
-
Trying to connect to a Azure sql server running the latest version of SQL server. I can connect using telnet and SSMS no problems. The unistream can connect to a local host using sql express. However when i connect using the same info. I get error which is the pic attached. I am kinda at a impasse. So what server on the unistream line compatible with?
-
Dear All, I am starting for the first time to work with DB in a server PC using SQL (SQL server) query. I am using the SQL example...all works fine...I do the connection...I create the table...I am able to insert, update, get and cancel the "info" with this DB...what I saw and I don't understood is that if I send a query to have some information refered at a specific ID (...WHERE employeID =?) and this ID is not present in the DB the query result, BIT about query success, is turned as "1" ...I was expecting that the "fail BIT" arise !? Maybe this is correct, sorry I don't know deeply this matter...can someone confirm? thanks
-
Dear Friends, I require a sample program of SQL connection with UniStream PLC and how to run queries.
-
Hello, I would like to connect my UniStream to the internet via Ethernet cable that is connected to my router. This is to send SQL statement to my SQL database. Right now I am able to download/upload ladder logic to the PLC via the current communication setup I mentioned. Is there any settings that I need to do before it is able to go online (internet) in order for me to send the SQL statement? Thank you.
-
Any help on using the block for reading the data from data table into SQL rows would be appreciated. I could not find enough document on using this ladder element in the help section. I can read successfully execute the query and read the data from the database to the data table.
- 3 replies
-
- sql
- data tables
-
(and 2 more)
Tagged with:
-
I am trying to set up the connection between PLC and a local database for the first time. Tried many times but an unsuccessful attempt. I think I might be making mistake in configuring the connection parameters in UniLogic. In my case I am using SQL server. Can somebody help me to explain the database connection parameters? I have attached my settings below.
-
Hi everybody, I'm struggling to make a controller to submit data from a controller USP-070-B10/B08 to a MySql Database that stays on Amanzon cloud. I made a project using Unilogic v 1.19.83 same as the one in the controller. Did the connections and queries I wanted but nothing happens. it looks like it's not communicating at all with the database. I'm not even seeing a connection in my server manager. There is any tutorial, hints or something somewhere to guide me (I attached some screens as well)? Thanks
-
Hi, I'm using UniStream with UniLogic (19.2). I'm unsure on how to use the "SQL Query" function block. the "SQL Query" has 3 fields: Query - Input, SQL query to execute. Parameters - Input, query parameter Outputs - Output , query output When I write the next query: Insert into Agua (Tiempo) Values (T_Agua) How does the PLC knows the direction of the database? What do I put in the Parameters and Outputs fields? Is there any file or webinar that I can check regarding this topic?
-
So. You may be smack in the middle of your first Smart Factory project...or you may be wondering what all the hype is about..or, you may be looking around for a brand of programmable controllers that will talk to an ERP SQL database. No matter what your particular scenario is, we invite you to attend our webinar to learn how easy it is to communicate data via SQL, from the production floor up to management levels using Unitronics All-in-One PLC + HMI controllers. To sign up, click here
-
- sql
- smart factory
-
(and 4 more)
Tagged with:
-
We invite you to take part in our webinar: SQL - Adding a Piece to the Industry 4.0 / Smart Factory Puzzle. UniStream PLC + HMI controllers support MS SQL and My SQL, server and can connect to SQL databases. This enables you to set up UniLogic to communicate SQL data ERP/MRP servers - sign up to learn how!
-
Hello, Does Unilogic support data transfer to SQL server ? Thank's, Itzik.