Data & SQL Commands

Data & SQL Commands

Summary: Retrieve data via SQL.

Quick answer

Use SQLLOOK/SQLREAD/SQLLOOP.

What you need

  • WinCopy SQL v9.0.06+
  • Appropriate permissions

Steps

  1. Identify fields
    media/models-data-sql-01.png

    [Insert screenshot]

  2. Write SQL commands
    media/models-data-sql-02.png

    [Insert screenshot]

  3. Loop results
    media/models-data-sql-03.png

    [Insert screenshot]

Confirm it worked

Data prints.

Troubleshooting

Validate fields.

  • X

    • Related Articles

    • Model System Overview

      Summary: Understand model architecture. Quick answer Models have graphic, procedure, and data sections. What you need WinCopy SQL v9.0.06+ Appropriate permissions Steps Open model docs media/models-overview-01.png [Insert screenshot] Review sections ...

    • Graphic & Procedure Commands

      Summary: Rendering and flow control. Quick answer Use BITMAP/LINE and IF/LOOP. What you need WinCopy SQL v9.0.06+ Appropriate permissions Steps Review graphic cmds media/models-graphic-procedure-01.png [Insert screenshot] Review procedure cmds ...

    • Field Dictionary & Appendices

      ummary: Complete field reference. Quick answer Use dictionaries for variables. What you need WinCopy SQL v9.0.06+ Appropriate permissions Steps Open field list media/models-fields-appendices-01.png [Insert screenshot] Find module ...

    • PDF Embedding & Collation

      Summary: Attach PDFs and collate. Quick answer Use INSERTPDF and packages. What you need WinCopy SQL v9.0.06+ Appropriate permissions Steps Map PDF types media/models-pdf-collation-01.png [Insert screenshot] Use INSERTPDF ...

    • Getting Started with WinCopy

      Summary: Initial setup path: enter/convert customers, set up courts and servers, run sample jobs, then configure billing. Quick answer Start by loading customers, courts (if outside CA), and servers; then enter a few sample jobs end‑to‑end to ...