Re: Data connection not working properly in Server Explorer
From: Zachary Turner (divisortheory_at_gmail.com)
Date: 09/27/04
- Next message: Stacey Levine: "Data grid performance issue."
- Previous message: Zachary Turner: "Data connection not working properly in Server Explorer"
- In reply to: Zachary Turner: "Data connection not working properly in Server Explorer"
- Messages sorted by: [ date ] [ thread ]
Date: 27 Sep 2004 10:50:34 -0700
Hmm... Apparently I have to use %Crystal when running it through ADO
objects, but *Crystal when running it through Access. % doesn't work
in Access and * doesn't work in ADO. Annoying, since now I can't use
my previously saved view.
Zachary Turner wrote:
> I have a data connection to an access database, and inside the access
> database there is a query of which the text is:
>
> SELECT Name FROM Items WHERE Name LIKE '*Crystal' ORDER BY Name;
>
> When I run this query in Access it works fine, and I get back a list
of
> all entries in the Items table which end with the text Crystal. In
the
> server explorer this shows up as a View, and when I "Retrieve Data
from
> View" it comes back empty. However, two other views do not come back
> empty, and I wonder if it has something do with the specific
mechanics
> of the query. Can somebody help me out here?
>
> Thanks
- Next message: Stacey Levine: "Data grid performance issue."
- Previous message: Zachary Turner: "Data connection not working properly in Server Explorer"
- In reply to: Zachary Turner: "Data connection not working properly in Server Explorer"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
