• Help Home
  • English (US)
    1. English (US)
    2. Deutsch
    3. Español
    4. Français
    • What's New in InfoWorks WS Pro
      • What's new in this version
      • What's New in 2024 and Earlier Versions
    • Release Notes
    • InfoWorks WS Pro Help
    • Technical Notes and References
      • Technical Notes
        • Business Case for Network Modelling
        • GIS and Hydraulic Modeling in the Urban and Rural Environments
        • Modelling During Drought Conditions
        • Demand area analysis
        • Network Models in the Control Room
        • Ten Good Reasons to Build Dynamic Models
        • Auto Calibration
        • Parallel Second Order 2RA model for Chlorine and Trihalomethane Predictions
        • Pressure Related Demand
        • Introduction to Ruby Scripting in InfoWorks
        • SQL in InfoWorks WS Pro
          • Basic Object Selection
          • Advanced Topics In Selection
          • Deletion
          • Assignment
          • Adding New Data with INSERT
          • Functions
          • Variables
          • Other Variables
          • Array fields
          • One-To-Many Links
          • SELECT Clauses generating grids and files
          • Time Series Results
          • Prompts
          • Scalars
          • Control Logic
          • Scenarios
          • Error Messages
        • WatSed Pipe Sedimentation Model
        • A comparison between InfoWorks WS Pro and simplified demand prediction models
      • References
      • Useful Internet Sites
    • InfoWorks Exchange
    Share
    • Email
    • Facebook
    • Twitter
    • LinkedIn
     
     

    Scalars

    The SCALARS statement is primarily used for 'debugging' when the user is developing SQL queries but may also be used as an easy way of looking at a number of scalar variables.

    The keyword

    SCALARS

    on its own will display all the scalars

    SCALARS followed by a comma separated list of scalar variables will display just those variables e.g.

    SCALARS $x, $z

    Parent topic: SQL in InfoWorks WS Pro

    Was this information helpful?

    Except where otherwise noted, this work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License. Please see the Autodesk Creative Commons FAQ for more information.

    • Privacy Statement
    • Legal Notices & Trademarks
    • Report Noncompliance
    • © 2025 Autodesk Inc. All rights reserved