Re: [sqlite] Question about binding

; On Tue, Mar 23, 2010 at 3:48 PM, Vance E. Neff <ven...@intouchmi.com> 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 c

Re: [sqlite] Question about binding

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 <ven...@intouchmi.com> wrote: >> >> >>> UPDATE table1 set (?, ?, ?) WHERE col1=? and c

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

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

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 <ven...@intouchmi.com&

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 <ven...@intouchmi.com> wrote: > > >>Just to be straight, I would use the Query: >>SELECT last_insert_rowid() AS

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" <ven...@intouchmi.com> wrote >in message news:4982fd7c.2090...@intouchmi.com > > >>When I INS

Re: [sqlite] Index keywords

ite] 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 <dwmaill...@gmail.com> >wrote: > > >>Could this be what you're looking for? >> >>On Thu, Jan 29, 2009 at 11:04 AM, V

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: &quo

Re: [sqlite] Index keywords

e's the link: http://www.sqlite.org/lang.html > >On Thu, Jan 29, 2009 at 11:09 AM, Daniel Watrous <dwmaill...@gmail.com> wrote: > > >>Could this be what you're looking for? >> >>On Thu, Jan 29, 2009 at 11:04 AM, Vance E. Neff <ven...@intouchmi.com> wrote: &

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 searched and c

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