[AccessD] A2000: Am I blind? (swe)

Hah!  In early Paradox for Windows, circa Access 2.0, you couldn't even
bind forms and reports to queries, all you could do was display them.
How's that for funtionality? <g>  And Paradox queries were totals
queries by default.  That could really confuse someone who changed the
order of fields in the query and got a totally different result.  I
supported our sole Paradox dabbler some jobs back because I programmed
Access and could understand what was going on ... Or going wrong in
Paradox.

Charlotte Foust


-----Original Message-----
From: Steve Erbach [mailto:erbachs at gmail.com] 
Sent: Sunday, February 13, 2005 6:46 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2000: Am I blind? (swe)


Gustav,

My curiosity was also piqued by the fact that the query function COUNT
in Paradox for DOS and Windows has always given the same kind of result
as T-SQL's COUNT DISTINCT. The get an Access-like COUNT in a query you
had to designate COUNT ALL in Paradox.

That COUNT capability of Paradox was one of the few things about its
queries that I found more capable than in Access. The ability to do a
symmetrical outer join in the query designer rather than having to
create a UNION query as in Access, and the ability to make calculations
using "shorthand" field references instead of spelling out
[TableName].[FieldName] as in Access were the two main things I liked
better about Paradox queries. Otherwise, Access queries have proven to
be an order of magnitude more powerful. I can't tell you how many times
I've thanked the stars that Access queries are able to do the things
they do when compared to Paradox. Being able to use functions in queries
is the single biggest advantage. Functions and subqueries are the
biggies.

Thanks, again.

Steve Erbach
Neenah, WI
USA

On Sun, 13 Feb 2005 15:30:39 +0100, Gustav Brock <Gustav at cactus.dk>
wrote:
> Hi Steve
> 
> Yes, T-SQL is another animal.
> 
> /gustav
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com