|
SQL Editor
In
addition
to the
powerful
proprietary
query
languages
of QueryByExample and View Expression Query
that
SmartWare has used
for
nearly 20
years, Visual SmartWare
offers
a new
graphical
SQL query generator.
This step forward
greatly
increases
the strength
of the
SmartWare
database
by
offering
a
world
class
industry
standard
query
tool increasing
the relational
database
functionality
of the SmartWare
database
significantly.
The
graphical
nature of
the
query
editor
makes
it
much
easier
for
developers
not
familiar
with
SQL to
produce
editable
SQL
statements
that
can
be fine tuned
and
optimized
to
create
exactly
the result
required.
This feature
also
allows
the reuse
and
portability
of
queries
with
different
data
sets.
From the
SQL Editor a view can be created which holds the results of the
query. Each time this view is loaded the query is executed.
These views can be used as data source with forms and window
reports. It is difficult to overstate the usefulness of
these types of SQL views. They can be used in any number of
ways and in combination with other components of the coding
environment.
The SQL Editor can be accessed in two ways.
The first method is with the command string Data -- Query -- SQL .
Next you will be presented the file format options and will be
able to create an SQL query file. These file will have an .fqy
extension.
The second method of access is with the command
string Data -- Utilities -- FileFix -- SQL. Next you will be
presented the file format options and will be able to create an
SQL view file. This method creates a view from the resulting
query. Each time this view is opened the SQL query is executed and
the data is updated. These views can act as a data source
for a second or third SQL query. Also these views can be
data sources for reports or forms.
Please refer to the SQL Editor documentation for
a complete list
Please
refer to the SQL Editor documentation for a complete list
|
SQL Common Syntax Problem
|
The most common syntax problem is the treatment
of single and double quotations in SQL. A single quotation
is treated as a value ('WA') and a double quotation is treated as
a field.
The date syntax is unique. the date syntax is as
follows:
where field <= {d '2003-02-01'} |
