RE: [sqlite] converting a sqlite table to dbf

Kind'a like chucking your Pentium 5 and going back to scratching on the cave wall with a rock, Eh? I'd export the tables to a CVS files using something like SQLiteAdmin.exe. Open the CVS files with Excel and save the resulting spreadsheets as .DBF files (My Excel has a choice of DBASE II through

Re: [sqlite] sqlite shared-cache mode usage

Can you - DRH or someone else provide some more background information on why locking dosen't work on NFS mounted file systems. If its a known issue then is there an SQLite compile time option that would remove locking - i couldn't find one. When I got stuck with this problem I had to remove all

Re: [sqlite] sqlite shared-cache mode usage

Jay Sprenkle wrote: The problem is that they have to work on broken operating systems. I don't know of another way to patch around the problem. Do you? nope. If it breaks because of something you did, then YOU are the bum. If it's broken because of the operating system THEY are the bums. H

[sqlite] converting a sqlite table to dbf

is there any straightforward way for converting a SQLite table to dbf format? -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/ Open Source Geospatial Foundation https://edu.osgeo.org/ -

Re: [sqlite] sqlite shared-cache mode usage

The problem is that they have to work on broken operating systems. I don't know of another way to patch around the problem. Do you? nope. If it breaks because of something you did, then YOU are the bum. If it's broken because of the operating system THEY are the bums. ---

Re: [sqlite] sqlite shared-cache mode usage

"Jay Sprenkle" <[EMAIL PROTECTED]> wrote: > On 8/28/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Let me emphasize that everything in the previous paragraph is > > hearsay and supposition and could be wildly incorrect. > > Thanks Dr.H. > > I hope it's not true. If it's true It really seems

Re: [sqlite] sqlite shared-cache mode usage

On 8/28/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Let me emphasize that everything in the previous paragraph is hearsay and supposition and could be wildly incorrect. Thanks Dr.H. I hope it's not true. If it's true It really seems a poor decision that will come back to haunt them later.

Re: [sqlite] Performance Question

Kurt Welgehausen <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: > >> Saying NOT NULL on a PRIMARY KEY is redundant, by the way. >> -- >> D. Richard Hipp <[EMAIL PROTECTED]> > > **kaw<~/tdpsa>$ sqlite3 > Loading resources from /home/kaw/.sqliterc > SQLite version 3.3.7 > Enter ".help" for

Re: [sqlite] Performance Question

[EMAIL PROTECTED] wrote: > Saying NOT NULL on a PRIMARY KEY is redundant, by the way. > -- > D. Richard Hipp <[EMAIL PROTECTED]> **kaw<~/tdpsa>$ sqlite3 Loading resources from /home/kaw/.sqliterc SQLite version 3.3.7 Enter ".help" for instructions sqlite> .nullvalue '<>' sqlite> create table t

Re: [sqlite] sqlite shared-cache mode usage

"Jay Sprenkle" <[EMAIL PROTECTED]> wrote: > Good morning all, > > I'm in the design stage of a project and had a question about sqlite > shared-cache mode. > The new version of firefox will use mozStorage, which is based on > sqlite using shared-cache mode. I want other programs to be able > read/

Re: [sqlite] Performance Question

"Slater, Chad" <[EMAIL PROTECTED]> wrote: > Hello, > > Consider the following lookup table definition: > > CREATE TABLE foobar ( > id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, > table1_id INTEGER NOT NULL REFERENCES table1, > table2_id INTEGER NOT NULL REFERENCES table2 > ); > > Th

[sqlite] Performance Question

Hello, Consider the following lookup table definition: CREATE TABLE foobar ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, table1_id INTEGER NOT NULL REFERENCES table1, table2_id INTEGER NOT NULL REFERENCES table2 ); The id primary key column is not necessary for anything in my appl

Re: [sqlite] Why I can't connect CVS repository?

[EMAIL PROTECTED] wrote: > Where else can I get the sqlite version 3.3.5(and the version should > support to be compiled under linux)? Can't help with your CVS problem, but you should find the source you want at this link - http://www.sqlite.org/sqlite-3.3.5.tar.gz Martin --

RE: [sqlite] Re: R: Re: [sqlite] How to compile sqlite3 C sample code

Hi, How about downloading the sample code from www.apress.com http://www.apress.com/book/supplementDownload.html?bID=10130&sID=3537 Nice book, try getting it. Kind regards, Lodewijk -Original Message- From: Tikky [mailto:[EMAIL PROTECTED] Sent: Monday, August 28, 2006 2:18 AM To: sql

[sqlite] Why I can't connect CVS repository?

Hi, In order to download the sqlite3.3.5, I installed wincvs client and configure the preferences according to the instruction. But when logging in, after I input the passward(anonymous), connection failed and showed something like "the server refused connection actively"... What's wrong? Where

RE: [sqlite] "Invalid or corrupt file" when building .lib file for version 3.3.7 dll

Thanks, Martin. That worked. Rob Richardson RAD-CON INC. -Original Message- From: Martin Jenkins [mailto:[EMAIL PROTECTED] Sent: Friday, August 25, 2006 5:21 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] "Invalid or corrupt file" when building .lib file for version 3.3.7 dll Rob

Re: [sqlite] how to create database in sqlite prompt

On 8/28/06, Tikky <[EMAIL PROTECTED]> wrote: Hi, unable to create database in sqlite prompt. Can U provide any specific command. You don't create a database at the sqlite prompt. You create it at your OS prompt, and then you create your tables at the sqlite prompt. % sqlite3 mydb .. sqlite3>

Re: [sqlite] how to create database in sqlite prompt

Tikky wrote: Hi, unable to create database in sqlite prompt. Can U provide any specific command. See http://www.sqlite.org/sqlite.html Martin - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Connect to SQLite Through C Program

Tikky wrote: Hi , I am struggling to connect SQLite database through C program. I got some code from the SQLite.org, when ever i tried to compile that c code it showing error like " Unable to include sqlite.h file". Please refer me solution. This is an FAQ: sqlite.h and sqlite3.h are generated

[sqlite] how to create database in sqlite prompt

Hi, unable to create database in sqlite prompt. Can U provide any specific command. Thanks. -- View this message in context: http://www.nabble.com/how-to-create-database-in-sqlite-prompt-tf2176202.html#a6016984 Sent from the SQLite forum at Nabble.com.

Re: [sqlite] Re: R: Re: [sqlite] How to compile sqlite3 C sample code

Try providing a -I directive followed by the path to the include files. > > Hi, > I am also one of SQLilte User. I am struggling to compile c code for > sqlite. > If you don't mind , please send me c code to compile. > i am waiting for ur reply. > thanks > -

[sqlite] Re: R: Re: [sqlite] How to compile sqlite3 C sample code

Hi, I am also one of SQLilte User. I am struggling to compile c code for sqlite. If you don't mind , please send me c code to compile. i am waiting for ur reply. thanks [EMAIL PROTECTED] wrote: > > Thanks for your fast response. > Now I can compile and test program works > fine, but. > Whe

[sqlite] Connect to SQLite Through C Program

Hi , I am struggling to connect SQLite database through C program. I got some code from the SQLite.org, when ever i tried to compile that c code it showing error like " Unable to include sqlite.h file". Please refer me solution. Could you refer any website for the code. Plz Reply me [EMAIL PROTEC

AW: [sqlite] sqlite shared-cache mode usage

Hi everybody, I am in the same situation, wondering if two or more processes can access the database if one of them is in shared-cache mode, e.g. one process act as in test_server.c serving multiple clients, another process reads/writes the database through the ODBC driver of C. Werner. Thanks in