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 <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf Of
Joe Mistachkin
Sent: Thursday, October 24, 2019 8:36 AM
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
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 <keith.bert...@bentley.com> wrote:
>
> Ok. Thanks. Does it get immediately placed under nuget?
>
> Keith
>
> -----Original Message-----
> From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On
> Behalf Of Joe Mistachkin
> Sent: Thursday, October 24, 2019 8:12 AM
> To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
> 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 <keith.bert...@bentley.com> wrote:
>>
>> Ok. Thanks. Do you have an estimated release date?
>>
>> Keith
>>
>> -----Original Message-----
>> From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On
>> Behalf Of Joe Mistachkin
>> Sent: Wednesday, October 23, 2019 9:08 PM
>> To: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org>
>> 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
sqlite-users@mailinglists.sqlite.org
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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
