Re: [sqlite] insert return -1

i resolved it by replace \n by \r\n thanks for all help On Mon, Dec 24, 2012 at 8:30 PM, Larry Brasfield wrote: > Live Happy wrote: > >> i tried to insert this text : >> >> BEGIN:VCARD\nVERSION:2.1\nN:;**okpl;;;\nFN:okpl\nTEL;CELL:** >>

Re: [sqlite] Multiple network connections

Am 25.12.2012 22:18, schrieb Çağlar Orhan: But every client has MS *.hta files and connecting to sqlite over ODBC driver with vbscript. What you rely on in this case, has nothing to do with the WebServer (IIS) ... meaning the WebServer is not used as a decoupling layer (over http). What you

Re: [sqlite] Multiple network connections

Çağlar Orhan Hi Larry, thank you for your explanatory answer. I have an idea now, but with my poor English am afraid i did understand wrong or incomplete :( I am going to try my network layout. We have an IIS as a server and clients have MS Win7 on their PCs. But usually we used IIS machine as

Re: [sqlite] Multiple network connections

Hi Larry, thank you for your explanatory answer. I have an idea now, but with my poor English am afraid i did understand wrong or incomplete :( I am going to try my network layout. We have an IIS as a server and clients have MS Win7 on their PCs. But usually we used IIS machine as a clasical

Re: [sqlite] cursor question about sqlite3

genliu777 wrote: > according to the forward-only iteration through sqlite table records, i wish > i could realize some kind of funtions like next(), prev(), move(), > getbookmark() and setbookmark(), to bi-directionally iterate through table.

Re: [sqlite] how to move around records in sqlite as the way as in CDaoRecordset of MFC??

On 25 Dec 2012, at 3:22pm, genliu777 wrote: > // sql query: "SELECT rowid FROM myTable WHERE rowid = rowiddd". If you already know that rowid = rowiddd then there's no point in doing the SELECT. You already know the answer. If you want to find the line before or

Re: [sqlite] how to move around records in sqlite as the way as in CDaoRecordset of MFC??

thanks, Simon Slavin-3! it is good idea to use " SELECT rowid FROM myTable WHERE rowid > *[current_rowid]* ORDER BY rowid LIMIT 1 " . but the key question is about the " current_rowid": how to get the value of rowid as the way as extracting other field value!! for example, ... ... int rowiddd

Re: [sqlite] how to move around records in sqlite as the way as in CDaoRecordset of MFC??

thanks for consideration!! your reply gives some kind of view of solution. but how to get bookmark and set bookmark of record in table when "cursor" moves to the marked record directly from some other place in the table? -- View this message in context:

[sqlite] cursor question about sqlite3

according to the forward-only iteration through sqlite table records, i wish i could realize some kind of funtions like next(), prev(), move(), getbookmark() and setbookmark(), to bi-directionally iterate through table. i searched through this forum of "cursor" question about sqlite. someone