🚀 go-pugleaf

In article <6h98vi$cnf2@forums.borland.com>, sdegenaar@yahoo.com says...
> Hi!
> 
> My problem essentially is using multiple expressions in the select
> statement. An example is given below:
> 
> SELECT c.club, count(customer_n) / 19 *0.175  * 10000 AS total
> FROM customer AS x, club AS c
> WHERE x.church_id = c.club_id
> GROUP BY c.club;
> 
> I am writing some software in Visual dBase 5.5 pro and a query along the
> same line as the one above is the only part of the program (other than
> generating some reports of it) left. The error that is returned is that this
> is not 'supported'. Essentially my question is whether or not the new
> version dBase 7 supports an sql statement like this ?
> 
> NB. Have tested this sql statement out in Access 97 and it works fine. Am
> wondering also if dBase v7 offers the same sort of support for sql as Access
> does ?
> 
> 
> 
VdB7 does indeed support SQL.
For individual files it is very fast.
There have been some concerns about the slowness of "Joined" databases.
My test have shown this to be extremely slow.
I hope someone from Borland will respond.
-- 
Gerald Fay
gjfay@msn.com