[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
That's not an SQLitespeed feature but indeed a backwards-compatible SQLite feature. (I had this wrong too at some point) You probably already know, but to be clear: In SQL standard, double-quotes indicate identifiers and single quotes indicate string values. While the single quotes are used more or less universally, identifiers often get quoted differently. In Postgres and SQLite the standard is adhered to with Double quotes. MySQL uses a back-tick like this ` (which, by the way, will also work in SQLite due the same backward compatibility) MSSQL likes the square brackets [ and ] around identifiers (which, again, also works in SQLite for the same reason) Further to this, in earlier MySQL and in SQLite you may also use double quotes to denote strings, and it will regard a double-quoted value to be a string if A - it isn't an identifier, or B - used in a place where you can't use an identifier. (You can just imagine the bugs in your SQL that can arise from this!) While all of the above works, you are strongly encouraged to simply do it correctly and use double-quotes for identifiers and single quotes for strings. We have been lobbying for a strict-mode in SQLite where none of these shenanigans are allowed - but that is far easier said than done. On 2016/02/09 5:10 PM, Chris Prakoso wrote: > Actually I've just done it now, in SQLiteSpeed, and it allowed me to use > double-quote as delimiter successfully. > > Regards, > Chris > > On Tue, Feb 9, 2016 at 3:03 PM, Simon Slavin wrote: > >> On 9 Feb 2016, at 12:10pm, Chris Prakoso wrote: >> >>> *insert into test (field1,field2) values (1,"two"),(2,"three")* >> As well as the comments about your software being out of date, you need to >> know that the text delimiter in SQLite is the non-directional single quote >> character normally seen as an apostrophe. You cannot successfully use the >> double quote character or any directional quotes. >> >> Should be >> >> insert into test (field1,field2) values (1,'two'),(2,'three') >> >> Simon. >> ___ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.
Yes. Nothing complicated, fortunately. On Tue, Feb 9, 2016 at 4:09 PM, Steven M. McNeese < steven.mcneese at freedomparkdfw.com> wrote: > So are you saying you are just reading data from your SQLite db using C# > and > just need to insert using the SQLite command? > > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Chris > Prakoso > Sent: Tuesday, February 9, 2016 7:56 AM > To: SQLite mailing list > Subject: Re: [sqlite] C# + SQLite - Update/Insert using Transaction is > slower than without. > > Steven, > > I don't use any back-end, the code I pasted here IS my back-end. I opted > for direct SQLite connection. So I don't use EF6 nor Linq. > > Chris > > On Tue, Feb 9, 2016 at 1:47 PM, Steven M. McNeese < > steven.mcneese at freedomparkdfw.com> wrote: > > > Chris, > > > > What are you using in c# for SQLite back end? Ado.net? Linq. Let me > > know and I can help you with bulk inserts. > > > > Sent from my iPhone > > > > > On Feb 9, 2016, at 6:13 AM, Chris Prakoso wrote: > > > > > > Ok. Got it. > > > Now, if only I can get that multiple rows update working on my code, > > > it would be perfect. > > > > > > Thanks a lot, > > > Chris > > > > > >> On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch > > >> > > wrote: > > >> > > >> Chris Prakoso wrote: > > >>>public bool UpdateData(string tableName, > > >> Dictionary fields, List whereKeys) > > >>>{ > > >>>... > > >>>using (SQLiteTransaction transaction = > > >> conn.BeginTransaction()) > > >>>{ > > >>>... > > >>>rowsUpdated = cmd.ExecuteNonQuery(); > > >>>transaction.Commit(); > > >> > > >> Using one transaction for each statement is slow. > > >> (Re-opening the database doesn't help either.) > > >> > > >> You should use a single transaction around all update statements. > > >> > > >> > > >> Regards, > > >> Clemens > > >> ___ > > >> sqlite-users mailing list > > >> sqlite-users at mailinglists.sqlite.org > > >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-user > > >> s > > > ___ > > > sqlite-users mailing list > > > sqlite-users at mailinglists.sqlite.org > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > ___ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
Thanks for the detailed explanation. Regards, Chris On Tue, Feb 9, 2016 at 4:05 PM, R Smith wrote: > That's not an SQLitespeed feature but indeed a backwards-compatible SQLite > feature. (I had this wrong too at some point) > > You probably already know, but to be clear: In SQL standard, double-quotes > indicate identifiers and single quotes indicate string values. > While the single quotes are used more or less universally, identifiers > often get quoted differently. > In Postgres and SQLite the standard is adhered to with Double quotes. > MySQL uses a back-tick like this ` (which, by the way, will also work in > SQLite due the same backward compatibility) > MSSQL likes the square brackets [ and ] around identifiers (which, again, > also works in SQLite for the same reason) > > Further to this, in earlier MySQL and in SQLite you may also use double > quotes to denote strings, and it will regard a double-quoted value to be a > string if A - it isn't an identifier, or B - used in a place where you > can't use an identifier. (You can just imagine the bugs in your SQL that > can arise from this!) > > While all of the above works, you are strongly encouraged to simply do it > correctly and use double-quotes for identifiers and single quotes for > strings. > > We have been lobbying for a strict-mode in SQLite where none of these > shenanigans are allowed - but that is far easier said than done. > > > > On 2016/02/09 5:10 PM, Chris Prakoso wrote: > >> Actually I've just done it now, in SQLiteSpeed, and it allowed me to use >> double-quote as delimiter successfully. >> >> Regards, >> Chris >> >> On Tue, Feb 9, 2016 at 3:03 PM, Simon Slavin >> wrote: >> >> On 9 Feb 2016, at 12:10pm, Chris Prakoso wrote: >>> >>> *insert into test (field1,field2) values (1,"two"),(2,"three")* >>> As well as the comments about your software being out of date, you need >>> to >>> know that the text delimiter in SQLite is the non-directional single >>> quote >>> character normally seen as an apostrophe. You cannot successfully use >>> the >>> double quote character or any directional quotes. >>> >>> Should be >>> >>> insert into test (field1,field2) values (1,'two'),(2,'three') >>> >>> Simon. >>> ___ >>> sqlite-users mailing list >>> sqlite-users at mailinglists.sqlite.org >>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >>> >>> ___ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
Hi, I have windowns phone project but one problem . Sqli te select result data type text column turkish characters encoding problem But Android operation system no problem turkish characters Salih Y?cel Mobil Grup Lideri /Mobile Group Leader Univera Bilgisayar Sistemleri San. ve Tic. A.?. Bu elektronik posta ve onunla iletilen b?t?n dosyalar sadece g?ndericisi taraf?ndan almas? ama?lanan yetkili ger?ek ya da t?zel ki?inin kullan?m? i?indir.E?er s?z konusu yetkili al?c? de?ilseniz bu elektronik postan?n i?eri?ini a??klaman?z, kopyalaman?z, y?nlendirmeniz ve kullanman?z kesinlikle yasakt?r ve bu elektronik postay? derhal silmeniz gerekmektedir. UN?VERA A.?. bu mesaj?n i?erdi?i bilgilerin do?rulu?u veya eksiksiz oldu?u konusunda herhangi bir garanti vermemektedir. Bu nedenle bu bilgilerin ne ?ekilde olursa olsun i?eri?inden, iletilmesinden, al?nmasndan ve saklanmas?ndan sorumlu de?ildir. Bu mesajdaki g?r??ler yalnzca g?nderen ki?iye aittir ve UN?VERA A.?.'nin g?r??lerini yans?tmayabilir. Bu e-posta bilinen b?t?n bilgisayar vir?slerine kar?? taranm??t?r. This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any dissemination, forwarding, copying or use of any of the information is strictly prohibited, and the e-mail should immediately be deleted. UNIVERA A.S. makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. The opinions expressed in this message belong to sender alone and may not necessarily reflect the opinions of UNIVERA A.S. This e-mail has been scanned for all known computer viruses. -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Chris Prakoso Sent: Tuesday, February 9, 2016 5:09 PM To: SQLite mailing list Subject: Re: [sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates? Yes thank you. My SQLite is the latest, it's the front-end that is outdated, which I have just swiftly corrected. Regards, Chris On Tue, Feb 9, 2016 at 2:52 PM, Richard Hipp wrote: > On 2/9/16, Clemens Ladisch wrote: > > Chris Prakoso wrote: > >> insert into test (field1,field2) values (1,"two"),(2,"three") > >> > >> SQL Error: near ",": syntax error > > > > You might want to update to a tool that is not years out of date. > > > > What Clemens means by this is that prior to SQLite 3.7.11 (2012-03-20) > the INSERT statement would only take a single row in the VALUES > clause. He is suggesting that you are using a version of SQLite that > is 4 year old or older and therefore lacks this feature. > > -- > D. Richard Hipp > drh at sqlite.org > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
Chris Prakoso wrote: > insert into test (field1,field2) values (1,"two"),(2,"three") > > SQL Error: near ",": syntax error You might want to update to a tool that is not years out of date. Regards, Clemens
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
Ok. Thanks for the reminder. Regards, Chris On Tue, Feb 9, 2016 at 3:18 PM, Richard Hipp wrote: > On 2/9/16, Chris Prakoso wrote: > > Actually I've just done it now, in SQLiteSpeed, and it allowed me to use > > double-quote as delimiter successfully. > > > > That is supported for backwards compatibility. I originally put in > support for double-quoted string literals to be compatible with MySQL > 3.5. I have long since regretted that decision. You are encouraged > to use single-quotes for string literals, as double-quotes have a very > different meaning that can lead to subtle bugs. > -- > D. Richard Hipp > drh at sqlite.org > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
Actually I've just done it now, in SQLiteSpeed, and it allowed me to use double-quote as delimiter successfully. Regards, Chris On Tue, Feb 9, 2016 at 3:03 PM, Simon Slavin wrote: > > On 9 Feb 2016, at 12:10pm, Chris Prakoso wrote: > > > *insert into test (field1,field2) values (1,"two"),(2,"three")* > > As well as the comments about your software being out of date, you need to > know that the text delimiter in SQLite is the non-directional single quote > character normally seen as an apostrophe. You cannot successfully use the > double quote character or any directional quotes. > > Should be > > insert into test (field1,field2) values (1,'two'),(2,'three') > > Simon. > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
Yes thank you. My SQLite is the latest, it's the front-end that is outdated, which I have just swiftly corrected. Regards, Chris On Tue, Feb 9, 2016 at 2:52 PM, Richard Hipp wrote: > On 2/9/16, Clemens Ladisch wrote: > > Chris Prakoso wrote: > >> insert into test (field1,field2) values (1,"two"),(2,"three") > >> > >> SQL Error: near ",": syntax error > > > > You might want to update to a tool that is not years out of date. > > > > What Clemens means by this is that prior to SQLite 3.7.11 (2012-03-20) > the INSERT statement would only take a single row in the VALUES > clause. He is suggesting that you are using a version of SQLite that > is 4 year old or older and therefore lacks this feature. > > -- > D. Richard Hipp > drh at sqlite.org > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
On 9 Feb 2016, at 12:10pm, Chris Prakoso wrote: > *insert into test (field1,field2) values (1,"two"),(2,"three")* As well as the comments about your software being out of date, you need to know that the text delimiter in SQLite is the non-directional single quote character normally seen as an apostrophe. You cannot successfully use the double quote character or any directional quotes. Should be insert into test (field1,field2) values (1,'two'),(2,'three') Simon.
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
On 2016/02/09 1:30 PM, Chris Prakoso wrote: > Hi Clemens, > > Thanks for your reply. I've tried to use raw SQL but it didn't work > either. Do you have any SQLite front-end that you use? If I may suggest, try SQLitespeed (http://sqlc.rifin.co.za/) and add your DB file, open it and then use the buttons on the far right (such as "Insert", "Update", "Delete", etc.) to produce the SQL that will insert to or update the selected table. You can then see the correct syntax and expand on it to add your own values etc. You could also right-click on the results list and select from the menu "Row Actions"-->"Show UPDATE SQL for changing this row" or "Show INSERT SQL for copying this row" etc. There are a myriad more auto-SQL things in there, perhaps a good option if you are learning SQL still. You could also right-click in a query and then select "Copy as Code"-->"Java"/"C#"/ whatever you like, or add your own codify settings for your preferred language to take the pain out of adapting queries to code. The INSERT and UPDATE functions you described should really work in SQL, so perhaps it's a small syntax error or such preventing success. (PS: This list is not a support group for SQLitespeed or any other gui, you may use its own bug/query reporter from the menu to get help there) Cheers, Ryan
[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.
Steven, I don't use any back-end, the code I pasted here IS my back-end. I opted for direct SQLite connection. So I don't use EF6 nor Linq. Chris On Tue, Feb 9, 2016 at 1:47 PM, Steven M. McNeese < steven.mcneese at freedomparkdfw.com> wrote: > Chris, > > What are you using in c# for SQLite back end? Ado.net? Linq. Let me know > and I can help you with bulk inserts. > > Sent from my iPhone > > > On Feb 9, 2016, at 6:13 AM, Chris Prakoso wrote: > > > > Ok. Got it. > > Now, if only I can get that multiple rows update working on my code, it > > would be perfect. > > > > Thanks a lot, > > Chris > > > >> On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch > wrote: > >> > >> Chris Prakoso wrote: > >>>public bool UpdateData(string tableName, > >> Dictionary fields, List whereKeys) > >>>{ > >>>... > >>>using (SQLiteTransaction transaction = > >> conn.BeginTransaction()) > >>>{ > >>>... > >>>rowsUpdated = cmd.ExecuteNonQuery(); > >>>transaction.Commit(); > >> > >> Using one transaction for each statement is slow. > >> (Re-opening the database doesn't help either.) > >> > >> You should use a single transaction around all update statements. > >> > >> > >> Regards, > >> Clemens > >> ___ > >> sqlite-users mailing list > >> sqlite-users at mailinglists.sqlite.org > >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > ___ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
Thanks Ryan, I will definitely try it. I'm ok with raw SQL, just not familiar with the odd ones like this multiple rows update. Thanks a lot, Chris On Tue, Feb 9, 2016 at 12:42 PM, R Smith wrote: > > > On 2016/02/09 1:30 PM, Chris Prakoso wrote: > >> Hi Clemens, >> >> Thanks for your reply. I've tried to use raw SQL but it didn't work >> either. Do you have any SQLite front-end that you use? >> > > If I may suggest, try SQLitespeed (http://sqlc.rifin.co.za/) and add your > DB file, open it and then use the buttons on the far right (such as > "Insert", "Update", "Delete", etc.) to produce the SQL that will insert to > or update the selected table. You can then see the correct syntax and > expand on it to add your own values etc. > > You could also right-click on the results list and select from the menu > "Row Actions"-->"Show UPDATE SQL for changing this row" or "Show INSERT SQL > for copying this row" etc. > There are a myriad more auto-SQL things in there, perhaps a good option if > you are learning SQL still. > > You could also right-click in a query and then select "Copy as > Code"-->"Java"/"C#"/ whatever you like, or add your own codify settings for > your preferred language to take the pain out of adapting queries to code. > > The INSERT and UPDATE functions you described should really work in SQL, > so perhaps it's a small syntax error or such preventing success. > > > (PS: This list is not a support group for SQLitespeed or any other gui, > you may use its own bug/query reporter from the menu to get help there) > > Cheers, > Ryan > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.
Chris Prakoso wrote: > public bool UpdateData(string tableName, Dictionary > fields, List whereKeys) > { > ... > using (SQLiteTransaction transaction = > conn.BeginTransaction()) > { > ... > rowsUpdated = cmd.ExecuteNonQuery(); > transaction.Commit(); Using one transaction for each statement is slow. (Re-opening the database doesn't help either.) You should use a single transaction around all update statements. Regards, Clemens
[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.
Ok. Got it. Now, if only I can get that multiple rows update working on my code, it would be perfect. Thanks a lot, Chris On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch wrote: > Chris Prakoso wrote: > > public bool UpdateData(string tableName, > Dictionary fields, List whereKeys) > > { > > ... > > using (SQLiteTransaction transaction = > conn.BeginTransaction()) > > { > > ... > > rowsUpdated = cmd.ExecuteNonQuery(); > > transaction.Commit(); > > Using one transaction for each statement is slow. > (Re-opening the database doesn't help either.) > > You should use a single transaction around all update statements. > > > Regards, > Clemens > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.
Chris Prakoso wrote: > I've been testing the performance of my Insert/Update using > Transaction and without, and I found that it is quicker when I don't > use it. Show the code. Regards, Clemens
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
Chris Prakoso wrote: > My question is whether anybody had successfully implemented multiple > rows Insert/Update. This is possible in SQL: INSERT INTO MyTable(ID, Value) VALUES (1, 'hello'), (2, 'world'); UPDATE MyTable SET Value = 'the same value' WHERE ID IN (1, 2); -- rather verbose; better use two simple UPDATEs: UPDATE MyTable SET Value = CASE ID WHEN 1 THEN 'new A' WHEN 2 THEN 'new B' END WHERE ID IN (1, 2); Regards, Clemens
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
I did a test using simple table, and entering the sql directly using SQLite Administrator: *insert into test (field1,field2) values (1,"two"),(2,"three")* The error I got from the SQLite Administrator is: *2/9/2016 11:29:40 AM: SQL Error: near ",": syntax error * Thanks, Chris On Tue, Feb 9, 2016 at 11:55 AM, Richard Hipp wrote: > On 2/9/16, Chris Prakoso wrote: > > Hi Clemens, > > > > Thanks for your reply. I've tried to use raw SQL but it didn't work > > either. > > Please show us the SQL that you did you. > > > Do you have any SQLite front-end that you use? > > > > The only supported "front-end" (if I correctly understand your > meaning) is the command-line tool "sqlite3.exe" available from the > https://www.sqlite.org/download.html page. There are many other > third-party tools, most of which are GUI-based. You can use them if > you want, and they usually work quite well, but occasionally have > bugs. > > -- > D. Richard Hipp > drh at sqlite.org > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.
Here they are: public bool UpdateData(string tableName, Dictionary fields, List whereKeys) { bool result = false; string sql = ""; List fieldList = new List(); List whereKeyList = new List(); int rowsUpdated = 0; using (SQLiteConnection conn = new SQLiteConnection(this.ConnectionString)) { try { conn.Open(); SQLiteCommand cmd = new SQLiteCommand(conn); using (SQLiteTransaction transaction = conn.BeginTransaction()) { // Build a list of fields need to be updated if (fields.Count > 0) { foreach (KeyValuePair kvp in fields) { cmd.Parameters.AddWithValue(kvp.Key, kvp.Value); fieldList.Add(kvp.Key); } } sql = "update " + tableName + " set " + this.BuildUpdateFieldList(fieldList) + " where " + this.BuildWhereClause(whereKeys); cmd.CommandText = sql; rowsUpdated = cmd.ExecuteNonQuery(); transaction.Commit(); } if (rowsUpdated > 0) result = true; } catch (System.Exception ex) { this.UpdateStatusMessage(ex.Message); } } return result; } On Tue, Feb 9, 2016 at 11:13 AM, Clemens Ladisch wrote: > Chris Prakoso wrote: > > I've been testing the performance of my Insert/Update using > > Transaction and without, and I found that it is quicker when I don't > > use it. > > Show the code. > > > Regards, > Clemens > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
Hi Clemens, Thanks for your reply. I've tried to use raw SQL but it didn't work either. Do you have any SQLite front-end that you use? Regards, Chris On Tue, Feb 9, 2016 at 11:12 AM, Clemens Ladisch wrote: > Chris Prakoso wrote: >> My question is whether anybody had successfully implemented multiple >> rows Insert/Update. > > This is possible in SQL: > > INSERT INTO MyTable(ID, Value) > VALUES (1, 'hello'), >(2, 'world'); > > UPDATE MyTable > SET Value = 'the same value' > WHERE ID IN (1, 2); > > -- rather verbose; better use two simple UPDATEs: > UPDATE MyTable > SET Value = CASE ID > WHEN 1 THEN 'new A' > WHEN 2 THEN 'new B' > END > WHERE ID IN (1, 2); > > > Regards, > Clemens > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.
Hi all, I've been testing the performance of my Insert/Update using Transaction and without, and I found that it is quicker when I don't use it. Anybody has an insight on this? Thanks a lot, Chris
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
Hi all, I just joined the Mailing List yesterday, so apologise for any mistake I am doing. I'm a .NET (C#) Developer, and at the moment I'm coding a small app with SQLite as the backend database. My question is whether anybody had successfully implemented multiple rows Insert/Update. I've tried to use INSERT OR REPLACE and passing multiple VALUES, but it didn't seem to work. Any pointers would be appreciated. Thanks very much, Chris
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
On 2/9/16, Chris Prakoso wrote: > Actually I've just done it now, in SQLiteSpeed, and it allowed me to use > double-quote as delimiter successfully. > That is supported for backwards compatibility. I originally put in support for double-quoted string literals to be compatible with MySQL 3.5. I have long since regretted that decision. You are encouraged to use single-quotes for string literals, as double-quotes have a very different meaning that can lead to subtle bugs. -- D. Richard Hipp drh at sqlite.org
[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.
So are you saying you are just reading data from your SQLite db using C# and just need to insert using the SQLite command? -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Chris Prakoso Sent: Tuesday, February 9, 2016 7:56 AM To: SQLite mailing list Subject: Re: [sqlite] C# + SQLite - Update/Insert using Transaction is slower than without. Steven, I don't use any back-end, the code I pasted here IS my back-end. I opted for direct SQLite connection. So I don't use EF6 nor Linq. Chris On Tue, Feb 9, 2016 at 1:47 PM, Steven M. McNeese < steven.mcneese at freedomparkdfw.com> wrote: > Chris, > > What are you using in c# for SQLite back end? Ado.net? Linq. Let me > know and I can help you with bulk inserts. > > Sent from my iPhone > > > On Feb 9, 2016, at 6:13 AM, Chris Prakoso wrote: > > > > Ok. Got it. > > Now, if only I can get that multiple rows update working on my code, > > it would be perfect. > > > > Thanks a lot, > > Chris > > > >> On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch > >> > wrote: > >> > >> Chris Prakoso wrote: > >>>public bool UpdateData(string tableName, > >> Dictionary fields, List whereKeys) > >>>{ > >>>... > >>>using (SQLiteTransaction transaction = > >> conn.BeginTransaction()) > >>>{ > >>>... > >>>rowsUpdated = cmd.ExecuteNonQuery(); > >>>transaction.Commit(); > >> > >> Using one transaction for each statement is slow. > >> (Re-opening the database doesn't help either.) > >> > >> You should use a single transaction around all update statements. > >> > >> > >> Regards, > >> Clemens > >> ___ > >> sqlite-users mailing list > >> sqlite-users at mailinglists.sqlite.org > >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-user > >> s > > ___ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
On 2/9/16, Clemens Ladisch wrote: > Chris Prakoso wrote: >> insert into test (field1,field2) values (1,"two"),(2,"three") >> >> SQL Error: near ",": syntax error > > You might want to update to a tool that is not years out of date. > What Clemens means by this is that prior to SQLite 3.7.11 (2012-03-20) the INSERT statement would only take a single row in the VALUES clause. He is suggesting that you are using a version of SQLite that is 4 year old or older and therefore lacks this feature. -- D. Richard Hipp drh at sqlite.org
[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.
Chris, What are you using in c# for SQLite back end? Ado.net? Linq. Let me know and I can help you with bulk inserts. Sent from my iPhone > On Feb 9, 2016, at 6:13 AM, Chris Prakoso wrote: > > Ok. Got it. > Now, if only I can get that multiple rows update working on my code, it > would be perfect. > > Thanks a lot, > Chris > >> On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch >> wrote: >> >> Chris Prakoso wrote: >>>public bool UpdateData(string tableName, >> Dictionary fields, List whereKeys) >>>{ >>>... >>>using (SQLiteTransaction transaction = >> conn.BeginTransaction()) >>>{ >>>... >>>rowsUpdated = cmd.ExecuteNonQuery(); >>>transaction.Commit(); >> >> Using one transaction for each statement is slow. >> (Re-opening the database doesn't help either.) >> >> You should use a single transaction around all update statements. >> >> >> Regards, >> Clemens >> ___ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
On 2/9/16, Chris Prakoso wrote: > Hi Clemens, > > Thanks for your reply. I've tried to use raw SQL but it didn't work > either. Please show us the SQL that you did you. > Do you have any SQLite front-end that you use? > The only supported "front-end" (if I correctly understand your meaning) is the command-line tool "sqlite3.exe" available from the https://www.sqlite.org/download.html page. There are many other third-party tools, most of which are GUI-based. You can use them if you want, and they usually work quite well, but occasionally have bugs. -- D. Richard Hipp drh at sqlite.org
Re: [sqlite] C# - SQLite - and other things
Incongruous wrote: > > After downloading sqlite-netFx451-static-binary-x64-2013-1.0.90.0 and uncompressing > it, I got this list of file: > I think using the System.Data.SQLite NuGet package would be better in this case. The package is here (it can also be found by searching in the Visual Studio IDE): https://nuget.org/api/v2/package/System.Data.SQLite/1.0.91.0 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] C# - SQLite - and other things
After downloading sqlite-netFx451-static-binary-x64-2013-1.0.90.0 and uncompressing it, I got this list of file: Installer.exe Installer.pdb northwindEF.db SQLite.Designer.dll SQLite.Designer.pdb SQLite.Designer.xml SQLite.Interop.dll SQLite.Interop.pdb sqlite_file_list.txt System.Data.SQLite.dll System.Data.SQLite.Linq.dll System.Data.SQLite.Linq.pdb System.Data.SQLite.Linq.xml System.Data.SQLite.pdb System.Data.SQLite.xml test.db test.exe test.exe.config test.pdb testlinq.exe testlinq.exe.config testlinq.pdb [ I tried the intaller.exe, but I get a msg saying: Cannot continue, the "confirm" option is not enabled. ] I have a project that looks like this: Project: | pro.exe\ | |---> image \ | |---> gui \ | |---> mylib \ | |---> sound \ | |---> sqlite \ | mysqlite.cs---|--->%PATH% |__>SQLite.Designer.dll SQLite.Designer.xml SQLite.Interop.dll System.Data.SQLite.dll System.Data.SQLite.Linq.dll The files contained in the sqlite-netFx451-static-binary-x64-2013-1.0.90.0 are located in a folder that exists in the %path%, but I cannot stop to wonder if all the files are necessary or if all I need is the DLLs in order to reference the methods in the database, and if I only need certain files, which ones are those? My second question is, how can I add the DLLs from sqlite-netFx451-static-binary-x64-2013-1.0.90.0 to the ‘mysqlite.cs’ file in order to reference the its methods? I know that this question is unrelated to SQLite, but in its answer is my complete understanding of the solution provided. Any help would be much appreciated. Thanks in advance. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
RE: [sqlite] C++ SQLite
I did try the ODBC driver, but I found it was quite a bit slower. RBS > RB Smissaert uttered: > >> Yes, that looks to be the way to do it. Basically will have to learn how >> to >> translate C defines to VB declares. > > > Why not just use ODBC? > > http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc > http://www.ch-werner.de/sqliteodbc/ > > That way, you're not even tied to SQLite. > > >> >> RBS >> >> -Original Message- >> From: John Stanton [mailto:[EMAIL PROTECTED] >> Sent: 28 November 2006 21:58 >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] C++ SQLite >> >> Maybe all you have to do is to make yourself a list og VB types cross >> referenced to the fundamental type used in the Win32 and Sqlite APIs. >> Then you could link any library into your VB programs. >> >> RB Smissaert wrote: >>> You might be right, but with the Win32 API you have loads of nice >>> documents/programs (I like the API guide from KPD) that help you out. >>> All I have to do is copy their declares straight to VB and look at the >> data >>> types I have to provide. Is the same available for the SQLite API? >>> >>> RBS >>> >>> -Original Message- >>> From: John Stanton [mailto:[EMAIL PROTECTED] >>> Sent: 28 November 2006 18:43 >>> To: sqlite-users@sqlite.org >>> Subject: Re: [sqlite] C++ SQLite >>> >>> If you can use the Win32 API you can use the Sqlite API. Just because >>> they can be called from C programs does not make them "all to do with >>> C". >>> >>> RB Smissaert wrote: >>> >>>> Will have a look, but I was looking for a text geared towards VB. I >>>> take >>> >>> it >>> >>>> the documentation that comes with SQLite is all to do with C. >>>> In fact I already have a wrapper that seems to work well, the one from >>>> TerraInformatica, but maybe there was more control if I could write my >>> >>> own. >>> >>>> RBS >>>> >>>> -Original Message- >>>> From: Clay Dowling [mailto:[EMAIL PROTECTED] >>>> Sent: 28 November 2006 18:19 >>>> To: sqlite-users@sqlite.org >>>> Subject: Re: [sqlite] C++ SQLite >>>> >>>> >>>> [EMAIL PROTECTED] said: >>>> >>>> >>>>> Thanks. Would you know any VB source code that wraps all the possible >>>>> declares in a class? Or do you know where to find the documentation >>>>> to make all the possible declares in VB/VBA? >>>>> >>>>> RBS >>>> >>>> >>>> The SQLite documentation will give you everything you need to write >>>> the >>>> wrapper. The sqlite.h file in the source bundle would also be a great >>>> help. You may also be able to find a wrapper already written linked >>>> on >>>> the SQLite web site. >>>> >>>> Clay Dowling >>>> >>>> >>>> >>>>>> Yes. It's a regular windows DLL, so it will behave like all other >>>>>> Windows >>>>>> DLLs. >>>>>> >>>>>> Clay Dowling >>>>>> >>>>>> [EMAIL PROTECTED] said: >>>>>> >>>>>> >>>>>>> Can I call the SQLite API (as in the dll SQLite.dll) directly from >>>>>>> VB or do I need the wrapper? So, could it work from VB with >>>>>>> declares >>>>>>> as I use for the Windows API? >>>>>>> >>>>>>> RBS >>>>>>> >>>>>>> >>>>>>> >>>>>>>> sebcity wrote: >>>>>>>> >>>>>>>> >>>>>>>>> How would one go about using c++ (Visual Studio.NET) to call and >>>>>>>>> display >>>>>>>>> SQLite tables. C++ wrappers? >>>>>>>> >>>>>>>> You should be able to call the Sqlite3 API directly. >>>>>>>> >>>>>>>> >>>> >>>> >>> >> >>> >>>> - >>>> >>>> >>>>>>>> To unsubscribe, send email to [EMAIL
RE: [sqlite] C++ SQLite
RB Smissaert uttered: Yes, that looks to be the way to do it. Basically will have to learn how to translate C defines to VB declares. Why not just use ODBC? http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc http://www.ch-werner.de/sqliteodbc/ That way, you're not even tied to SQLite. RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 21:58 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite Maybe all you have to do is to make yourself a list og VB types cross referenced to the fundamental type used in the Win32 and Sqlite APIs. Then you could link any library into your VB programs. RB Smissaert wrote: You might be right, but with the Win32 API you have loads of nice documents/programs (I like the API guide from KPD) that help you out. All I have to do is copy their declares straight to VB and look at the data types I have to provide. Is the same available for the SQLite API? RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:43 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite If you can use the Win32 API you can use the Sqlite API. Just because they can be called from C programs does not make them "all to do with C". RB Smissaert wrote: Will have a look, but I was looking for a text geared towards VB. I take it the documentation that comes with SQLite is all to do with C. In fact I already have a wrapper that seems to work well, the one from TerraInformatica, but maybe there was more control if I could write my own. RBS -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:19 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite [EMAIL PROTECTED] said: Thanks. Would you know any VB source code that wraps all the possible declares in a class? Or do you know where to find the documentation to make all the possible declares in VB/VBA? RBS The SQLite documentation will give you everything you need to write the wrapper. The sqlite.h file in the source bundle would also be a great help. You may also be able to find a wrapper already written linked on the SQLite web site. Clay Dowling Yes. It's a regular windows DLL, so it will behave like all other Windows DLLs. Clay Dowling [EMAIL PROTECTED] said: Can I call the SQLite API (as in the dll SQLite.dll) directly from VB or do I need the wrapper? So, could it work from VB with declares as I use for the Windows API? RBS sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You should be able to call the Sqlite3 API directly. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- /"\ \ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \ - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
There us very little to learn, just equivalent names for types. RB Smissaert wrote: Yes, that looks to be the way to do it. Basically will have to learn how to translate C defines to VB declares. RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 21:58 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite Maybe all you have to do is to make yourself a list og VB types cross referenced to the fundamental type used in the Win32 and Sqlite APIs. Then you could link any library into your VB programs. RB Smissaert wrote: You might be right, but with the Win32 API you have loads of nice documents/programs (I like the API guide from KPD) that help you out. All I have to do is copy their declares straight to VB and look at the data types I have to provide. Is the same available for the SQLite API? RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:43 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite If you can use the Win32 API you can use the Sqlite API. Just because they can be called from C programs does not make them "all to do with C". RB Smissaert wrote: Will have a look, but I was looking for a text geared towards VB. I take it the documentation that comes with SQLite is all to do with C. In fact I already have a wrapper that seems to work well, the one from TerraInformatica, but maybe there was more control if I could write my own. RBS -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:19 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite [EMAIL PROTECTED] said: Thanks. Would you know any VB source code that wraps all the possible declares in a class? Or do you know where to find the documentation to make all the possible declares in VB/VBA? RBS The SQLite documentation will give you everything you need to write the wrapper. The sqlite.h file in the source bundle would also be a great help. You may also be able to find a wrapper already written linked on the SQLite web site. Clay Dowling Yes. It's a regular windows DLL, so it will behave like all other Windows DLLs. Clay Dowling [EMAIL PROTECTED] said: Can I call the SQLite API (as in the dll SQLite.dll) directly from VB or do I need the wrapper? So, could it work from VB with declares as I use for the Windows API? RBS sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You should be able to call the Sqlite3 API directly. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Check that the version of VB, or VB itself supports calling external functions using 'cdecl' calling convention (instead of WINAPI stdcall). On 28/11/06, RB Smissaert <[EMAIL PROTECTED]> wrote: Yes, that looks to be the way to do it. Basically will have to learn how to translate C defines to VB declares. RBS - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] C++ SQLite
Yes, that looks to be the way to do it. Basically will have to learn how to translate C defines to VB declares. RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 21:58 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite Maybe all you have to do is to make yourself a list og VB types cross referenced to the fundamental type used in the Win32 and Sqlite APIs. Then you could link any library into your VB programs. RB Smissaert wrote: > You might be right, but with the Win32 API you have loads of nice > documents/programs (I like the API guide from KPD) that help you out. > All I have to do is copy their declares straight to VB and look at the data > types I have to provide. Is the same available for the SQLite API? > > RBS > > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: 28 November 2006 18:43 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] C++ SQLite > > If you can use the Win32 API you can use the Sqlite API. Just because > they can be called from C programs does not make them "all to do with C". > > RB Smissaert wrote: > >>Will have a look, but I was looking for a text geared towards VB. I take > > it > >>the documentation that comes with SQLite is all to do with C. >>In fact I already have a wrapper that seems to work well, the one from >>TerraInformatica, but maybe there was more control if I could write my > > own. > >>RBS >> >>-Original Message- >>From: Clay Dowling [mailto:[EMAIL PROTECTED] >>Sent: 28 November 2006 18:19 >>To: sqlite-users@sqlite.org >>Subject: Re: [sqlite] C++ SQLite >> >> >>[EMAIL PROTECTED] said: >> >> >>>Thanks. Would you know any VB source code that wraps all the possible >>>declares in a class? Or do you know where to find the documentation >>>to make all the possible declares in VB/VBA? >>> >>>RBS >> >> >>The SQLite documentation will give you everything you need to write the >>wrapper. The sqlite.h file in the source bundle would also be a great >>help. You may also be able to find a wrapper already written linked on >>the SQLite web site. >> >>Clay Dowling >> >> >> >>>>Yes. It's a regular windows DLL, so it will behave like all other >>>>Windows >>>>DLLs. >>>> >>>>Clay Dowling >>>> >>>>[EMAIL PROTECTED] said: >>>> >>>> >>>>>Can I call the SQLite API (as in the dll SQLite.dll) directly from >>>>>VB or do I need the wrapper? So, could it work from VB with declares >>>>>as I use for the Windows API? >>>>> >>>>>RBS >>>>> >>>>> >>>>> >>>>>>sebcity wrote: >>>>>> >>>>>> >>>>>>>How would one go about using c++ (Visual Studio.NET) to call and >>>>>>>display >>>>>>>SQLite tables. C++ wrappers? >>>>>> >>>>>>You should be able to call the Sqlite3 API directly. >>>>>> >>>>>> >> >> > > >>- >> >> >>>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>>> >> >> > > >>- >> >> >>>>>> >>>>> >>>>> >>>>> > > >>- >> >> >>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>> >> >> > > >>- >> >> >>>>-- >>>>Simple Content Management >>>>http://www.ceamus.com >>>> >>>> >>>> >> >> > > >>- >> >> >>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>> >> >> > > >>- >> >> >>>> >>> >>> >>> > > >>- >> >> >>>To unsubscribe, send email to [EMAIL PROTECTED] >>> >> >> > > >>- >> >> >> > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Maybe all you have to do is to make yourself a list og VB types cross referenced to the fundamental type used in the Win32 and Sqlite APIs. Then you could link any library into your VB programs. RB Smissaert wrote: You might be right, but with the Win32 API you have loads of nice documents/programs (I like the API guide from KPD) that help you out. All I have to do is copy their declares straight to VB and look at the data types I have to provide. Is the same available for the SQLite API? RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:43 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite If you can use the Win32 API you can use the Sqlite API. Just because they can be called from C programs does not make them "all to do with C". RB Smissaert wrote: Will have a look, but I was looking for a text geared towards VB. I take it the documentation that comes with SQLite is all to do with C. In fact I already have a wrapper that seems to work well, the one from TerraInformatica, but maybe there was more control if I could write my own. RBS -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:19 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite [EMAIL PROTECTED] said: Thanks. Would you know any VB source code that wraps all the possible declares in a class? Or do you know where to find the documentation to make all the possible declares in VB/VBA? RBS The SQLite documentation will give you everything you need to write the wrapper. The sqlite.h file in the source bundle would also be a great help. You may also be able to find a wrapper already written linked on the SQLite web site. Clay Dowling Yes. It's a regular windows DLL, so it will behave like all other Windows DLLs. Clay Dowling [EMAIL PROTECTED] said: Can I call the SQLite API (as in the dll SQLite.dll) directly from VB or do I need the wrapper? So, could it work from VB with declares as I use for the Windows API? RBS sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You should be able to call the Sqlite3 API directly. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] C++ SQLite
> In the amount of time that you've spent asking for an import > library on this list you could have written all of the imports. If you say so. Thanks in any case. RBS -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 21:39 To: sqlite-users@sqlite.org Subject: RE: [sqlite] C++ SQLite RB Smissaert said: > You might be right, but with the Win32 API you have loads of nice > documents/programs (I like the API guide from KPD) that help you out. > All I have to do is copy their declares straight to VB and look at the > data > types I have to provide. Is the same available for the SQLite API? > http://www.sqlite.org/capi3ref.html That's the page you want. It declares everything you need. In the amount of time that you've spent asking for an import library on this list you could have written all of the imports. The sqlite3* and sqlite3_stmt* types are just pointers, so you can declare them as such. Everything else is a fundamental type. Now you're good to go. Combine that with my article in a previous message about how to use the API and you're on the same footing as the C programmers who use the library. Clay Dowling > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: 28 November 2006 18:43 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] C++ SQLite > > If you can use the Win32 API you can use the Sqlite API. Just because > they can be called from C programs does not make them "all to do with C". > > RB Smissaert wrote: >> Will have a look, but I was looking for a text geared towards VB. I take > it >> the documentation that comes with SQLite is all to do with C. >> In fact I already have a wrapper that seems to work well, the one from >> TerraInformatica, but maybe there was more control if I could write my > own. >> >> RBS >> >> -Original Message----- >> From: Clay Dowling [mailto:[EMAIL PROTECTED] >> Sent: 28 November 2006 18:19 >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] C++ SQLite >> >> >> [EMAIL PROTECTED] said: >> >>>Thanks. Would you know any VB source code that wraps all the possible >>>declares in a class? Or do you know where to find the documentation >>>to make all the possible declares in VB/VBA? >>> >>>RBS >> >> >> The SQLite documentation will give you everything you need to write the >> wrapper. The sqlite.h file in the source bundle would also be a great >> help. You may also be able to find a wrapper already written linked on >> the SQLite web site. >> >> Clay Dowling >> >> >>> >>>>Yes. It's a regular windows DLL, so it will behave like all other >>>>Windows >>>>DLLs. >>>> >>>>Clay Dowling >>>> >>>>[EMAIL PROTECTED] said: >>>> >>>>>Can I call the SQLite API (as in the dll SQLite.dll) directly from >>>>>VB or do I need the wrapper? So, could it work from VB with declares >>>>>as I use for the Windows API? >>>>> >>>>>RBS >>>>> >>>>> >>>>>>sebcity wrote: >>>>>> >>>>>>>How would one go about using c++ (Visual Studio.NET) to call and >>>>>>>display >>>>>>>SQLite tables. C++ wrappers? >>>>>> >>>>>>You should be able to call the Sqlite3 API directly. >>>>>> >>>>>> >> >> > >> - >> >>>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>>> >> >> > >> - >> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> >> > >> - >> >>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>> >> >> > >> - >> >>>>> >>>> >>>>-- >>>>Simple Content Management >>>>http://www.ceamus.com >>>> >>>> >>>> >> >> > --
RE: [sqlite] C++ SQLite
RB Smissaert said: > You might be right, but with the Win32 API you have loads of nice > documents/programs (I like the API guide from KPD) that help you out. > All I have to do is copy their declares straight to VB and look at the > data > types I have to provide. Is the same available for the SQLite API? > http://www.sqlite.org/capi3ref.html That's the page you want. It declares everything you need. In the amount of time that you've spent asking for an import library on this list you could have written all of the imports. The sqlite3* and sqlite3_stmt* types are just pointers, so you can declare them as such. Everything else is a fundamental type. Now you're good to go. Combine that with my article in a previous message about how to use the API and you're on the same footing as the C programmers who use the library. Clay Dowling > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: 28 November 2006 18:43 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] C++ SQLite > > If you can use the Win32 API you can use the Sqlite API. Just because > they can be called from C programs does not make them "all to do with C". > > RB Smissaert wrote: >> Will have a look, but I was looking for a text geared towards VB. I take > it >> the documentation that comes with SQLite is all to do with C. >> In fact I already have a wrapper that seems to work well, the one from >> TerraInformatica, but maybe there was more control if I could write my > own. >> >> RBS >> >> -Original Message----- >> From: Clay Dowling [mailto:[EMAIL PROTECTED] >> Sent: 28 November 2006 18:19 >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] C++ SQLite >> >> >> [EMAIL PROTECTED] said: >> >>>Thanks. Would you know any VB source code that wraps all the possible >>>declares in a class? Or do you know where to find the documentation >>>to make all the possible declares in VB/VBA? >>> >>>RBS >> >> >> The SQLite documentation will give you everything you need to write the >> wrapper. The sqlite.h file in the source bundle would also be a great >> help. You may also be able to find a wrapper already written linked on >> the SQLite web site. >> >> Clay Dowling >> >> >>> >>>>Yes. It's a regular windows DLL, so it will behave like all other >>>>Windows >>>>DLLs. >>>> >>>>Clay Dowling >>>> >>>>[EMAIL PROTECTED] said: >>>> >>>>>Can I call the SQLite API (as in the dll SQLite.dll) directly from >>>>>VB or do I need the wrapper? So, could it work from VB with declares >>>>>as I use for the Windows API? >>>>> >>>>>RBS >>>>> >>>>> >>>>>>sebcity wrote: >>>>>> >>>>>>>How would one go about using c++ (Visual Studio.NET) to call and >>>>>>>display >>>>>>>SQLite tables. C++ wrappers? >>>>>> >>>>>>You should be able to call the Sqlite3 API directly. >>>>>> >>>>>> >> >> > >> - >> >>>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>>> >> >> > >> - >> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> >> > >> - >> >>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>> >> >> > >> - >> >>>>> >>>> >>>>-- >>>>Simple Content Management >>>>http://www.ceamus.com >>>> >>>> >>>> >> >> > >> - >> >>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>> >> >> > >> - >> >>>> >>>> >>> >>> >>> >>> >> > >> - >> >>>To unsubscribe, send email to [EMAIL PROTECTED] >>> >> >> > >> - >> >>> >> >> > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] C++ SQLite
You might be right, but with the Win32 API you have loads of nice documents/programs (I like the API guide from KPD) that help you out. All I have to do is copy their declares straight to VB and look at the data types I have to provide. Is the same available for the SQLite API? RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:43 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite If you can use the Win32 API you can use the Sqlite API. Just because they can be called from C programs does not make them "all to do with C". RB Smissaert wrote: > Will have a look, but I was looking for a text geared towards VB. I take it > the documentation that comes with SQLite is all to do with C. > In fact I already have a wrapper that seems to work well, the one from > TerraInformatica, but maybe there was more control if I could write my own. > > RBS > > -Original Message- > From: Clay Dowling [mailto:[EMAIL PROTECTED] > Sent: 28 November 2006 18:19 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] C++ SQLite > > > [EMAIL PROTECTED] said: > >>Thanks. Would you know any VB source code that wraps all the possible >>declares in a class? Or do you know where to find the documentation >>to make all the possible declares in VB/VBA? >> >>RBS > > > The SQLite documentation will give you everything you need to write the > wrapper. The sqlite.h file in the source bundle would also be a great > help. You may also be able to find a wrapper already written linked on > the SQLite web site. > > Clay Dowling > > >> >>>Yes. It's a regular windows DLL, so it will behave like all other >>>Windows >>>DLLs. >>> >>>Clay Dowling >>> >>>[EMAIL PROTECTED] said: >>> >>>>Can I call the SQLite API (as in the dll SQLite.dll) directly from >>>>VB or do I need the wrapper? So, could it work from VB with declares >>>>as I use for the Windows API? >>>> >>>>RBS >>>> >>>> >>>>>sebcity wrote: >>>>> >>>>>>How would one go about using c++ (Visual Studio.NET) to call and >>>>>>display >>>>>>SQLite tables. C++ wrappers? >>>>> >>>>>You should be able to call the Sqlite3 API directly. >>>>> >>>>> > > > - > >>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>> > > > - > >>>>> >>>>> >>>> >>>> >>>> >>>> > > - > >>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>> > > > - > >>>> >>> >>>-- >>>Simple Content Management >>>http://www.ceamus.com >>> >>> >>> > > > - > >>>To unsubscribe, send email to [EMAIL PROTECTED] >>> > > > - > >>> >>> >> >> >> >> > > - > >>To unsubscribe, send email to [EMAIL PROTECTED] >> > > > - > >> > > - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
If you can use the Win32 API you can use the Sqlite API. Just because they can be called from C programs does not make them "all to do with C". RB Smissaert wrote: Will have a look, but I was looking for a text geared towards VB. I take it the documentation that comes with SQLite is all to do with C. In fact I already have a wrapper that seems to work well, the one from TerraInformatica, but maybe there was more control if I could write my own. RBS -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:19 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite [EMAIL PROTECTED] said: Thanks. Would you know any VB source code that wraps all the possible declares in a class? Or do you know where to find the documentation to make all the possible declares in VB/VBA? RBS The SQLite documentation will give you everything you need to write the wrapper. The sqlite.h file in the source bundle would also be a great help. You may also be able to find a wrapper already written linked on the SQLite web site. Clay Dowling Yes. It's a regular windows DLL, so it will behave like all other Windows DLLs. Clay Dowling [EMAIL PROTECTED] said: Can I call the SQLite API (as in the dll SQLite.dll) directly from VB or do I need the wrapper? So, could it work from VB with declares as I use for the Windows API? RBS sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You should be able to call the Sqlite3 API directly. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] C++ SQLite
Will have a look, but I was looking for a text geared towards VB. I take it the documentation that comes with SQLite is all to do with C. In fact I already have a wrapper that seems to work well, the one from TerraInformatica, but maybe there was more control if I could write my own. RBS -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:19 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite [EMAIL PROTECTED] said: > Thanks. Would you know any VB source code that wraps all the possible > declares in a class? Or do you know where to find the documentation > to make all the possible declares in VB/VBA? > > RBS The SQLite documentation will give you everything you need to write the wrapper. The sqlite.h file in the source bundle would also be a great help. You may also be able to find a wrapper already written linked on the SQLite web site. Clay Dowling > > >> Yes. It's a regular windows DLL, so it will behave like all other >> Windows >> DLLs. >> >> Clay Dowling >> >> [EMAIL PROTECTED] said: >>> Can I call the SQLite API (as in the dll SQLite.dll) directly from >>> VB or do I need the wrapper? So, could it work from VB with declares >>> as I use for the Windows API? >>> >>> RBS >>> >>>> sebcity wrote: >>>>> How would one go about using c++ (Visual Studio.NET) to call and >>>>> display >>>>> SQLite tables. C++ wrappers? >>>> You should be able to call the Sqlite3 API directly. >>>> >>>> - >>>> To unsubscribe, send email to [EMAIL PROTECTED] >>>> - >>>> >>>> >>>> >>> >>> >>> >>> >>> - >>> To unsubscribe, send email to [EMAIL PROTECTED] >>> - >>> >>> >> >> >> -- >> Simple Content Management >> http://www.ceamus.com >> >> >> - >> To unsubscribe, send email to [EMAIL PROTECTED] >> - >> >> >> > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Yes. It's a regular windows DLL, so it will behave like all other Windows DLLs. Clay Dowling [EMAIL PROTECTED] said: > Can I call the SQLite API (as in the dll SQLite.dll) directly from > VB or do I need the wrapper? So, could it work from VB with declares > as I use for the Windows API? > > RBS > >> sebcity wrote: >>> How would one go about using c++ (Visual Studio.NET) to call and >>> display >>> SQLite tables. C++ wrappers? >> You should be able to call the Sqlite3 API directly. >> >> - >> To unsubscribe, send email to [EMAIL PROTECTED] >> - >> >> >> > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] C++ SQLite
After 30+ years, still waiting for management to learn one simple rule... Ah, but then they wouldn't need all of us "Consultants" :-) Fred > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 28, 2006 9:30 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] C++ SQLite > > > Remember the first rule of IT. "If you don't have time do do > it right, > you don't have time to do it twice". > > sebcity wrote: ... - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Can I call the SQLite API (as in the dll SQLite.dll) directly from VB or do I need the wrapper? So, could it work from VB with declares as I use for the Windows API? RBS > sebcity wrote: >> How would one go about using c++ (Visual Studio.NET) to call and display >> SQLite tables. C++ wrappers? > You should be able to call the Sqlite3 API directly. > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Remember the first rule of IT. "If you don't have time do do it right, you don't have time to do it twice". sebcity wrote: Time constraints Craig Morrison-2 wrote: sebcity wrote: Thanks, Could you supply an example? I'm not going to be as nice as everyone else, go here: http://www.sqlite.org/cvstrac/wiki Do some research and then come back instead of asking for handouts. We've all been where you are now, the difference is that we tried on our own and _then_ came here asking questions when we got stuck. Trying to do a little work on your own will do you a world of good. Clay Dowling wrote: sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You could just use the API directly. Myself, I've put a wrapper around it, but there's nothing saying that you have to. Clay -- CeaMuS http://www.ceamus.com Simple Content Management - To unsubscribe, send email to [EMAIL PROTECTED] - -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You should be able to call the Sqlite3 API directly. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
sebcity said: > > Thanks, Could you supply an example? > http://www.linuxjournal.com/article/7803 Clay -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
sebcity <[EMAIL PROTECTED]> was heard to say: > > Time constraints > Good point. I've got time constraints too. Could everyone else please start to solve all my problems right now too please? Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Time constraints Craig Morrison-2 wrote: > > sebcity wrote: >> Thanks, Could you supply an example? > > I'm not going to be as nice as everyone else, go here: > > http://www.sqlite.org/cvstrac/wiki > > Do some research and then come back instead of asking for handouts. > > We've all been where you are now, the difference is that we tried on our > own and _then_ came here asking questions when we got stuck. Trying to > do a little work on your own will do you a world of good. > >> >> Clay Dowling wrote: >>> sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? >>> You could just use the API directly. Myself, I've put a wrapper around >>> it, but there's nothing saying that you have to. >>> >>> Clay >>> -- >>> CeaMuS >>> http://www.ceamus.com >>> Simple Content Management >>> >>> - >>> To unsubscribe, send email to [EMAIL PROTECTED] >>> - >>> >>> >>> >> > > > > -- > Craig Morrison > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > http://pse.2cah.com >Controlling pseudoephedrine purchases. > > http://www.mtsprofessional.com/ >A Win32 email server that works for You. > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > -- View this message in context: http://www.nabble.com/C%2B%2B-SQLite-tf2717819.html#a7578545 Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Re:[sqlite] C++ SQLite
u have to search sqlite++. :) -- Linker M Lin [EMAIL PROTECTED] ※ ※※我思故我在※※ ※ - 原始邮件 发件人: sebcity <[EMAIL PROTECTED]> 收件人: sqlite-users@sqlite.org 已发送: 2006/11/28(周二), 下午7:52:07 主题: Re: [sqlite] C++ SQLite Thanks, Could you supply an example? Clay Dowling wrote: > > sebcity wrote: >> How would one go about using c++ (Visual Studio.NET) to call and display >> SQLite tables. C++ wrappers? > > You could just use the API directly. Myself, I've put a wrapper around > it, but there's nothing saying that you have to. > > Clay > -- > CeaMuS > http://www.ceamus.com > Simple Content Management > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > -- View this message in context: http://www.nabble.com/C%2B%2B-SQLite-tf2717819.html#a7577870 Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] - ___ 抢注雅虎免费邮箱-3.5G容量,20M附件! http://cn.mail.yahoo.com
Re: [sqlite] C++ SQLite
sebcity wrote: Thanks, Could you supply an example? I'm not going to be as nice as everyone else, go here: http://www.sqlite.org/cvstrac/wiki Do some research and then come back instead of asking for handouts. We've all been where you are now, the difference is that we tried on our own and _then_ came here asking questions when we got stuck. Trying to do a little work on your own will do you a world of good. Clay Dowling wrote: sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You could just use the API directly. Myself, I've put a wrapper around it, but there's nothing saying that you have to. Clay -- CeaMuS http://www.ceamus.com Simple Content Management - To unsubscribe, send email to [EMAIL PROTECTED] - -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Thanks, Could you supply an example? Clay Dowling wrote: > > sebcity wrote: >> How would one go about using c++ (Visual Studio.NET) to call and display >> SQLite tables. C++ wrappers? > > You could just use the API directly. Myself, I've put a wrapper around > it, but there's nothing saying that you have to. > > Clay > -- > CeaMuS > http://www.ceamus.com > Simple Content Management > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > -- View this message in context: http://www.nabble.com/C%2B%2B-SQLite-tf2717819.html#a7577870 Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
sebcity wrote: > How would one go about using c++ (Visual Studio.NET) to call and display > SQLite tables. C++ wrappers? You could just use the API directly. Myself, I've put a wrapper around it, but there's nothing saying that you have to. Clay -- CeaMuS http://www.ceamus.com Simple Content Management - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] C++ SQLite
How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? -- View this message in context: http://www.nabble.com/C%2B%2B-SQLite-tf2717819.html#a7577607 Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] -