Subject | Sql Expression IN Clause Limit |
---|---|
Author | ibrahim bulut |
Post date | 2004-09-14T06:07:22Z |
Hi,
I am using firebird 1.5.1
i want to ask a question to firebird users.
is there any limit about "IN" clause
example
======
select field1, field2 from table1
where
(field1 in (param1, param2, param3.... paramN)) and
(field2 in (Fparam1, Fparam2, Fparam3.... FparamN))
how many params i can write to IN clause
is there any limit about IN clause
and how many characters can be sql expression length
is there any limit about sql expression length
ibrahim Bulut
ileti�im Online Ltd.�ti.
Software and Database Expert
Turkish Republic
[Non-text portions of this message have been removed]
I am using firebird 1.5.1
i want to ask a question to firebird users.
is there any limit about "IN" clause
example
======
select field1, field2 from table1
where
(field1 in (param1, param2, param3.... paramN)) and
(field2 in (Fparam1, Fparam2, Fparam3.... FparamN))
how many params i can write to IN clause
is there any limit about IN clause
and how many characters can be sql expression length
is there any limit about sql expression length
ibrahim Bulut
ileti�im Online Ltd.�ti.
Software and Database Expert
Turkish Republic
[Non-text portions of this message have been removed]