[sqlite] IS Visual Studio Design Time support provided by system.data.sqlite.org?

Hi All, I just installed the set up downloaded from http://system.data.sqlite.org, and selected the Full option while installation. The design support for Visual Studio was, however, not added to the VS 2010 edition installed in my computer by the set up program. Am I required to take any

Re: [sqlite] IS Visual Studio Design Time support provided by system.data.sqlite.org?

Well, well. I removed the 64-bit installation, and installed the 32-bit version instead. And, voila, the design-time support option got added to VS !! -Dinesh From: Dinesh Bajaj dinesh.ba...@ymail.com To: sqlite-users@sqlite.org sqlite-users@sqlite.org Sent:

[sqlite] copy table to another db file

I have two db files: sqlite3 *db1; sqlite3 *db2; rc1 = sqlite3_open(myfile1, db1); rc2 = sqlite3_open(myfile2, db2); I want to copy db1.table1 to db2 file, but I don't know how to do? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] don't understand what query returns...

Thanks guys! it helps a lot. The count + group commands work fine only without the * though. If you don't mind, I'd have one further question. I read the query results named output with Python. Why is it a list of tuples?? It's not very handy... print output [(12.2817, 12.2817), (0, 0), (8.52,

Re: [sqlite] copy table to another db file

On 17-05-2012 11:04, YAN HONG YE wrote: I have two db files: sqlite3 *db1; sqlite3 *db2; rc1 = sqlite3_open(myfile1, db1); rc2 = sqlite3_open(myfile2, db2); I want to copy db1.table1 to db2 file, but I don't know how to do? sqlite myfile1 sqlite attach database 'myfile2' as db2; sqlite

[sqlite] donwload is linkted to a old version

Hallo, the link of the current version on http://sqlite.org/download.html has the old version 3.7.10 as target and not 3.7.12 . best regards Jens -- -- Jens Pustelnik Petersstrasse 105 47249 Duisburg Email : j...@pustelnik.de

Re: [sqlite] Accented chars in Android embeded Sqlite.

Hello Yahoo, Another possible solution seeing you're on the Android platform and writing in Java is to use a less high tech solution and store an additional column with a copy of the text you're searching where you've stripped the accents out and use that for the search instead. It would use

Re: [sqlite] don't understand what query returns...

If you don't mind, I'd have one further question. I read the query results named output with Python. Why is it a list of tuples?? It's not very handy... print output [(12.2817, 12.2817), (0, 0), (8.52, 8.52)] It seems to be a list of tuples as far as I know Python. That is correct.

Re: [sqlite] copy table to another db file

Luuk wrote: On 17-05-2012 11:04, YAN HONG YE wrote: I have two db files: sqlite3 *db1; sqlite3 *db2; rc1 = sqlite3_open(myfile1, db1); rc2 = sqlite3_open(myfile2, db2); I want to copy db1.table1 to db2 file, but I don't know how to do? sqlite myfile1 sqlite attach database 'myfile2'

[sqlite] sqlite Commit C API

Hi all, Am using sqlite database on my ARM processor based Embedded system . Whenever power failures or due to uneven shutdown of device, my database is being corrupted which leading to data lost. Am using C API interface for accessing database. Is there any C API that I can use to commit my

Re: [sqlite] sqlite Commit C API

On Thu, May 17, 2012 at 11:18 AM, Rajesh Kumar thisiz...@gmail.com wrote: Hi all, Am using sqlite database on my ARM processor based Embedded system . Whenever power failures or due to uneven shutdown of device, my database is being corrupted which leading to data lost. That should

Re: [sqlite] sqlite Commit C API

On 17 May 2012, at 4:18pm, Rajesh Kumar thisiz...@gmail.com wrote: Am using sqlite database on my ARM processor based Embedded system . Whenever power failures or due to uneven shutdown of device, my database is being corrupted which leading to data lost. Am using C API interface for

Re: [sqlite] sqlite Commit C API

