Re: [sqlite] Question about binding

; On Tue, Mar 23, 2010 at 3:48 PM, Vance E. Neff wrote: >> Thanks to all those who responded! It was quite educational. >> I'm using the zentus java jdbc wrapper. It seems to only support an >> index # for the binding index so I'm stuck with being careful as to how >&g

Re: [sqlite] Question about binding

e holders or is this a standard SQL construct? Vance D. Richard Hipp wrote: > On Mar 19, 2010, at 3:29 PM, David Bicking wrote: > >> >> --- On Fri, 3/19/10, Vance E. Neff wrote: >> >> >>> UPDATE table1 set (?, ?, ?) WHERE col1=? and col2=?; >>>

[sqlite] Question about binding

First of all, I apologize for hijacking the thread! I did not intend to, I just screwed up! Second: Question about binding: I know how to prepare an INSERT state, for example: INSERT into table1 values (?, ?, ?); and in the wrapper I am using I can specify the index # (1, 2 or 3) of the column

Re: [sqlite] R*Tree and sqlite3_last_insert_rowid() API - possible bug?

Question about binding: I know how to prepare an INSERT state, for example: INSERT into table1 values (?, ?, ?); and in the wrapper I am using I can specify the index # (1, 2 or 3) of the column and the value in order to set the values. The question is: How to do this with an update statement?

Re: [sqlite] state of wrappers

I am also interested as to which Java JDBC wrappers are good. I have used the zentus wrapper for a very basic application and it worked OK. I could not get it to register as a desktop database application in Netbeans (6.5); but, that wasn't a problem for that simple application. But, I am ab

Re: [sqlite] Installing SQLite

If there was a zip file that included an open source compiler and linker and a well commented makefile along with SQLite's source code so that anyone (at least under Windows) can generate the version SQLite dll and command shell that they want without having to search for tools, I think more pe

Re: [sqlite] Index keywords

Thanks Puneet, Yes, it does seem to work. I just finished testing that. I'm determining the new index value for an autoincrement primary key to that I can refer to it via other tables. Vance P Kishor wrote: >On Mon, Feb 9, 2009 at 9:44 AM, Vance E. Neff wrote: > >

Re: [sqlite] Index keywords

Can I do the select last_insert_rowid(); to determine the new index value After the COMMIT command? Vance Igor Tandetnik wrote: >Vance E. Neff wrote: > > >>Just to be straight, I would use the Query: >>SELECT last_insert_rowid() AS TheNewKeyValue FROM TableX >&

Re: [sqlite] Index keywords

Thank you Igor! Just to be straight, I would use the Query: SELECT last_insert_rowid() AS TheNewKeyValue FROM TableX Vance Igor Tandetnik wrote: >"Vance E. Neff" wrote >in message news:4982fd7c.2090...@intouchmi.com > > >>When I INSERT a new row with INTEG

Re: [sqlite] Index keywords

: Re: [sqlite] Index keywords > >oops, sorry, here's the link: http://www.sqlite.org/lang.html > >On Thu, Jan 29, 2009 at 11:09 AM, Daniel Watrous >wrote: > > >>Could this be what you're looking for? >> >>On Thu, Jan 29, 2009 at 11:04 AM,

Re: [sqlite] Index keywords

Hi Frank, I'm looking for their meanings and details. Vance Frank Juestel wrote: >Hi Vance, > >Here we go with a list of SQLite keywords: > >http://www.sqlite.org/lang_keywords.html > >Best regards >Franky > >- Ursprüngliche Nachricht - >Von: &qu

Re: [sqlite] Index keywords

sorry, here's the link: http://www.sqlite.org/lang.html > >On Thu, Jan 29, 2009 at 11:09 AM, Daniel Watrous wrote: > > >>Could this be what you're looking for? >> >>On Thu, Jan 29, 2009 at 11:04 AM, Vance E. Neff wrote: >> >> >>>I hav

Re: [sqlite] Index keywords

I have seen that list of keywords, but I'm looking for a description of what they mean. In particular those associated with index definitions. Vance D. Richard Hipp wrote: >On Jan 29, 2009, at 9:38 AM, Vance E. Neff wrote: > > > >>Hi, >> >>I've sear

[sqlite] Index keywords

Hi, I've searched and can not find where the keywords like PRIMARY, UNIQUE, etc. in the Documentation. Please point me to the correct section. Also, if I use autoincrement, how do I retrieve the new index value for use in other tables? Again a doc. pointer would be good. Thanks! Vance __

[sqlite] commit causes error - why?

I'm having trouble on the "COMMIT TRANSACTION" Query. I seem, for some reason, to be violating a SQLite rule. This is from a language called RUN BASIC. Here is the test program, note that "" translates to a single " and the print statements are just for this demo: [code] CLS PRINT "Start"