Re: [sqlite] Sqlite and php

On 13 Dec 2009, at 5:27am, FrankLane wrote: > $data3 = preg_split('/\t/',$data2[$i]); // tab delimited record data into > array > > $sqlcmd = 'INSERT INTO tab (i0) VALUES ('.$data3[0].')'; Good so far. Now you should know that a normal SQL command to insert a record would look something

Re: [sqlite] Sqlite and php

Well, Im getting closer. I can't seem to get the query function right. Running the following program gives: The first record is 1 0 0 0 0 BUSI @TOWB.1@ Ernest Blacksmith Shop INSERT INTO tab (i0) VALUES (1) INSERT INTO tab (i0) VALUES (1) INSERT INTO tab (i0) VALUES (1) INSERT INTO tab (i0)

Re: [sqlite] floor help (NO bug, sorry)

>I believe there is a bug here. Yes, in I my own head! We simply need to take care of integral values. The correct rounding down at 3rd decimal places using SQLite can be done so: case when cast(myValue as text) <> round(myValue) then round(myValue - 0.0005, 3) else

Re: [sqlite] Loading a Nested Set?

My "procedural language" is C#, so that is a can-do situation. But I would like to get a lot more out of set-based SQLite if possible. On Fri, Dec 11, 2009 at 11:55 PM, Igor Tandetnik wrote: > Sqlite Fool wrote: > > In a previous life, I was able to get the stuff into a MS

Re: [sqlite] floor help (plus bug found)

[ I apologize if this appears twice on the list ] Hi, At 00:11 13/12/2009, you wrote: >Sir any ida how can value rounddown floor have done > >if not possible i have make small code >i requard make function please say how can add > >i send you my rounddown funtion > >please >Cose Exmaple :

Re: [sqlite] floor help (plus bug found)

Hi, At 00:11 13/12/2009, you wrote: >Sir any ida how can value rounddown floor have done > >if not possible i have make small code >i requard make function please say how can add > >i send you my rounddown funtion > >please >Cose Exmaple : >value=10.666 >decimal=1 >Create roundd{value,decimal){

Re: [sqlite] SQLite bug report - large databases only - 'database or disk is full'

Apologies for not answering earlier, I* was away. I've never used Process Monitor - the whole setup you describing is new to me - but I will try to do something about it in the coming week. It has to be a background project for me - I do not use SQLite in production. -Original

Re: [sqlite] SQLite version 3.6.21

D. Richard Hipp wrote: > On Dec 8, 2009, at 9:51 AM, Andreas Schwab wrote: > >> "D. Richard Hipp" writes: >> >>> On Dec 7, 2009, at 8:41 PM, Andreas Schwab wrote: >>> D. Richard Hipp writes: > As always, please let us know if you encounter any difficulties >

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexey Pechnikov wrote: > This is standart for all i18n applications. The SQLite shell is not an i18n application, and this is deliberate. It is a developer tool. That is why for example it always uses a dot for a decimal point and not a comma

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

Hello! On Saturday 12 December 2009 23:39:23 Roger Binns wrote: > > setlocale(LC_ALL, ""); > > Why? Yes I know what the call does, but what desirable effect does it have > on shell input and output? Pretty much all formatted output is done using > %s. The only float output is for timing

Re: [sqlite] BUG: The sqlite3 shell does not call setlocale

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexey Pechnikov wrote: > On unix the shell must do this initialisation: > > setlocale(LC_ALL, ""); Why? Yes I know what the call does, but what desirable effect does it have on shell input and output? Pretty much all formatted output is done

[sqlite] The SQLite History extension

Hello! The SQLite History extension Link: http://mobigroup.ru/files/sqlite-ext/history/ The History SQLite extension may be used for table history logging. This version can store the user and host information obtained from environment variables or application-defined functions. See details

[sqlite] sqlite3-rdiff: master-slave replication for SQLite

Hello! sqlite3-rdiff - compute and apply signature-based row differences for SQLite3 databases Link: http://mobigroup.ru/files/sqlite-ext/sqlite3-rdiff Depends: tcl 8.5, sqlite3, murmurhash SQLite extension Are used the ROWID value as unique key of row and murmurhash for build signatures for

[sqlite] BUG: The sqlite3 shell does not call setlocale

Hello! On unix the shell must do this initialisation: setlocale(LC_ALL, ""); Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users