Jump to content

Search the Community

Showing results for tags 'sql'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Our Community
    • Come on in!
  • News and Announcements
    • New! UniLogic V1.24 introduces VFDS from Unitronics!!
    • VisiLogic:9.8.64 - Link to mobile app, Ladder: 2x the Space!
    • New!!! ***** U90 Ladder*****
  • UniStream HMI + PLC Programmable Controllers & UniLogic Software
    • UniStream: Hardware
    • UniLogic Software
    • UniLogic UDFBs
    • Industry 4.0, IioT, MQTT--Looking forward
  • Vision, Samba, Jazz and M90 PLC + HMIs & Software
    • Vision & Samba PLC + HMI Controllers & VisiLogic Software
    • Jazz, M91 PLCs and U90Ladder
  • Software Utilities
    • SD Card Suite
    • Remote Operator
    • Remote Access
    • DataXport and DataXls
    • UniDownloader
    • UniOPC
    • UniDDE
  • Utilities for .net and Visual Studio
    • Unitronics PCOM Protocol
    • COM Object ActiveX .dll
    • .NET driver
  • Project Design
    • ...I have a project...what hardware do I need?
  • User Application Stories
    • Just finished a great project?
  • Tips and Tricks
    • Best Programming Practices
    • Tips and Tricks
  • Job Board
    • Projects seeking Programmers
    • Programmers seeking Projects
  • General Discussion
    • We're Listening...
    • The Lounge
  • News and Announcements Copy

Blogs

  • Unitronics' Blog: PLCs, HMIs and more
  • Saragani's Blog
  • Simon's Blog
  • Ash Neilson's Blog
  • Joe Tauser's Blog
  • Unitronics en Español
  • Powered by AMPS
  • Alldrives UK's Blog
  • Unitronics, Howman Style
  • PLCNewbie's Blog
  • Telestar Automation Blog
  • Webinars Collection
  • Tim's Corner
  • Blog
  • TELESTAR (Italian)
  • i4 Automation
  • i4 Automation (UK)
  • Unistream UDFB's

Categories

  • From Headquarters: Sample Applications
    • From Headquarters: VisiLogic
    • From Unitronics: U90 Ladder applications
  • User-submitted Applications
    • From Users: VisiLogic applications
    • From Users: U90 Applications

Categories

  • Articles
    • Forum Integration
    • Frontpage
  • Pages
  • Miscellaneous
    • Databases
    • Templates
    • Media

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Interests

Found 8 results

  1. 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.
  2. 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.
  3. 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
  4. 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?
  5. 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
  6. 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!
  7. Hello, Does Unilogic support data transfer to SQL server ? Thank's, Itzik.
  8. Is there any automated way to get data from a database such as SQL into a V350 in an automated way? It would be nice to go from an external database into a Data Table. Anyone with experience in this area?
×