I’m working on accessing sqlite3 from a process/program that is not able to
access sqlite3.a by using sockets through socat(1).
Mike
On Jun 22, 2014, at 9:47 AM, Adil Hasan wrote:
> Hello,
> I would like to add sqlite to a workflow. But, I cannot directly open the
>
I?m listening to the podcast now. Great episode and I?ve subscribed to their
podcast series.
As a side thought of what I?ve listened to so far? Is there a
page/reference/discussion about how the consortium was/is set up?
I am integrating SQLite into my Mac OS X application and like SQLite. I am
I was once told of an idea (decades ago) of versioning data within a table
where one column has a real/float value that is the version number. The data in
the table can be committed as necessary. If the data needs to be rolled back
the data can be rolled back/deleted to the table based on the
On Fri, 14 Jun 2013, Richard Hipp might have said:
> On Fri, Jun 14, 2013 at 9:10 AM, Vijay Khurdiya <
> vijay.khurd...@securetogether.com> wrote:
>
> > Please confirm below statement is TRUE when Sqlit3 configure in thread
> > safe mode. (I am checking for Serialized)
> >
> > "Multiple
I think Oracle (a long distant memory) has variables like @variable or
@@variable where you can do something like '@variable = select rowid from table
where field = 4' and then later do 'insert into othertable (field2)
value(@variable)’. Does this make sense? I’m wanting to in the shell select
I forgot I could use it inside the shell. Thanks.
Mike
> On Sep 11, 2016, at 16:58, Simon Slavin <slav...@bigfraud.org> wrote:
>
>
> On 11 Sep 2016, at 10:53pm, mikeegg1 <mikee...@mac.com> wrote:
>
>> Thanks. I thought not. I’m doing this from PERL on a Mac
Thanks. I thought not. I’m doing this from PERL on a Mac and don’t know if I
can fully access last_row_id(). :)
Mike
> On Sep 11, 2016, at 16:52, Simon Slavin <slav...@bigfraud.org> wrote:
>
>
> On 11 Sep 2016, at 10:48pm, mikeegg1 <mikee...@mac.com> wrote:
>
Thanks everyone. I was mis-equating REPLACE with UPDATE. I’ll change my code to
“INSERT or IGNORE” and add an UPDATE.
Mike
> On Sep 18, 2016, at 05:34, Keith Medcalf wrote:
>
>
> On Saturday, 17 September, 2016 21:35, mikeeggl asked:
>
>> In my DDL I have “integer
Happy Saturday.
In my DDL I have “integer primary key not null” on my tables. When I do the
first insert to these tables the rowid is assigned. The insert statement is a
“insert or replace into…” so I don’t have to deal with insertion errors.
However, I expected the rowid to not change when
I’m using the statement:
select count(*) from sqlite_master where type = 'table' and name = ‘$NAME’;
This statement works fine in the sqlite3 shell. This statement does not work in
my API.
Is there a PRAGMA I need to issue so I can check for table existence?
TIA
Mike
PERL code to check for
thon: cur.execute(, > values to bind>)
>> cur.execute("select count(*) from sqlite_master where type = 'table' and
>> name = ?;", (,))
>>
>>
>> -Original Message-
>> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
11 matches
Mail list logo