Suqcess 2.05 Database

Anything QL Software or Programming Related.
User avatar
genetika
Over Heated PSU
Posts: 127
Joined: Thu May 05, 2011 5:38 pm
Location: Rome, ITALY
Contact:

Suqcess 2.05 Database

Post by genetika »

Hi.
Is this software commercial ? Or is freeware?

Thanks !

M.


RWAP
RWAP Master
Posts: 2834
Joined: Sun Nov 28, 2010 4:51 pm
Location: Stone, United Kingdom
Contact:

Re: Suqcess 2.05 Database

Post 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


RWAP
RWAP Master
Posts: 2834
Joined: Sun Nov 28, 2010 4:51 pm
Location: Stone, United Kingdom
Contact:

Re: Suqcess 2.05 Database

Post 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


User avatar
dilwyn
Mr QL
Posts: 2753
Joined: Wed Dec 01, 2010 10:39 pm

Re: Suqcess 2.05 Database

Post 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.


User avatar
BSJR
Trump Card
Posts: 182
Joined: Sun Oct 18, 2015 12:53 pm
Location: Amsterdam
Contact:

Re: Suqcess 2.05 Database

Post 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


User avatar
genetika
Over Heated PSU
Posts: 127
Joined: Thu May 05, 2011 5:38 pm
Location: Rome, ITALY
Contact:

Re: Suqcess 2.05 Database

Post by genetika »

T
H
A
N
K
S


User avatar
ql_freak
Gold Card
Posts: 354
Joined: Sun Jan 18, 2015 1:29 am

Re: Suqcess 2.05 Database

Post 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.


http://peter-sulzer.bplaced.net
GERMAN! QL-Download page also available in English: GETLINE$() function, UNIX-like "ls" command, improved DIY-Toolkit function EDLINE$ - All with source. AND a good Python 3 Tutorial (German) for Win/UNIX :-)
User avatar
BSJR
Trump Card
Posts: 182
Joined: Sun Oct 18, 2015 12:53 pm
Location: Amsterdam
Contact:

Re: Suqcess 2.05 Database

Post 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


User avatar
Giorgio Garabello
Gold Card
Posts: 277
Joined: Tue Jun 30, 2015 8:39 am
Location: Turin, Italy
Contact:

Re: Suqcess 2.05 Database

Post 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


User avatar
ql_freak
Gold Card
Posts: 354
Joined: Sun Jan 18, 2015 1:29 am

Re: Suqcess 2.05 Database

Post 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


http://peter-sulzer.bplaced.net
GERMAN! QL-Download page also available in English: GETLINE$() function, UNIX-like "ls" command, improved DIY-Toolkit function EDLINE$ - All with source. AND a good Python 3 Tutorial (German) for Win/UNIX :-)
Post Reply