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

Hi Steve

Once upon a time a played with Paradox 1 - the original from Ansa Soft.
I never did much with it but its manual was quite good, and it was there
I saw the light and learned the power of a relational database - in one
moment all the flat file things like RapidFile became obsolete and
totally outdated to me.

I kept it for many years but a couple of years ago I gave my copy to a
local computer museum including the original runtime I happened to
receive from Ansa by request.

I have never worked seriously with Paradox for Windows but I guess you
are right; it had some nice features but Access seemed more capable to
me so I never bothered.

/gustav


>>> erbachs at gmail.com 13-02-2005 15:46:04 >>>
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