Database command line interface

[mhargreaves]

Is there a way to query/add/update things in the database either from a command line using SQL or by instantaneously running a script?

[mkoller]

You can do with the CTRL scripting language, using the built-in SQL Query like database language.
Have a look at the std. panel system-management -> Reports -> SQL Query

[leoknipp]

Hello,

if you want to update information in the WinCC OA database you can use the dpSet* commands.
Changing values/data in the database is also possible with the ASCII manager when importing an ASCII file.

For detailed information please have a look at the WinCC online help:
ASCII Manager
CONTROL --> Types of functions --> Data point functions

Best Regards
Leopold Knipp
Senior Support Specialist

[mhargreaves]

What is the best way to execute a CTRL script without a manager? Do I need to create a panel and add a script and call it from an event or is there another way to instantaneously run a script?

[mkoller]

I'm a bit puzzled. "without a manager" you can't do anything. A UI is also a manager. And of course you can run a script from inside a panel instantaneously on a lot of different occasions (remember the WinCC_OA base training).
Or did I musunderstand your question ?

[mhargreaves]

Maybe my trouble is I haven't done the basic training course yet - I am hopefully due to do it in the next few weeks. I will wait until then!

[mkoller]

I see. In the meantime you could start to walk through the GettingStarted chapter in the help