Suqcess 2.05 Database

Anything QL Software or Programming Related.
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: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
Like Archive and the DATAdesign Engine one can open several databases with DBAS, search them and present a combined result.
Unlike Archive this can be done in S*Basic but no special keywords exist for connected searches.
There are several Family Tree programs for Archive that demonstrate this quite well.
The Invoice_bas that came with DD3 demonstrates this for DATAdesign.

But unlike Archive the current DATAdesign or SuQcess front ends do not support opening more than one database.
SuQcess does allow peeking a second database or copying records from a second database if structurally identical.
Also internally temporary databases are used, to sort the searches before saving.

Bob


Post Reply