473,320 Members | 1,713 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

subquerys use A97 format in A2000

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)
Mar 7 '06 #1
2 1083

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:44***********************@lon-reader.news.telstra.net...
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)

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.

Mar 7 '06 #2
> I also have dim memories of this actually causing code to fail.

I was afraid I might hear something like that.

(david)

"Anthony England" <ae******@oops.co.uk> wrote in message
news:du**********@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:44***********************@lon-reader.news.telstra.net...
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)

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.

Mar 8 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: -Michelle- | last post by:
Hi I am using A2003 on XP. The client has A2000. So I have ensured that I have developed based on A2000 and compiled as such. I have found that in a number of cases now, I have used (what I...
22
by: Bradley | last post by:
Has anyone else noticed this problem? I converted the back-end to A2000 and the performance problem was fixed. We supply a 97 and 2000 version of our software so we kept the backend in A97 to make...
14
by: L Mehl | last post by:
I tested a FE/BE application developed in A2000 on a A2002 machine and got this message when exiting the app. Clicking the only available button "OK", exits the application, as intended. The FE...
2
by: dinkly rick | last post by:
Hi, I'm new to A2000, and to the creation of runtime applications of MS Access although I have been building database applications in A97 for some time. I have finally decided to attempt to...
1
by: \(Bradley | last post by:
In an A2000 ADP I cannot edit data in an MS-SQL2000 view that has a simple JOIN in it. However I can edit the data in the same view if I open it in A2003 or SQL Query Analyser/etc. I understand...
10
by: Daven Thrice | last post by:
If I create an mdb in Access 2003, in 2003 format, and go to a computer that has Access 2002 on it, will I be able to open and edit all of the objects? Thanks, dt
1
by: larpup | last post by:
I've converted my frontend and backend from A2003 to A2000. Data is linked, however, I receive "recordset not updateable". Additionally my code stops on a simple function which turns data in a...
8
by: rdemyan via AccessMonster.com | last post by:
I've converted my application from A2K format to A2003 format. I tried to follow Allen Browne's protocol in getting my app into A2003 (although I was unable to find informtion on the conversion...
0
by: Tom | last post by:
All: I posted on this yesterday, but for whatever reason, Google isn't dealing nicely with it... Anyway, I need to install A2000 on a computer that already has A2002 so I can create A2000 mde...
1
by: Fred Zuckerman | last post by:
I have a database on a shared drive. It has user level security (ie: mdw file). It was created in A2000 and works fine when opened on workstations with A2000 installed. Some workstations have...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.