Limit on Access where clause?

[=?Utf-8?B?Qm9iQWNoZ2lsbA==?=]

Is there a resource limit on how many items can be put in the Where clause of
a select command that retrieves rows to a OleDbDataAdapter dataset? Can it
be unlimited if I change some settings?

I bumped my head when I got to ...
SELECT col1 col2
FROM table
Where this0 AND that0 AND it0
OR this1 AND that1 AND it1
...
OR this97 AND that 97 AND it97

Thanks!

Bob

[Michel Posseth [MCP]]

The resource limit is the maximum size that the string datatype can hold
wich is on a windows XP system the same amount of characters as the integer
max size ofcourse if your computer is capable of mapping the needed memory
:-) .

If you were asking me if this is good coding practice :-| well

In my opinion you would bether design the project structure in such a way
that query`s like that are not necesary
or if it is really necesary to retrieve data in a way where you must check
for multiple variabel values , you could go for a where in query ( this is
suported by Access )

example

SELECT * FROM Shops
WHERE City In ("Paris", "London", "Amsterdam");

SELECT * FROM Shops
WHERE City = "Paris" OR City = "London"
OR City = "Amsterdam";

HTH

Michel

"BobAchgill" <Bo********@discussions.microsoft.comschreef in bericht
news:01**********************************@microsof t.com...

Is there a resource limit on how many items can be put in the Where clause
of
a select command that retrieves rows to a OleDbDataAdapter dataset? Can
it
be unlimited if I change some settings?

I bumped my head when I got to ...
SELECT col1 col2
FROM table
Where this0 AND that0 AND it0
OR this1 AND that1 AND it1
...
OR this97 AND that 97 AND it97

Thanks!

Bob

[=?Utf-8?B?VGVycnk=?=]

I saw a thread on this group in the last week or so that indicated that
Access had a limit of 99 fields in the where clause.
--
Terry
"BobAchgill" wrote:

Is there a resource limit on how many items can be put in the Where clause of
a select command that retrieves rows to a OleDbDataAdapter dataset? Can it
be unlimited if I change some settings?

I bumped my head when I got to ...
SELECT col1 col2
FROM table
Where this0 AND that0 AND it0
OR this1 AND that1 AND it1
...
OR this97 AND that 97 AND it97

Thanks!

Bob