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