On Thu, May 17, 2012 at 11:22:44AM -0400, Richard Hipp scratched on the wall: On Thu, May 17, 2012 at 11:18 AM, Rajesh Kumar thisiz...@gmail.com wrote: Hi all, Am using sqlite database on my ARM processor based Embedded system . Whenever power failures or due to uneven shutdown of

Re: [sqlite] sqlite Commit C API

Hi Richard, Thanks for the reply. fsync() is related to system call, which is working fine. But I am looking for a C API that can do the commit thing, which is same as commit on command promt. On Thu, May 17, 2012 at 8:52 PM, Richard Hipp d...@sqlite.org wrote: On Thu, May 17, 2012 at

Re: [sqlite] sqlite Commit C API

On 17 May 2012, at 4:28pm, Rajesh Kumar thisiz...@gmail.com wrote: Thanks for the reply. fsync() is related to system call, which is working fine. But I am looking for a C API that can do the commit thing, which is same as commit on command promt. The COMMIT; on a command prompt does the

Re: [sqlite] sqlite Commit C API

No am not using any PRAGMAs. I just cross compiled sqlite source to ARM architecture. Can't I forcefully do commit on my transaction On Thu, May 17, 2012 at 8:55 PM, Simon Slavin slav...@bigfraud.org wrote: On 17 May 2012, at 4:18pm, Rajesh Kumar thisiz...@gmail.com wrote: Am using

Re: [sqlite] copy table to another db file

On Thu, May 17, 2012 at 11:36:53AM +0200, Luuk scratched on the wall: On 17-05-2012 11:04, YAN HONG YE wrote: I have two db files: sqlite3 *db1; sqlite3 *db2; rc1 = sqlite3_open(myfile1, db1); rc2 = sqlite3_open(myfile2, db2); I want to copy db1.table1 to db2 file, but I don't

Re: [sqlite] sqlite Commit C API

So if I use _exec() after sqlit3_exec() API, what ever the I did on database will be saved, right?? On Thu, May 17, 2012 at 9:03 PM, Simon Slavin slav...@bigfraud.org wrote: On 17 May 2012, at 4:28pm, Rajesh Kumar thisiz...@gmail.com wrote: Thanks for the reply. fsync() is related to

Re: [sqlite] sqlite Commit C API

On 17 May 2012, at 4:34pm, Rajesh Kumar thisiz...@gmail.com wrote: No am not using any PRAGMAs. I just cross compiled sqlite source to ARM architecture. Can't I forcefully do commit on my transaction If you are correctly using _open() and _close(), and haven't disabled synchrony with

Re: [sqlite] sqlite Commit C API

On Thu, May 17, 2012 at 08:58:39PM +0530, Rajesh Kumar scratched on the wall: Hi Richard, Thanks for the reply. fsync() is related to system call, which is working fine. I believe you're missing Richard's point. I'm sure fsync() is returning a success error code. That doesn't mean

Re: [sqlite] sqlite Commit C API

On 17 May 2012, at 4:49pm, Jay A. Kreibich j...@kreibi.ch wrote: I wouldn't be all that shocked to find out an embedded system has an fsync() call that looks like this: int fsync( int fd ) { return 0; } We are best software circle ! Our programmers write many functions a day ! Our

Re: [sqlite] sqlite Commit C API

int fsync( int fd ) { return 0; } fsync will expect an Integer pointer right. But sqlite pointer is of type sqlite3*. So how can fsync works on sqlite. What should I pass to fsync??? On Thu, May 17, 2012 at 9:19 PM, Jay A. Kreibich j...@kreibi.ch wrote: int fsync( int fd ) { return 0; }

Re: [sqlite] sqlite Commit C API

On 17 May 2012, at 5:04pm, Rajesh Kumar thisiz...@gmail.com wrote: int fsync( int fd ) { return 0; } fsync will expect an Integer pointer right. But sqlite pointer is of type sqlite3*. So how can fsync works on sqlite. What should I pass to fsync??? Sorry Rajesh. It was a programmer's

Re: [sqlite] sqlite Commit C API

Funny! But, very inefficient. Suggest: #define fsync(x) Marc -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, May 17, 2012 11:52 AM To: j...@kreibi.ch; General Discussion of SQLite Database