The Net.Data SQL Assist is a Java-based SQL statement
builder that provides an easy-to-use GUI to guide you through the process of
building SQL statements. With Net.Data SQL Assist you can:
- Build SELECT, INSERT, UPDATE, and DELETE statements (including SELECT
DISTINCT)
- Build multiple conditions using value lookup, AND or OR, and type
sensitive entry fields
- Define table JOINS (inner, right outer, and left outer)
- Select columns to view
- Select the sort order
- Enter user-defined variables to be used in conditions, values, and sorting
After building the SQL statement, you can:
- Save the SQL statement as a file
- Generate and save a macro containing the SQL statement
- Copy the SQL statement or macro to the clipboard
This appendix discusses the following topics:
[ Top of Page | Previous Page | Next Page | Index ]