Re: [sqlite] SQLite acces from vbScript

Take a look to : http://www.terrainformatica.com/sqlitedb/ Personally I don't use it, but looks nice. Regards Radu Lodina On 1/30/06, John Latimer <[EMAIL PROTECTED]> wrote: > > Thanks for the lead, I'll go looking for it... > > John L> > > Cariotoglou Mike <[EMAIL PROTECTED]> wrote: >

Re: [sqlite] Bug in insert into ... select * ....

Hi D. Richard Hipp I use the Sqlitecc to show it out http://bobmanc.home.comcast.net/sqlitecc.html If the bug is so easy to find out, perhaps you could give us an example. I am unable to reproduce it. Here is the example: create table test01( FLD01 char(3) default ''); create table

Re: [sqlite] Importing Tab delimited data

On 1/30/06, Clint Bailey <[EMAIL PROTECTED]> wrote: > Is it possible to import tab delimited data into sqlite in order to > start testing? You can use sqlite3 command for that. Something like this: E:\SQLite>sqlite3.exe test.db3 SQLite version 3.2.6 Enter ".help" for instructions sqlite> CREATE

[sqlite] Importing Tab delimited data

Is it possible to import tab delimited data into sqlite in order to start testing?

RE: [sqlite] SQLite acces from vbScript

Thanks for the lead, I'll go looking for it... John L> Cariotoglou Mike <[EMAIL PROTECTED]> wrote: all you need is an OLEDB or ODBC wrapper for sqlite, and there are some around, check the wiki. once you install one, your sqlite is accesible from ADO, just like any other database

RE: [sqlite] SQLite acces from vbScript

all you need is an OLEDB or ODBC wrapper for sqlite, and there are some around, check the wiki. once you install one, your sqlite is accesible from ADO, just like any other database (almost) From: John Latimer [mailto:[EMAIL PROTECTED] Sent: Mon 30-Jan-06 12:06

[sqlite] SQLite acces from vbScript

I am programming in vbScript within the framework of a larger program on a PC platform and need to have access to SQLite for my database needs. I am an inexperienced programmer, so I wouldn't be surprised if the answer is very obvious to you , but oblivious to me... I require use of

Re: [sqlite] Two problems

On Mon, 2006-01-23 at 09:48 -0500, Paul Tomblin wrote: > Quoting Dan Kennedy ([EMAIL PROTECTED]): > > > - The second problem appears to be a problem with self-locking. I'm > > > inserting a "mapping" into a table. I have a query active to find ids > > > that require mapping, and then I try

Re: [sqlite] sqlite in a shell

rahed <[EMAIL PROTECTED]> writes: > Joe Wilson <[EMAIL PROTECTED]> writes: > >> I've seen this same behavior when running a MinGW-compiled sqlite3.exe in >> the cygwin shell. It has >> something to do with the lack of flushing of information written to stdout >> (until close() anyway). >> If

[sqlite] READ UNCOMMITTED isolation?

Does anyone know how to use the new READ UNCOMMITTED isolation? It would be great to have this isolation level when one thread reads and another writes. My program doesn't worry too much about read consistency. Thanks, Jack Pan

Re: [sqlite] Bug in insert into ... select * ....

Hi Darren Duncan, you said "insert contents of your_table into your_table" No, insert into table01 select * from table02 the structure of table01 and table02 are same, Table01 and table02 are different table within same structure, No such bug within MSSQL or mySQL or PostgreSQL ! Only

Re: [sqlite] sqlite in a shell

Joe Wilson <[EMAIL PROTECTED]> writes: > I've seen this same behavior when running a MinGW-compiled sqlite3.exe in the > cygwin shell. It has > something to do with the lack of flushing of information written to stdout > (until close() anyway). > If you blindly type in the sqlite commands - it

Re: [sqlite] querying hierarchy

Jim Crafton schrieb: In my table(s) I need to model a class hierarchy, as well as a class/var/function belonging to a namespace, and/or a function/var belonging to a class. In other words a parent/child relationship. If I simply add a new column to my primary symbols table, call it "Parent",

Re: [sqlite] FILE_FLAG_WRITE_THROUGH for windows in future releases?

Hi Richard, I hoped I could argue with you on that, but unfortunately I am not an expert on this matter I am just reporting what I have experienced (and it is aligned with what was reported by other fellows). Before I used the patch, I got < 10 inserts/sec on some brand new computers. After

Re: [sqlite] Bug in insert into ... select * ....

At 3:32 PM +0800 1/29/06, shum [Ming Yik] wrote: Hi Sqlite Team, insert into disk.your_table select * from your_table; There is an bugwithin insert into table01 select * from table02 Always double the inserted rows in table01 ... where the structure of table01 and table02 are the same