SQL Against MS Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: C_Silin (OverwhelmedButStillTrying_at_hotmail.com)
Date: 02/06/04 

Date: Fri, 06 Feb 2004 11:20:53 -0800

Hello, I have a problem with getting the proper results back when I
supply a "Guid" value in the where clause. If I run this query without
the specifying the Guid value, I get back 3 rows, all of them with the
same value in the "Guid" field. This is the same field that I am
attepting to place selection criteria on.

So now if I now change the query to specify that Guid number (returned
from the query mentioned above), I get back no rows. I am completely
baffled why this is.

Here is my query...

"SELECT count(*)
FROM SkatingClubs sc, Skater s, SkatingLevels sl, Bracket b, Events e,
     CompetativeEvents ce, CompetitionDescription cd , EventFinals ef
where sl.SkatingLevelNbr = S.SkatingLevelNbr
  and sc.ClubID = s.ClubID
  and s.USFSA_ID = ef.USFSA_ID
  and ef.EventID = e.EventID
  and b.Bracket = e.Bracket
  and ce.CompetitionLocationID = e.CompetitionLocationID
  and cd.CompetitionDescriptionID = e.CompetitionDescriptionID"

the above works just fine, now if I add the following:
  and ce.CompetitionLocationID = '7E0FEA53-4BC1-47E6-96CD-8DD0747FCEE2'

And that Guid is the guid which is in the records returned by the first
version of the query. I can run this same query against a SQL database
with the exact same data in the tables and it runs just fine.

So what can it be?

Thanks in advance for your assistance!!!!!!!!!!!!!!!!!!!!!

Relevant Pages

  • Re: Oracle Spatial SDO Aggregate Union fails with ORA-29913 ODCIAGGREGATEMERGE
    ... GEOMETRIE FROM DGDTW_TOPOGRAFIE; ... there is a administrative coupling on a guid. ... doesnt seem to make any difference(see query 3). ... 14 INNER JOIN DGDTW_OBJECTGUIDS GUIDS ...
    (comp.databases.oracle.misc)
  • Re: SQL Against MS Access
    ... >the specifying the Guid value, I get back 3 rows, all of them with the ... >from the query mentioned above), ... >FROM SkatingClubs sc, Skater s, SkatingLevels sl, Bracket b, Events e, ... > CompetativeEvents ce, CompetitionDescription cd, EventFinals ef ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Against MS Access
    ... supply a "Guid" value in the where clause. ... So now if I now change the query to specify that Guid number (returned ... FROM SkatingClubs sc, Skater s, SkatingLevels sl, Bracket b, Events e, ... CompetativeEvents ce, CompetitionDescription cd, EventFinals ef ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle Spatial SDO Aggregate Union fails with ORA-29913 ODCIAGGREGATEMERGE
    ... there is a administrative coupling on a guid. ... reason i want to union the polygons, so i have 1 geometry for 1 guid. ... Can somebody help me how i can get a query / view with the information ... 12 TOPO.GEOMETRIE AS GEOMETRIE ...
    (comp.databases.oracle.misc)
  • NOT IN problem with GUIDs
    ... I'm having a problem with a query that uses a subselect on a GUID field. ... PARAMETERS GroupId Guid; ...
    (microsoft.public.access.formscoding)