Re: sqlite3_limit equivalent in System.Data.SQLite.dll

Hello,

I'm attempting to use the new SetLimitOption added to the 1.0.112 version of System.Data.SQLite.dll. Either I'm not using this function correctly or there is a problem within the dll. Any help you can provide is greatly appreciated.

        private void Button_Click (object sender, RoutedEventArgs e)
            {
            int iRequestValue = 20;
            String fName = @"d:\vancouver\OpenCommsCPV.db";
            String connStr = String.Format("Data Source={0}, Version=3", fName);
            SQLiteConnection conn = new SQLiteConnection(connStr);
            conn.Open();

            int iOldValue = conn.SetLimitOption(SQLiteLimitOpsEnum.SQLITE_LIMIT_ATTACHED, iRequestValue);
            int iNewValue = conn.SetLimitOption(SQLiteLimitOpsEnum.SQLITE_LIMIT_ATTACHED, -1);  // Pass -1 to get the current value.
            if ( iNewValue != iRequestValue )
                {
                MessageBox.Show("Setting Num Attachments limit failed.");
                }
            else
                {
                MessageBox.Show("Setting Num Attachments limit succeeded.");
                }
            }

Keith

-----Original Message-----
From: sqlite-users <[email protected]> On Behalf Of Joe Mistachkin
Sent: Thursday, October 24, 2019 8:36 AM
To: SQLite mailing list <[email protected]>
Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll


Yes, the NuGet packages are included in the release.

Sent from my iPhone

> On Oct 24, 2019, at 9:13 AM, Keith Bertram <[email protected]> wrote:
> 
> Ok. Thanks. Does it get immediately placed under nuget?
> 
> Keith
> 
> -----Original Message-----
> From: sqlite-users <[email protected]> On 
> Behalf Of Joe Mistachkin
> Sent: Thursday, October 24, 2019 8:12 AM
> To: SQLite mailing list <[email protected]>
> Subject: Re: [sqlite] sqlite3_limit equivalent in 
> System.Data.SQLite.dll
> 
> 
> Within the next week or so.
> 
> Sent from my iPhone
> 
>> On Oct 24, 2019, at 8:37 AM, Keith Bertram <[email protected]> wrote:
>> 
>> Ok. Thanks. Do you have an estimated release date?
>> 
>> Keith
>> 
>> -----Original Message-----
>> From: sqlite-users <[email protected]> On 
>> Behalf Of Joe Mistachkin
>> Sent: Wednesday, October 23, 2019 9:08 PM
>> To: 'SQLite mailing list' <[email protected]>
>> Subject: Re: [sqlite] sqlite3_limit equivalent in 
>> System.Data.SQLite.dll
>> 
>> 
>> Keith Bertram wrote:
>>> 
>>> The default limit for the number of attached databases appears to be
>>> 10
>> with the
>>> 1.0.106 version of System.Data.SQLite.dll and I would like to 
>>> increase
>> this value
>>> to 25. I've used the sqlite3_limit function in the past to increase 
>>> this

_______________________________________________
sqlite-users mailing list
[email protected]
https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc&m=e4b8CwDAzK1-TKWOZZJxjXuHFSnDxxfXP6h5QVKBpaI&s=dOVM934ewvnS0gL9iui_PzN0keYUOjW48CiQW0Xea6A&e= 
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users