[AccessD] Weird VSS issue - again. X-posted to Access-L.

Hey Charlotte,

No, no inline queries.  We create the sub queries as a separate query.  But
I do think it has to do with the complexity of the queries.

Thanks,
Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Tuesday, August 23, 2005 2:34 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Weird VSS issue - again. X-posted to Access-L.


I've never seen anything like this as an artifact of VSS, but are you
using in-line subqueries?  I have seen weirdness occur when you view
that query in design view and then save it because the query engine
insists on changing the punctuation around the subquery to something
that breaks later on.

Charlotte Foust


-----Original Message-----
From: Bobby Heid [mailto:bheid at appdevgrp.com] 
Sent: Tuesday, August 23, 2005 10:47 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Weird VSS issue - again. X-posted to Access-L.


Hey all,

We have a fairly large FE with hundreds of queries in it (Acc XP).
There is this one set of queries that use a pretty complex sub-query.
By complex, I mean that there are a lot of joins and criteria in it.

Whomever did the original design then self-joined the sub-query 5 times.
This is to handle the tiering of the data.

Any way, after building from source in VSS, this one query would
sometimes be blank.  We finally tracked down how to prevent it from
happening.  We had to view the query in SQL view and then save it.

Well, we just had to add another tier to some other queries (which are
like the ones above) and the same thing happened upon building from
source.  I believe it has something to do with the complexity of the
queries.

Does anyone know what might be going on and what we can do to stop it
from happening?  It's becoming a real PIA.

Thanks,
Bobby