Suqcess 2.05 Database
-
- RWAP Master
- Posts: 2893
- Joined: Sun Nov 28, 2010 4:51 pm
- Location: Stone, United Kingdom
- Contact:
Re: Suqcess 2.05 Database
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
BSJR on here is the person to ask as he wrote Suqcess together with Wolfgang Uhlig
Rich Mellor
RWAP Software
RWAP Adventures
SellMyRetro
Retro-Printer Module - add a USB printer to your QL
Also Involved in:
Icephorm
RWAP Software
RWAP Adventures
SellMyRetro
Retro-Printer Module - add a USB printer to your QL
Also Involved in:
Icephorm
-
- RWAP Master
- Posts: 2893
- Joined: Sun Nov 28, 2010 4:51 pm
- Location: Stone, United Kingdom
- Contact:
Re: Suqcess 2.05 Database
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)
(Dilwyn - this can presumably be added to the QL Homepage now)

Rich Mellor
RWAP Software
RWAP Adventures
SellMyRetro
Retro-Printer Module - add a USB printer to your QL
Also Involved in:
Icephorm
RWAP Software
RWAP Adventures
SellMyRetro
Retro-Printer Module - add a USB printer to your QL
Also Involved in:
Icephorm
Re: Suqcess 2.05 Database
Done, thanks RWAP.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)
--
All things QL - https://dilwyn.theqlforum.com
All things QL - https://dilwyn.theqlforum.com
Re: Suqcess 2.05 Database
Hi All,genetika wrote:Hi.
Is this software commercial ? Or is freeware?
Thanks ! M.
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
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.
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
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

Re: Suqcess 2.05 Database
I do not speak SQL so cannot answer this question.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.
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
- Giorgio Garabello
- Gold Card
- Posts: 299
- Joined: Tue Jun 30, 2015 8:39 am
- Location: Turin, Italy
- Contact:
Re: Suqcess 2.05 Database
No, DBAS don't use SQL and is not a database, is a storage engine.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.
Giorgio
Quantum Technology
http://www.hunggartorino.it/ql/language/en/
http://www.hunggartorino.it/ql/language/en/
Re: Suqcess 2.05 Database
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.Giorgio Garabello wrote:No, DBAS don't use SQL and is not a database, is a storage engine.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.
Giorgio
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
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
