Re: [sqlite] Variable Declaration

2019-01-20 Thread Jake Thaw
There does exist an experimental branch which introduces the concept of shell variables. https://www.sqlite.org/src/timeline?r=shell-bindings The check-in comment describes the usage: "Add the ability to use bind parameters in the CLI. The new ".set KEY=VALUE" dot-command works to set bindings.

Re: [sqlite] Variable Declaration

2019-01-20 Thread James K. Lowden
On Sat, 19 Jan 2019 12:01:34 -0700 "Keith Medcalf" wrote: > Microsoft took the OS/2 3.0 Beta 2 code and generated their OS/2 New > Technology. The "New Technology" part was considered to be a bit to > long, so Microsoft shortened it to NT, replaced the Presentation > Manager with with Windows

Re: [sqlite] Variable Declaration

2019-01-19 Thread Andrew.Goth
I'm jumping into the middle of the conversation, possibly without seeing the beginning, but from what I've seen so far, it seems to me that the key is recognizing there are many tools in a programmer's toolbox. Each tool covers a certain area of functionality really well, then there are areas

Re: [sqlite] Variable Declaration

2019-01-19 Thread Stephen Chrzanowski
But then in BASH, for example, the temp table would only last for the life of the initial connection, so you'd have to throw everything in one execution. This goes along the lines of just setting a variable. A BIG time question comes to scope of the life of the variable. Does it live for the

Re: [sqlite] Variable Declaration

2019-01-19 Thread Scott Robison
On Sat, Jan 19, 2019, 6:53 AM Simon Slavin > On 19 Jan 2019, at 4:49am, Stephen Chrzanowski wrote: > > > I know about the bindings. I don't know about all languages supporting it. > > Bindings are part of the SQLite API. Any language which can make SQLite calls should be supporting binding. >

Re: [sqlite] Variable Declaration

2019-01-19 Thread Keith Medcalf
arts desire. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Luuk >Sent: Saturday, 19 January, 2019 06:

Re: [sqlite] Variable Declaration

2019-01-19 Thread Roger Schlueter
before -> because to help those for whom English is not their first language. Cheers. On 1/19/2019 5:53, Simon Slavin wrote: On 19 Jan 2019, at 4:49am, Stephen Chrzanowski wrote: I know about the bindings. I don't know about all languages supporting it. Bindings are part of the SQLite

Re: [sqlite] Variable Declaration

2019-01-19 Thread Simon Slavin
On 19 Jan 2019, at 4:49am, Stephen Chrzanowski wrote: > I know about the bindings. I don't know about all languages supporting it. Bindings are part of the SQLite API. Any language which can make SQLite calls should be supporting binding. Using binding means you can have the variables you

Re: [sqlite] Variable Declaration

2019-01-19 Thread Luuk
On 19-1-2019 14:49, Luuk wrote: This question is not about: 'parameter binding'! It's about 'variable decalaration'... oops 'variable declaration' ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Variable Declaration

2019-01-19 Thread Luuk
On 19-1-2019 14:23, Jesse Rittner wrote: What language do you want to use? Parameter binding is a feature of the SQLite C API. So pretty much any language with a C FFI will suffice. There's a list on Wikipedia, not sure how authoritative it is.

Re: [sqlite] Variable Declaration

2019-01-19 Thread Jesse Rittner
What language do you want to use? Parameter binding is a feature of the SQLite C API. So pretty much any language with a C FFI will suffice. There's a list on Wikipedia, not sure how authoritative it is. https://en.wikipedia.org/wiki/SQLite#Programming_language_support (Note: When it says they

Re: [sqlite] Variable Declaration

2019-01-18 Thread Stephen Chrzanowski
I know about the bindings. I don't know about all languages supporting it. On Fri, Jan 18, 2019 at 11:26 PM Simon Slavin wrote: > On 19 Jan 2019, at 3:57am, Stephen Chrzanowski > wrote: > > > I was going to have three variable set with > > three different strings I could just copy/paste to

Re: [sqlite] Variable Declaration

2019-01-18 Thread Simon Slavin
On 19 Jan 2019, at 3:57am, Stephen Chrzanowski wrote: > I was going to have three variable set with > three different strings I could just copy/paste to generate that > comparative list. You know SQLite does binding, right ? You don't have to construct your command like command$ = "INSERT

Re: [sqlite] Variable Declaration

2019-01-18 Thread Stephen Chrzanowski
pated traffic volume. > > > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Stephen Chrzanowski > >Sent: Friday, 18 January, 2019 18:52 > >To: General Discussion of SQLite Database > >

Re: [sqlite] Variable Declaration

2019-01-18 Thread Keith Medcalf
anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Stephen Chrzanowski >Sent: Friday, 18 January, 2019 18:52 >To: General Discussion of SQLite Database >Subject: [sqlite] Variable Declara

[sqlite] Variable Declaration

2019-01-18 Thread Stephen Chrzanowski
Tonight, I wanted to write up a small database to keep tabs on certain things I've done in a game, and show me new tasks I can do based on what I've completed. I have a full list of items, and what pairs of items I need to poses to get the next thing, but, getting the data into the DB is tedious.