All expert Users and Developers:
I am looking for sqlite based opensource project with web inertaface for
college student, please let me know. appreciated.
___
sqlite-users mailing list
sqlite-users@sqlite.org
tmt *pStmt;
sqlite3(pDB, "SELECT last_insert_rowid()", -1, , 0);
rowid = sqlite3_step(pStmt);
On Mon, Feb 8, 2010 at 2:36 PM, Kees Nuyt <k.n...@zonnet.nl> wrote:
> On Mon, 8 Feb 2010 11:44:39 -0500, Vasanta
> <vtan...@gmail.com> wrote:
>
> > I tried to use th
I tried to use this function call
"sqlite3_last_insert_rowid()<http://www.sqlite.org/c3ref/last_insert_rowid.html>"
calling from C language function, but it always returns zero, any idea?. I
have valid DB handle.
On Sat, Feb 6, 2010 at 9:25 AM, Vasanta <vtan...@gmail.com
Can I use this function call in C code to return last rowid to be inserted?.
On Sat, Feb 6, 2010 at 9:25 AM, Vasanta <vtan...@gmail.com> wrote:
> I found this C function call, this solved my problem,
> sqlite3_last_insert_rowid()<http://www.sqlite.org/c3ref/last_insert_rowid.h
; Am 05.02.2010 22:33, schrieb Vasanta:
> > Kittayya:
> >
> > My issue is, I already have imported table in the Database, there alreay
> > around 1000 records in that table where ROWID is from 1 to 1000, now
> system
> > generates new events, where ROWID again starts
ify a table. Make sure to
> -- wrap the two in a transaction
> COMMIT
>
> Now, wasn't that easy?
>
> Next step. Please read the docs and do some sql tutorials. You will
> really benefit.
>
>
> On Fri, Feb 5, 2010 at 2:54 PM, Vasanta <vtan...@gmail.com> wrote
+1
> from EVENTLOG_TBL;", use sqlite_step() to run this query, and bind the
> ROWID
> returned here into your insert statement and run that.
>
> You can read more on SQLite's ROWID usage at
> http://www.sqlite.org/search?q=rowid
>
> HTH.
> -Shane
>
>
>
>
&
m EVENTLOG_TBL";
On Fri, Feb 5, 2010 at 3:05 PM, Vasanta <vtan...@gmail.com> wrote:
> Thanks jay.
>
> Can I combine like this:
>
> "INSERT INTO trends(UnitID,HeureTrends,DateTrends) VALUES(?,?,?);SELECT
> max(ROWID) FROM table-name";
>
> or
>
PM, Jay A. Kreibich <j...@kreibi.ch> wrote:
> On Fri, Feb 05, 2010 at 02:28:33PM -0500, Vasanta scratched on the wall:
> > command "SELECT rowid from table-name;" gives all rows from 1 to 100
> for
> > total 100 rows, any command to get last rowid?. I need in
I couldn't find, looklike lot of expert users here, throw me command quickly
On Fri, Feb 5, 2010 at 2:34 PM, P Kishor <punk.k...@gmail.com> wrote:
> On Fri, Feb 5, 2010 at 1:28 PM, Vasanta <vtan...@gmail.com> wrote:
> > command "SELECT rowid from table-name;"
command "SELECT rowid from table-name;" gives all rows from 1 to 100 for
total 100 rows, any command to get last rowid?. I need insert from last
rowid onwards (if table already 100 records, need to insert from 101
onwards)
___
sqlite-users mailing list
0, at 4:00pm, Vasanta wrote:
>
> > Thanks Simon. actually I have one sql file contains all tables info
> > (system.sql, then system.db file gets created using this command "sqlite3
> > system.sb < system.sql), then lua script runs on this database file
> using
> &
ig_ascii), then this
problem comes. I have those files, can I attach here?.
On Sat, Jan 30, 2010 at 8:45 AM, Simon Slavin <slav...@bigfraud.org> wrote:
>
> On 29 Jan 2010, at 8:52pm, Vasanta wrote:
>
> > when Database tries to create tables, getting the below error:
> > "table i
when Database tries to create tables, getting the below error:
"table insert failed for eventLog" any idea what is the reason, also I have
these errors when I run manually, I gets these:
SQL error near line 2: table dbUpdateRegisterTbl already exists
SQL error near line 17: table sqliteLock
14 matches
Mail list logo