fp sql - does it have any short coming or problems

Kenneth Brody kenbrody at bestweb.net
Mon Mar 22 10:24:04 PST 2004


Mike Schwartz-PC Support & Services wrote:
[...]
>         The main disadvantage is that it only supports a small subset of SQL
> commands; I think something like 12 commands.  However, that has proven
> adequate for my customers who like to design their own reports using SQL.
[...]

As I recall, the only feature of ANSI X3.135 level 1 SQL's query language
lacking in fPSQL is the SELECT DISTINCT clause.

Other than that, the differences are filePro-related, such as being case
insensitive for sorting and selecting, the addition of "@nnn" to refer
to fields by number, plus the SET clause to set options.

-- 

+---------+----------------------------------+-----------------------------+
| Kenneth |     kenbrody at spamcop.net      | "The opinions expressed     |
|    J.   |    http://www.hvcomputer.com     |  herein are not necessarily |
|  Brody  |      http://www.fptech.com       |  those of fP Technologies." |
+---------+----------------------------------+-----------------------------+



More information about the Filepro-list mailing list