Re: [sqlite] A bit OT: Good CVS client for Windows

You can also use GNU WinCVS, http://www.wincvs.org/download.html Regards, Jay On Fri, Feb 27, 2009 at 3:07 AM, Sherief N. Farouk wrote: > > > On Feb 26, 2009, at 16:28, "J. R. Westmoreland" wrote: > > > Can someone please give me a suggestion for a good client

Re: [sqlite] Writing SQL with special characters

You can use the hex code of the non-printable character: update tableA set field1 = "line1 x'0a' line2" -Toby >Are there any docs for how to write SQL for special characters like >return and linefeed? > >On some systems (eg. http://www.wilsonmar.com/1eschars.htm) return is >\n so an SQL might

Re: [sqlite] Writing SQL with special characters

"Greg Robertson" wrote in message news:151e70a00902261923u203fdcd0yb334e5b87dd3f...@mail.gmail.com > Are there any docs for how to write SQL for special characters like > return and linefeed? > > On some systems (eg. http://www.wilsonmar.com/1eschars.htm) return is > \n so an

[sqlite] Writing SQL with special characters

Are there any docs for how to write SQL for special characters like return and linefeed? On some systems (eg. http://www.wilsonmar.com/1eschars.htm) return is \n so an SQL might be something like: UPDATE TableA SET Field1 = "line 1\nline 2" which would produce: line 1 line 2 in Field1 Is

Re: [sqlite] sqlite3_mprintf - C/C++ formatting 64-bit values?

On 27/02/2009 12:09 PM, His Nerdship wrote: > Does anyone know the sqlite3_mprintf/sqlite3_vmprintf format specifier for > 64-bit integers? > I have tried %Ld and %I64d, but it just guillotines the string at that > point. > I am using Borland C++ Builder v6. > Thanks in advance. Guess: %lld (as

[sqlite] sqlite3_mprintf - C/C++ formatting 64-bit values?

Does anyone know the sqlite3_mprintf/sqlite3_vmprintf format specifier for 64-bit integers? I have tried %Ld and %I64d, but it just guillotines the string at that point. I am using Borland C++ Builder v6. Thanks in advance. -- View this message in context:

[sqlite] Adobe AIR and Sqlite - Adobe could have statically included the FTS module?

Adobe AIR did not include the FTS module. I read in this thread (https://store1.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=75=697=1417051=y) that they disabled loadable modules. However, it would have been easy for them to statically include the FTS (and maybe other modules) in

Re: [sqlite] Question

On Thu, 26 Feb 2009 17:33:25 -0500, Bryan Lemster wrote: >Hello, >I have a question on sqlite - Is there a good way to launch an >executable when a table is updated? Thanks. Not out-of-the-box, but you could write a function in a loadable extension which forks a

Re: [sqlite] Best GUI?

On Thu, 2009-02-26 at 16:41 -0600, P Kishor wrote: > candid feedback > > http://entropy.homelinux.org/axis/northwind.png nice > http://entropy.homelinux.org/axis/client_services.png ouch! It's actually not so bad once you use it a bit. It's an all-in-one CRM app thingy that does basically

Re: [sqlite] Best GUI?

On Thu, Feb 26, 2009 at 4:30 PM, Daniel Kasak wrote: > On Thu, 2009-02-26 at 15:44 -0600, Alan Cohen wrote: > >> None of these really provide the kind of data entry screens I'd like to >> have; I have not had time to try OOo Base yet. > > Well then. You'll be

[sqlite] Question

Hello, I have a question on sqlite - Is there a good way to launch an executable when a table is updated? Thanks. -Bryan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] problem reading in SQL file with To_Date from Oracle

On Thu, Feb 26, 2009 at 3:37 PM, anjela patnaik wrote: > Hello all, > > I'm new to sqlite3. I have data in a Oracle table with one column being a > date type. Now, I've exported this table into a sql file with insert > statements. > > Then, I ran the .read command in

Re: [sqlite] Best GUI?

On Thu, 2009-02-26 at 15:44 -0600, Alan Cohen wrote: > None of these really provide the kind of data entry screens I'd like to > have; I have not had time to try OOo Base yet. Well then. You'll be interested in my projects :) http://entropy.homelinux.org/axis/ ( my home server is unfortunately

Re: [sqlite] problem reading in SQL file with To_Date from Oracle

On 27/02/2009 8:37 AM, anjela patnaik wrote: > Hello all, > > I'm new to sqlite3. I have data in a Oracle table with one column being a > date type. > Now, I've exported this table into a sql file with insert statements. > > Then, I ran the .read command in sqlite3 to read in the sql

Re: [sqlite] problem reading in SQL file with To_Date from Oracle

On Feb 26, 2009, at 4:37 PM, anjela patnaik wrote: > > Then, I ran the .read command in sqlite3 to read in the sql > statements. > sqlite doesn't support the TO_Date function. Please send me an example of the TOAD-generated INSERT statement that includes a TO_Date function. D. Richard

[sqlite] .timer with windows cli

Kim Boulton wrote: > Is there a compiled v3.6.11 sqlite3.exe with the .timer facility > enabled. I don't think so for windows -- but I've been wrong many times before. ;) [From shell.c] #if !defined(_WIN32) && !defined(WIN32) && . . . . #include #include . . . . . . . . #define BEGIN_TIMER

Re: [sqlite] A bit OT: Good CVS client for Windows

On Feb 26, 2009, at 16:28, "J. R. Westmoreland" wrote: > Can someone please give me a suggestion for a good client for CVS > that runs > under Windows? > > I have my linux system but figured it would be nice to have a client > in both > places, a belt and suspenders kind of

Re: [sqlite] Best GUI?

This is a bit of a religious question, but which are the mest/most popular *nix GUIs out there? I'm using a firefox plugin but not entirely happy with it. What do you use and why? A lot depends on what you are trying to accomplish. For example, I move between several machines, mixed between

Re: [sqlite] manual with sample C programs

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 P Kishor wrote: > hmmm... my amalgamation tarball does have shell.c separately from > sqlite3.c. You sure you got the right source? The .zip amalgamation only includes sqlite3.c, sqlite3ext.h and sqlite3.h. The .tar.gz amalgamation also includes the

[sqlite] problem reading in SQL file with To_Date from Oracle

Hello all,   I'm new to sqlite3. I have data in a Oracle table with one column being a date type. Now, I've exported this table into a sql file with insert statements.   Then, I ran the .read command in sqlite3 to read in the sql statements. sqlite doesn't support the TO_Date function.   How do

Re: [sqlite] A bit OT: Good CVS client for Windows

Try TortoiseCVS. - Sherief On Feb 26, 2009, at 16:28, "J. R. Westmoreland" wrote: > Can someone please give me a suggestion for a good client for CVS > that runs > under Windows? > > I have my linux system but figured it would be nice to have a client > in both > places, a

Re: [sqlite] A bit OT: Good CVS client for Windows

I have yet to find a CVS client that beats the standard command line client. ;shrug I've heard plenty of people say good things about TortoiseCVS though. -T On Thu, Feb 26, 2009 at 4:28 PM, J. R. Westmoreland wrote: > Can someone please give me a suggestion for a good

[sqlite] A bit OT: Good CVS client for Windows

Can someone please give me a suggestion for a good client for CVS that runs under Windows? I have my linux system but figured it would be nice to have a client in both places, a belt and suspenders kind of person I guess. Thanks, J. R. J. R. Westmoreland E-mail:

Re: [sqlite] manual with sample C programs

I'm sure I have the right stuff but in my spooling through the file I could have over looked it. I also have a copy of the CVS tree and now I have the right file I'll look there. Much easier to find things. :) Thanks again, J. R. J. R. Westmoreland E-mail: j...@jrw.org

Re: [sqlite] manual with sample C programs

On Thu, Feb 26, 2009 at 3:06 PM, J. R. Westmoreland wrote: > Thanks, I got the amalgamated source and didn't see it there. I'll try that. hmmm... my amalgamation tarball does have shell.c separately from sqlite3.c. You sure you got the right source? > > > J.

Re: [sqlite] manual with sample C programs

Thanks, I got the amalgamated source and didn't see it there. I'll try that. J. R. Westmoreland E-mail: j...@jrw.org -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of P Kishor Sent: Thursday, February 26,

Re: [sqlite] manual with sample C programs

On Thu, Feb 26, 2009 at 2:50 PM, J. R. Westmoreland wrote: > Where do I find the source to the command-line tool. I looked but didn't see > it. > Sorry if this should be obvious. :) download the source and search for it, or, you can browse the CVS tree. Here is the link to shell.c

Re: [sqlite] manual with sample C programs

Where do I find the source to the command-line tool. I looked but didn't see it. Sorry if this should be obvious. :) J. R. J. R. Westmoreland E-mail: j...@jrw.org -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On

[sqlite] Best GUI?

Greetings, This is a bit of a religious question, but which are the mest/most popular *nix GUIs out there? I'm using a firefox plugin but not entirely happy with it. What do you use and why? TIA, Nuno Magalhães LU#484677 ___ sqlite-users mailing list

Re: [sqlite] SQLite unique features

jackspratt wrote: > I'm doing some research on SQLite. Can anyone list or point me to > documentaion on distinctly unique features available in SQLite. Did your research include actually going to SQLite's site and clicking on Documentation link? The second document at

[sqlite] SQLite unique features

Hi Everyone, I'm doing some research on SQLite. Can anyone list or point me to documentaion on distinctly unique features available in SQLite. Thanks in advance! - Jack -- View this message in context: http://www.nabble.com/SQLite-unique-features-tp22232541p22232541.html Sent from the SQLite

[sqlite] .timer with windows cli

Kim Boulton wrote: > Is there a compiled v3.6.11 sqlite3.exe with the .timer facility > enabled. Not for windows (I believe) as follows: [From shell.c] #if !defined(_WIN32) && !defined(WIN32) && . . . #include #include . . . . . . #define BEGIN_TIMER beginTimer() #define

Re: [sqlite] manual with sample C programs

On Wed, 25 Feb 2009 19:51:07 -0500 (EST), Michael (mrobi...@cs.fiu.edu) wrote: >Hello users group, > >I have been looking in the documentation for sample programs >in C, but no luck yet. The source of the sqlite3 commandline tool may serve as an example. Alternatively, you could take a look at

Re: [sqlite] Concatenate single field from multiple records?

Greg Robertson wrote: > Is it possible with just an SQL to Concatenate the content from > several records of a single field with perhaps a character inbetween? > > For example if I have TableA that has Field1 with the following info > in Field1: > > rec1: How > rec2: are >

[sqlite] Concatenate single field from multiple records?

Is it possible with just an SQL to Concatenate the content from several records of a single field with perhaps a character inbetween? For example if I have TableA that has Field1 with the following info in Field1: rec1: How rec2: are rec3: you rec4: ? Would it be possibly using only SQL to

Re: [sqlite] SQL error: no such function: replace

Hi Ben, > Unfortunately though I don't have the option of updating it, since I > am > using it on a very widespread set of machines which I don't have root > privileges on... You don't necessarily have to install the newer SQLite at system level. You could incorporate it into your app or

Re: [sqlite] Error on INSERT with SELECT Max(id) FROM ...

Hi Leo, > insert into 'tblName' Values (NULL, 'five'); > create table 'tblRefMaxName' ('ref' integer, 'nn' text); > insert into 'tblRefMaxName' Values (select max(id) from tblName, > 'eins'); Apart from the responses already from other posters, you should use the correct quotes for entities

Re: [sqlite] SQLite vs. Oracle (parallelized)

On Wed, Feb 25, 2009 at 10:29:59AM -0800, Chris Wedgwood scratched on the wall: > On Mon, Feb 23, 2009 at 04:28:00PM -0500, D. Richard Hipp wrote: > > > Remember: SQLite is not trying to replace Oracle. SQLite is trying > > to replace fopen(). > > Exactly. SQLite is *wonderful* for this, and I

Re: [sqlite] Maximum number of concurrent users

It is an embedded system, so the number of users depends on how it is used. Be aware that it is not a database server like Oracle or DB2, but is a library of routines to link into your application. Eversogood wrote: > Hi, > > What is the maximum number of concurrent users for SQLite? > >

Re: [sqlite] Indexing problem

>> >> >>> kdb "select * from kfz where CRC32=-1509747892;" >>> 48482364|48|0|0C|00|00|0||20|5B93|-1509747892|||0|GP-T 1006|0 >>> 20209667|20|1|3C|00|32|202880||99|4FBD|-1509747892|||0|FL-AK 98|1 >>> 20209667|20|1|3C|00|32|202880||99|4FBD|-1509747892|||0|FL-AK 98|1 >> >> What could cause 48482364

Re: [sqlite] Indexing problem

"Marian Aldenhoevel" wrote in message news:49a65fac.5060...@mba-software.de > I am having a strange problem with a sqlite3 database. See the > following transcript: > >> sqlite3 kdb "select * from kfz where kfznr=48482364;" >>

Re: [sqlite] Maximum number of concurrent users

On Feb 26, 2009, at 6:28 AM, Eversogood wrote: > Hi, > > What is the maximum number of concurrent users for SQLite? > There is no limit, though writes are serialized. Your question betrays that you are thinking of SQLite as if it were any other client/server database engine. It is not.

Re: [sqlite] Transactions and attached databases

Hi Donald, On Feb 25, 2009, at 3:39 PM, Griggs, Donald wrote: > Greetings, Tito, > > Did you see page: >http://www.sqlite.org/lang_attach.html > > > Transactions involving multiple attached databases are atomic, > assuming > that the main database is not ":memory:". > > It then goes on to

Re: [sqlite] SQLite vs. Oracle (parallelized)

On Mon, Feb 23, 2009 at 04:28:00PM -0500, D. Richard Hipp wrote: > Remember: SQLite is not trying to replace Oracle. SQLite is trying > to replace fopen(). Exactly. SQLite is *wonderful* for this, and I would hate to see it compromised by adding features that really aren't necessary. There

Re: [sqlite] Indexing problem

Hi, >> > CREATE TABLE IF NOT EXISTS KFZ ( > > Is that as reported by the command-line sqlite3 executable program, or > is it from some script that you hope is the one that was used to create > the table? That is from the script I _know_ is the one that created the table. I will send output

Re: [sqlite] Indexing problem

On 26/02/2009 9:45 PM, John Machin wrote: > On 26/02/2009 8:23 PM, Marian Aldenhoevel wrote: >> Hi, >> >> I am having a strange problem with a sqlite3 database. See the following >> transcript: >> >> > sqlite3 kdb "select * from kfz where kfznr=48482364;" >> >

[sqlite] Maximum number of concurrent users

Hi, What is the maximum number of concurrent users for SQLite? Thanks, Ev ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Indexing problem

On 26/02/2009 8:23 PM, Marian Aldenhoevel wrote: > Hi, > > I am having a strange problem with a sqlite3 database. See the following > transcript: > > > sqlite3 kdb "select * from kfz where kfznr=48482364;" > > 48482364|48|0|0C|00|00|0||20|5B93|1746294314|||0|GP-T 1006|0 > > kfznr is the

[sqlite] Indexing problem

Hi, I am having a strange problem with a sqlite3 database. See the following transcript: > sqlite3 kdb "select * from kfz where kfznr=48482364;" > 48482364|48|0|0C|00|00|0||20|5B93|1746294314|||0|GP-T 1006|0 kfznr is the primary key, so this is to be expected. Now two queries as fired from