in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Powerhouse Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    Video: PME - GetNativeSQL - How to use Vista to create SQL Queries

    Issue
    A user would like to create a SQL query to obtain data directly from the ION_Data database. SQL Server Management Studio requires users to have advanced knowledge in writing SQL queries where as the Vista application provides a convenient wizard interface to create the query. The Data Log Viewer provides an "Edit SQL" option to view the Vista query, but these commands do no work in SQL. 

    Product Line
    ION Enterprise 
    StruxureWare Power Monitoring 7.0.x
    Power Monitoring Expert 7.2.x
    EcoStruxure™ Power Monitoring Expert 8.x

    Environment
    Vista
    SQL Server Management Studio

    Cause
    The queries created by the Vista Wizard can not be directly run in SQL. 

    Resolution 
    *Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.* 

    There is a command called 'GetNativeSQL' can be added to the "Edit SQL" in the Vista Wizard that will allow the user to obtain the native SQL commands required to query the ION_Data database directly in SQL Server Management Studio. 

    See attached document or video below for details. 

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance