On Mon, Apr 9, 2012 at 4:16 AM, Pavel Ivanov wrote:
> If you read the link Simon gave you'll see that sqlite_sequence have
> records only for tables with AUTOINCREMENT ROWID. And that record
> doesn't necessarily contains value from some row that really existed
> at any point of time. In other wo
> i just (experimentally)
> implemented a lookup on sqlite_sequence if the hint is provided, else
> falling back to sqlite3_last_insert_id(). It "works for me", but if it's a
> potential portability problem then i'll remove it.
If you read the link Simon gave you'll see that sqlite_sequence have
r
On Mon, Apr 9, 2012 at 3:25 AM, Simon Slavin wrote:
> The C function sqlite3_last_insert_id(), and the SQLite wrapper around it
> last_insert_rowid() are as good as it gets. You do have to be a little
> careful if you have a TRIGGER on an INSERT which does another INSERT. If
> you use TRIGGERs
On Sun, Apr 8, 2012 at 9:25 PM, Simon Slavin wrote:
> On 9 Apr 2012, at 2:14am, Stephan Beal wrote:
>
>> Is it reliable/portable/well-defined to use (read-only) the sqlite_sequence
>> table to find the last insertion ID for a given table? i know about
>> sqlite3_last_insert_id(), but i'm wonderin
On 9 Apr 2012, at 2:14am, Stephan Beal wrote:
> Is it reliable/portable/well-defined to use (read-only) the sqlite_sequence
> table to find the last insertion ID for a given table? i know about
> sqlite3_last_insert_id(), but i'm wondering if reading the sqlite_sequence
> table directly might be
Hi, all,
Is it reliable/portable/well-defined to use (read-only) the sqlite_sequence
table to find the last insertion ID for a given table? i know about
sqlite3_last_insert_id(), but i'm wondering if reading the sqlite_sequence
table directly might be safer vis-a-vis triggers which perform an inse
Tcl-way is
package require sqlite3
The problem was fired in some old SQLite versions but was fixed before
previous release.
2012/4/8 Black, Michael (IS)
> Don't you need to load the sqlite3 library first for tclsh?
>
>
>
> load ./libtclsqlite3.so Sqlite3
>
> Or something like that?
>
>
>
>
>
>
On April 8, Marco wrote:
OpenConnection(TMP_ConnectionString, OBJ_Connection)
sql= "UPDATE ANG_Operatori Set NomeOperatore = 'Amministratore',UserID =
'admin',ParolaChiave = 'prova',DataUltimoAccesso = '08/04/2012
15:04:00',Supervisore = 1,ID_Dentista = 1 where ID_ANG_Operatore = 1"
Execute("
Hi Simon ,
Thank you for your fast reply:
SO: Windows 7.
VB.net 2010
//
OpenConnection(TMP_ConnectionString, OBJ_Connection)
sql= "UPDATE ANG_Operatori Set NomeOperatore = 'Amministratore',UserID =
'admin',ParolaChiave = 'prova',DataUltimoAccesso = '08/04/2012
15:04:00',Supervisore = 1,ID_De
On 8 Apr 2012, at 2:32pm, marco1 wrote:
> Hi , I don't know how is possible save record with Sqlite.
>
> I was try i different way:
>
> 1) With vb.net updatecommand (The database file is locked)
> 2) With "Insert Into" (The database file is locked)
> 3) With transaction Begin . Commit (T
Hi , I don't know how is possible save record with Sqlite.
I was try i different way:
1) With vb.net updatecommand (The database file is locked)
2) With "Insert Into" (The database file is locked)
3) With transaction Begin . Commit (The database file is locked)
This message is false becau
Don't you need to load the sqlite3 library first for tclsh?
load ./libtclsqlite3.so Sqlite3
Or something like that?
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
__
On Apr 8, 2012, at 12:25 AM, Josh Gibbs wrote:
> SQLite: INSERT OR IGNORE INTO test_table VALUES('prop','val');
> Postgres: INSERT INTO test_table SELECT 'prop','val' WHERE NOT EXISTS (SELECT
> 1 FROM test_table WHERE property='prop');
My 2¢…
The first variant, insert or ignore, is arguably mo
13 matches
Mail list logo
