On Mon, Sep 3, 2012 at 8:54 AM, Bhardwaj Amit Kumar <
[email protected]> wrote:

> Hi,
>
> We are working on .NET application which deals with huge amount of data.
> We are using SQLite as database for this application. We are getting "too
> many sql parameters...." exceptions frequently.
> We need to perform various types of queries on database which generates
> more than 999 parameters that exceeds SQLite parameter limit.
>
> We would appreciate if you would help us customizing the SQLite database
> parameter limit.
>

You will need to
recompile<http://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki>System.Data.SQLite
and set the compile-time option
SQLITE_MAX_VARIABLE_NUMBER to some value greater than 999.


>
> Kindly provide the steps to get this done.
>
> Thanks,
> Amit Bhardwaj
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to