Re: [sqlite] Last record

The only way is to make a query for getting the number of records and in the second query I have to count the number of records retrieved to know if it is the last one. Thank you for the quick answer. - Kenavo https://md5finder.blogspot.com/ (Never be pleased, always improve) -- S

[sqlite] Last record

A short question : how could I know if I am reading the last record with sqlite (sqlite3_step)? sqlite3_step only returns SQLITE_ROW. Is there a function for that case which returns SQLITE_DONE? A function which is one record in advance from sqlite3_step. Thank every one - Kenavo

Re: [sqlite] SQLITE and the memory

The answer: I remember : I have 256 databases. I have an array of 256 columns into which I store the number of record created. When I insert a record into a table, the corresponding entry into this array is incremented by one. When this element is equal to 1000 I commit the transaction. Not all th

Re: [sqlite] SQLITE and the memory

I use the windows task manager to see how the memory is used Opening the 256 tables : sqlite3_open_v2(_lpszTbl,&hSqlite[__iTableNumber],SQLITE_OPEN_READWRITE|SQLITE_OPEN_FULLMUTEX,NULL); - Kenavo https://md5finder.blogspot.com/ (Never be pleased, always improve) -- Sent from: h

[sqlite] SQLITE and the memory

ld appreciate some help. Thank You Philippe RIO - Kenavo https://md5finder.blogspot.com/ (Never be pleased, always improve) -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglis