subquerys use A97 format in A2000

  • Thread starter Thread starter david epsom dot com dot au
  • Start date Start date
D

david epsom dot com dot au

Has anyone else noticed this?

In A2K, I can write a query like this:

select tbl.* from (select * from tbl)

If given a chance, the A2k query designer will rewrite that into A97 syntax:

select a.* from [select * from tbl]. as a


Given that the query designer won't let you design subqueries, in A2K or
A97, I think that is amusing.

(david)
 
david epsom dot com dot au said:
Has anyone else noticed this?

In A2K, I can write a query like this:

select tbl.* from (select * from tbl)

If given a chance, the A2k query designer will rewrite that into A97
syntax:

select a.* from [select * from tbl]. as a


Given that the query designer won't let you design subqueries, in A2K or
A97, I think that is amusing.

(david)
Click to expand...


Yes, I pointed this out to someone only a couple of days ago - see
"InnerJoin + Left Outer Join syntax problem" posted by Doug on 2 March.
However, I was unable to point him to a website which would confirm this is
the syntax which would be used.
I also have dim memories of this actually causing code to fail. I cannot
remember the precise details, but I think there were ad hoc sql statements
created and something used to break if I used one form or the other. The
queries were fairly long and table and field names themselves needed the
surrounding square brackets as they contained spaces - but I can't remember
the precise details.
 
I also have dim memories of this actually causing code to fail.

I was afraid I might hear something like that.

(david)

Anthony England said:
david epsom dot com dot au said:
Has anyone else noticed this?

In A2K, I can write a query like this:

select tbl.* from (select * from tbl)

If given a chance, the A2k query designer will rewrite that into A97
syntax:

select a.* from [select * from tbl]. as a


Given that the query designer won't let you design subqueries, in A2K or
A97, I think that is amusing.

(david)
Click to expand...


Yes, I pointed this out to someone only a couple of days ago - see
"InnerJoin + Left Outer Join syntax problem" posted by Doug on 2 March.
However, I was unable to point him to a website which would confirm this
is the syntax which would be used.
I also have dim memories of this actually causing code to fail. I cannot
remember the precise details, but I think there were ad hoc sql statements
created and something used to break if I used one form or the other. The
queries were fairly long and table and field names themselves needed the
surrounding square brackets as they contained spaces - but I can't
remember the precise details.
Click to expand...
 
Back
Top