DISC

Contents | What's New | Quick Links

 

ODXQUERY

Introduction

Software Installation

Concepts and Design

Designing Applications

Omnidex Environments

SQL Reference

Omnidex API's

Utilities

Interfaces

Performance Guide

Troubleshooting Guide

Appendix

 

 

Insert

SQL WindowModify Records

 

Click to see a screen shot of the window being describedODXQUERY supports three methods for inserting records into a table.

  • The first method is direct entry of a single record using the insert window. With this method, a table is selected for which all columns will be displayed. The user will enter desired values for any or all of the columns and then click the Save Changes button (blue check mark) on the toolbar.

 

ODXQUERY

Data Source Type

Query Window

SQL Window

Insert Records

Modify Records

Import Records

Export Records

Database Info

  • The second method is to import records from an external file into a table with an identical layout.
  • The final method is to execute an insert into statement via the SQL Statement window.

A record may be inserted into a table by selecting Insert from the options window immediately after connecting to the datasource, by selecting Data/Insert in the menu from most other windows when already connected, or by clicking the insert button in the toolbar from many of the windows.

Enter data into any or all of the columns and click the Save Changes button (blue check mark) or the Cancel Changes button (red X) to save or cancel the insert.

 

top

Dynamic Information Systems Corporation - Omnidex Version 3.8 Build 6 J15.03-Copyright © 2003

DISC | Documentation Home