Re: Is it possible to use a sql query in ST Logic to access data in linked odbc table with 64bit driver?

sbeadle

There's a variable number of severities per object. Here is a 'meta query' you can use to find severity data: SELECT 'select ''' || TABLE || ''',''' || NAME || ''',T.Id, T.FullName, T.' || NAME || ',S.Description from ' || TABLE || ' T left join CSeverity S on T.' || NAME || ' = S.Priority ' AS SQL FROM DBFIELDDEF WHERE NAME LIKE '%Severity' AND SIZE = 1 AND TYPE = 1 The output is a longish list of queries for each database type.

sbeadle

There is an example of using the .Net Client library here: https://github.com/ClearSCADA/utility-examples Perhaps you can share sample code for reading system names and getting valid connection parameters from the systems.xml? Thanks.

sbeadle

Thank you to all for your contributions. I am now closing this thread to new comments. All feedback is being carefully considered and the development team will respond in due course. I’m marking this as ‘answered’ although there will be a response on these forums. Kind regards. Steve

sbeadle

But create a new topic!

sbeadle

Edit the driver's post-build command and change: C:\Dev\ClearSCADA\Binaries\X64\Debug\ to C:\Program Files\Schneider Electric\ClearSCADA\ (Or remove them and manually copy these files)

sbeadle

Thanks for your feedback on the Help. We have allowed Help to be dragged out as a standalone window, and (in the Jan release) allow it to be a tab, so it can be flipped under another window. We're looking at behaviour when a dialog is shown..

sbeadle

For clarification (because the 'ODBC Driver' can mean 3 things! a) The ability to connect an ODBC client application (like Excel, VB, ...) to read and write data b) The ability to link external database tables within the Geo SCADA database so that client displays and (warning) Logic can read/write from those external tables c) The ability to read data from an external table and bring it in as point values/times/quality. (As if it was a device). This latter facility is what you might consider. No 'danger' of locking the database. Search the Help for 'odbc driver guide Introduction to the ODBC Driver'

sbeadle

The trials of product management. Remove a feature no-one uses (or even ought to use) and 3 people complain that it's the most important thing ever!

sbeadle

Hi All, someone recently asked me to help diagnose a security issue - it seemed that the permissions on an object were not as expected. Sure enough, this was true, but in a complex tree of objects it takes some clicking on each group to find out where the permissions from the root have been changed. There's a good way to find these though. Open a query and enter the following SQL: SELECT ID, FullName, ACLInherited FROM CDBOBJECT WHERE ACLInherited = False ORDER BY FullName This will show all objects with non-defaulting security! Steve p.s. you can do the same with the colour palette using the column ColourPaletteInherited .

sbeadle

Adam's right. Only use linked tables if you can 100% guarantee it will be available all of the time. I'd recommend exporting with the SQL Export driver, or write your own custom DDK driver to do it.

Online Status	Offline
Date Last Visited	5 hours ago

Schneider Electric Exchange Community

Re: Is it possible to use a sql query in ST Logic to access data in linked odbc table with 64bit driver?

Re: May 2019 Monthly Updates of ClearSCADA

Re: Querying Alarm Severity settings across an entire database

Re: Using the Automation Interface with C(sharp)

Re: Geo SCADA Help as a child window in ViewX

Re: ClearSCADA Channel Quantity

Re: DDK Versions and processor types

Re: ClearSCADA Channel Quantity

Re: Link to an ODBC Table created using the Microsoft Access Text Driver

Re: Finding security settings on Geo SCADA objects

Finding security settings on Geo SCADA objects

Re: ODBC/SQL to get Alarm List (Mimic Alarm Banner)

Support

FAQ

About