Victor Charles
asked on
Help with avoiding error message
Hi,
When running a query with multiple OR statements (VB.NET) containg a very long search string, I teceive the following error message, "System.StackOverFlowExcep tion' occured in System.Data.dll"
How do I avoid this error?
Victor
When running a query with multiple OR statements (VB.NET) containg a very long search string, I teceive the following error message, "System.StackOverFlowExcep
How do I avoid this error?
Victor
You have probably made a mistake somewhere in the string. Check it for correctness.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi
It wotks with IN (1,2,3). Is there s maximum size allowed using IN ()?
Thanks,
Victor
It wotks with IN (1,2,3). Is there s maximum size allowed using IN ()?
Thanks,
Victor
Nothing specified in the documentation.
As shown in the first of the 2 links I sent you, there was a bug if IN became too big in SQL Server 2000. I supposed it has been corrected if you are using a newer versions.
As shown in the first of the 2 links I sent you, there was a bug if IN became too big in SQL Server 2000. I supposed it has been corrected if you are using a newer versions.
ASKER
Thanks.
ASKER
Thank you