Page 1 of 2

Suqcess 2.05 Database

Posted: Wed Feb 01, 2017 10:48 am
by genetika
Hi.
Is this software commercial ? Or is freeware?

Thanks !

M.

Re: Suqcess 2.05 Database

Posted: Wed Feb 01, 2017 11:25 am
by RWAP
A good question - Dilwyn's site only has the demo version...

BSJR on here is the person to ask as he wrote Suqcess together with Wolfgang Uhlig

Re: Suqcess 2.05 Database

Posted: Wed Feb 01, 2017 11:29 am
by RWAP
It appears that the earlier v1.20 was released as freeware - http://members.upc.nl/b.spelten/ql/suqcess1.html

(Dilwyn - this can presumably be added to the QL Homepage now) :D

Re: Suqcess 2.05 Database

Posted: Wed Feb 01, 2017 1:40 pm
by dilwyn
RWAP wrote:It appears that the earlier v1.20 was released as freeware - http://members.upc.nl/b.spelten/ql/suqcess1.html

(Dilwyn - this can presumably be added to the QL Homepage now) :D
Done, thanks RWAP.

Re: Suqcess 2.05 Database

Posted: Mon Mar 13, 2017 3:54 pm
by BSJR
genetika wrote:Hi.
Is this software commercial ? Or is freeware?

Thanks ! M.
Hi All,

I have removed the trail limitation for SuQcess 2.05 on my site.
Three language versions can now be downloaded here: <http://members.upc.nl/b.spelten/ql/>.
I have used it almost daily over the past 10 years and am aware of bugs in the program, although nobody else has reported any problems.
I am busy testing the fixes and updates but I do expect to need a few more weeks before v2.06 is finished.

SuQcess forever,
Bob

Re: Suqcess 2.05 Database

Posted: Fri Mar 24, 2017 7:49 am
by genetika
T
H
A
N
K
S

Re: Suqcess 2.05 Database

Posted: Fri Mar 24, 2017 8:18 am
by ql_freak
Does Suqcess or better DBas (which seems to be the underlying Database) allow (outer) joins as in a SQL-RDBMS? Like e. g.

SELECT * FROM weather LEFT OUTER JOIN cities ON (weather.city = cities.name);

in SQL? This is IMHO the most missing facility in "old" databases like dBase or Archive.

Re: Suqcess 2.05 Database

Posted: Fri Mar 31, 2017 12:34 pm
by BSJR
ql_freak wrote:Does Suqcess or better DBas (which seems to be the underlying Database) allow (outer) joins as in a SQL-RDBMS? Like e. g.

SELECT * FROM weather LEFT OUTER JOIN cities ON (weather.city = cities.name);

in SQL? This is IMHO the most missing facility in "old" databases like dBase or Archive.
I do not speak SQL so cannot answer this question.

The DBAS command SEARCH can select records on 4 fields with INSTR, greater, smaller, greater-equal, smaller-equal or unequal, which can be combined with AND, OR, XOR & NOT.
Clever use of this can maybe mimic what you need. May I suggest you try the Search option in SuQcess.

Bob

Re: Suqcess 2.05 Database

Posted: Fri Mar 31, 2017 9:58 pm
by Giorgio Garabello
ql_freak wrote:Does Suqcess or better DBas (which seems to be the underlying Database) allow (outer) joins as in a SQL-RDBMS? Like e. g.

SELECT * FROM weather LEFT OUTER JOIN cities ON (weather.city = cities.name);

in SQL? This is IMHO the most missing facility in "old" databases like dBase or Archive.
No, DBAS don't use SQL and is not a database, is a storage engine.

Giorgio

Re: Suqcess 2.05 Database

Posted: Sat Apr 01, 2017 10:20 am
by ql_freak
Giorgio Garabello wrote:
ql_freak wrote:Does Suqcess or better DBas (which seems to be the underlying Database) allow (outer) joins as in a SQL-RDBMS? Like e. g.

SELECT * FROM weather LEFT OUTER JOIN cities ON (weather.city = cities.name);

in SQL? This is IMHO the most missing facility in "old" databases like dBase or Archive.
No, DBAS don't use SQL and is not a database, is a storage engine.

Giorgio
I know, but joining tables does not mean, that SQL must be supported. Joining means, that you can make a query over more than one table. That has nothing to do with SQL.

What joining, especially outer joins, means is e.g. documented in the manual of PostgreSQL