Changes between Version 11 and Version 12 of SQL/SQLite3


Ignore:
Timestamp:
May 2, 2013, 4:02:07 PM (8 years ago)
Author:
vadim.godunko
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • SQL/SQLite3

    v11 v12  
    1515== Driver features ==
    1616
    17 SQLite3 driver allows to obtain number of last inserted row through LAST_INSERT_ROWID pseudo-paramter of SQL_Query object.
     17SQLite3 driver allows to obtain number of last inserted row through LAST_INSERT_ROWID pseudo-paramter of SQL_Query object. This is especially useful to obtain value of automatically incremented primary key for new inserted record.
    1818
    1919{{{
     
    2323
    2424begin
     25   Query.Prepare
     26    (League.Strings.To_Universal_String
     27      ("CREATE TABLE test"
     28         & " (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"
     29         & " value CHARACTER VARYING NOT NULL)"));
     30   Query.Execute;
     31
    2532   Query.Prepare
    2633    (League.Strings.To_Universal_String