[sqlite] MyJSQLView Version 7.08 Released

MyJSQLView Version 7.08 Released The MyJSQLView project is pleased to release v7.08 to the public. The release marks a complete code review and cleanup. Updated libraries have also been included with this release along with the Table Field Profiler plugin. There have been many fixes in this

Re: [sqlite] Does sqlite3 have variables like Oracle?

You can also access that value within your Perl code, in a DBMS-agnostic fashion, with the appropriate DBI routine: http://search.cpan.org/dist/DBI/DBI.pm#last_insert_id -- Darren Duncan On 2016-09-11 2:59 PM, mikeegg1 wrote: I forgot I could use it inside the shell. Thanks. On Sep 11,

Re: [sqlite] Does sqlite3 have variables like Oracle?

I forgot I could use it inside the shell. Thanks. Mike > On Sep 11, 2016, at 16:58, Simon Slavin wrote: > > > On 11 Sep 2016, at 10:53pm, mikeegg1 wrote: > >> Thanks. I thought not. I’m doing this from PERL on a Mac and don’t know if I >> can fully

Re: [sqlite] Does sqlite3 have variables like Oracle?

On 11 Sep 2016, at 10:53pm, mikeegg1 wrote: > 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(). It's not a C function, it's a function you can use inside SQL commands. There shouldn't be a problem with it.

Re: [sqlite] Does sqlite3 have variables like Oracle?

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 wrote: > > > On 11 Sep 2016, at 10:48pm, mikeegg1 wrote: > >> I think Oracle (a long

Re: [sqlite] Does sqlite3 have variables like Oracle?

On 11 Sep 2016, at 10:48pm, mikeegg1 wrote: > 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) >

[sqlite] Does sqlite3 have variables like Oracle?

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

Re: [sqlite] Frequent database corruptions on Windows 10

On 9/10/2016 1:16 PM, Olivier Mascia wrote: Le 10 sept. 2016 à 11:21, Alexander Täschner a écrit : since upgrading to Windows 10 I have trouble with several different C# programs I wrote, that uses System.Data.SQLite to access sqlite database files ... The

Re: [sqlite] sqlite - Delete large table in sqlite

On Sat, 10 Sep 2016 13:31:51 +0100 Simon Slavin wrote: > You do it after opening a connection to the database. Probably the > first thing you do after sqlite3_open(). Thanks! -- 73 de HA5OGL Op.: Levente