[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

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

-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/In

[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,

[sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?

-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

[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

[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

[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

[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

[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

[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

[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.

[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()) > { > ...

[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

[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;

[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

[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

[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

[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

[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

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

: 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

[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

[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

[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)

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

[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

RE: [sqlite] C++ SQLite

t; 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

RE: [sqlite] C++ SQLite

-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

Re: [sqlite] C++ SQLite

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

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

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

Re: [sqlite] C++ SQLite

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 t

RE: [sqlite] C++ 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 > d

RE: [sqlite] C++ SQLite

age- > 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

RE: [sqlite] C++ SQLite

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&

Re: [sqlite] C++ SQLite

rg 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 ever

RE: [sqlite] C++ SQLite

-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

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? > >

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? >

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:

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

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

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

[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

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

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

[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.