Re: [sqlite] Performance tuning, and other (silly?) SQLitequestions.

uite possible. At the moment I'm not sure what HD is installed on the vehicle where the data is produced, but it can always be improved upon by throwing $$ at it ;-) Cheers, James. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Performance tuning, and other (silly?) SQLitequestions.

> James Steward <[EMAIL PROTECTED]> wrote: > > Dennis Cote <[EMAIL PROTECTED]> wrote: > > > You have said you tried both the TCL and C APIs, but you didn't say if > > you were using prepared insert statements in the C API. If not, that > > will save t

Re: [sqlite] Re: Performance tuning, and other (silly?) SQLitequestions.

ld increase your write rate again. This is also a possibility. I shall investigate. Cheers, James. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Performance tuning, and other (silly?) SQLitequestions.

hem into an SQLite database any faster than about 100 seconds at best, on my system. So unless anyone can suggest some magic I have not thought of, I will have to abandon the SQL database dream, and write a less functional, data and application specific, database of my o

Re: [sqlite] Where is sqlite3.h?

On Tue, 2007-11-20 at 14:23 +1100, James Steward wrote: > Any hints? I answer my own question. I found it in the preprocessed source zip file. I hope this will do... Cheerio. JS. - To unsubscribe, send em

[sqlite] Where is sqlite3.h?

? Regards, James. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Performance tuning, and other (silly?) SQLite questions.

On Mon, 2007-11-19 at 18:14 -0500, Igor Tandetnik wrote: > James Steward > wrote: > > db eval {CREATE TABLE position(\ > > position_id INTEGER PRIMARY_KEY, \ > > odo INTEGER, \ > > time CURRENT_TIMESTAMP);} > > You probably meant > > -- note no unders

RE: [sqlite] Memory Usage

is problematic, and why is it not problematic with other dynamic allocation approaches? Do you speak of a problem with the interface, or with specific implementations? -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Memory Usage

own fixed-size memory pool, but this certainly is not the only way to produce stable, robust, long-running software. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Request for help with the SQLite Website

rather with client/server systems. > In any case, I don't think it adds anything to the first sentence. It > would be at least as effective without that term thrown in. For those to whom the term has meaning, it adds something useful by making the embed

Re: [sqlite] Suggests for improving the SQLite website

as well) Is (3) supposed to have drop-down menus? I don't see any in Safari. I do see drop-down menus in (2). The only other problem I notice in Safari is the missing-image icon for SQLite.gif. -- James W. Walker, Innoventive Software LLC <http://www.frameforge3d.

Re: [sqlite] SQLite website

sion with explicit :hover and :visited colors for all links. http://www.cs.hmc.edu/~jdarpini/sqlite.html James -- main(c,r){for(r=32;r;)printf(++c>31?c=!r--,"\n":c<r?" ":~c?" `":" #");} - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] SQLite website

available at http://www.cs.hmc.edu/~jdarpini/sqlite.html I tested it in IE6; 3 hopefully unobtrusive hacks were needed for it to render decently. James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Suggests for improving the SQLite website

ebsite > design is appealing. Appealing *to* non-technical people? Why would a website on an embedded database wish to appeal primarily to such an audience? I'd think it would be best to present information in a way that appeals to its likely viewers. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Suggests for improving the SQLite website

Joe Wilson wrote: > > --- James Dennett <[EMAIL PROTECTED]> wrote: > > > Joe Wilson wrote: > > > No need to say it's stable or recommended - it's assumed. Otherwise it > > > wouldn't appear on the home page. > > > >

RE: [sqlite] Suggests for improving the SQLite website

ntegrity or correctness.", where this should be "affecting" -- SQLite does an excellent job of effecting database integrity and correctness :) -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Suggests for improving the SQLite website

Joe Wilson wrote: > No need to say it's stable or recommended - it's assumed. Otherwise it > wouldn't appear on the home page. I disagree. 3.5.0 appeared, even though discussion was that it was relatively experimental. It's *good* to be explicit about this. --

RE: [sqlite] DB managers that do searches?

> -Original Message- > From: Bernie Cosell [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 31, 2007 12:20 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] DB managers that do searches? > > On 31 Oct 2007 at 11:37, James Dennett wrote: > > > B

RE: [sqlite] DB managers that do searches?

Bernie Cosell wrote: > On 30 Oct 2007 at 14:05, James Dennett wrote: > > > > -Original Message- > > > From: Bernie Cosell [mailto:[EMAIL PROTECTED] > > > > I'm trying to correct several little problems in a DB I have and I've > > > now

RE: [sqlite] DB managers that do searches?

regexps, fuzzy search, natural language search, etc. I'm also wondering what you mean by a "DB manager" -- do you mean a graphical user interface interfacing to an underlying database engine, or something else? -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: Re[4]: [sqlite] Proposed sqlite3_initialize() interface

stead of returning an error, why not initialize right there instead? If a check was present, initializing would make sense. The question is whether checking at all entry points is sensible. It's not efficient, and might not be accepted for some platforms or uses. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Proposed sqlite3_initialize() interface

do the same, which is a strong argument for doing it in the library (even such an elegantly minimal library as SQLite3). -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Aggregate function as column

with another way of doing this, or working out what I'm doing wrong. Cheers, James

RE: [sqlite] Re: Some Questions Regarding Access To a SQLite Database By More Than One Process

on to assume that mutexes are process-local while other semaphores are not.) -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] 3.4.2 compile error

: *** [tclsqlite.lo] Error 1 > > > keep getting this error. using ../sqlite/configure > --prefix=/usr/local/sqlite or ../sqlite/configure .. no luck.. RHEL 3 > > Any ideas? The obvious guess is that your version of Tcl is too old. You could disable Tcl support when confi

RE: [sqlite] passing C variable in query

about tolerable for numeric values, but in general this is the road to SQL injection attacks and other related bugs; prefer the prepared statement APIs and bind values to placeholders. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] _sqlite3StrCmp not found

gt; The other interfaces you are using are APIs (notice the > underscore after the 3) and are hence guaranteed to be > supported into the future. To maybe be more explicit: it appears that you're using an older version of libtclsqlite3.dylib, and need to have/use a version compatible with your current SQLite version. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] a c++ newbie question - prepared statements.

gt; } I'd dynamically cook up a string with a suitable number of parameters, prepare it, and bind each in a loop before sqlite3_step()'ing though the results. (If this was done frequently then you could cache the prepared statements. If not, it's l

RE: [sqlite] how do i declare and use variables in sqlite?

seem to work and i can't find the documentation on this > subject. > > can someone shed some light on this for me? AFAIK, this isn't something you do with SQLite. You can retrieve values into variables in the host language

RE: [sqlite] Extremely new to SQLite

't "save"; you "commit;" your transaction, if you started one. If you didn't start one explicitly, there's nothing to do; the library will commit after each statement. That's the joy of Durability in ACID. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] How do I unsubscribe?

Thanks. NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error.

RE: [sqlite] Begining SQLite

orrectly > but ho to Create my SQLite database ? > thank you my frients Generally, any attempt to access a SQLite database will Automatically create it, unless there's something in the ADO wrapper layer than gets in the way of that. Are you

RE: [sqlite] sqlite Text fields Vista/ 64 bit/core 2 duo machines: Problem Solved.

Simpson [mailto:[EMAIL PROTECTED] Sent: Friday, July 20, 2007 12:10 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] sqlite Text fields Vista/ 64 bit/core 2 duo machines > -Original Message- > From: James Forrester [mailto:[EMAIL PROTECTED] > Sent: Friday, July 20, 200

Re: [sqlite] Callback FUnctions

don't like threads) :) With other RDBMS such as MySQL, Oracle, FireBird, Postgresql they more or less should support asyncronous queries right ? cheers James -- -- -"Problems are Solved by Method" - - James Mills <[EMAIL PROTECTED]> - HomePage: http://shortcircuit.net.au/~prologic/ - IRC: ir

Re: [sqlite] Callback FUnctions

erhaps there's already an sqlite wrapper for your environment. What > did you have in mind? Actually no, I just want asyncronous queries :) No real environment in mind. cheers James -- -- -"Problems are Solved by Method" - - James Mills <[EMAIL PROTECTED]> - HomePage: http://

[sqlite] Callback FUnctions

Hi all, Does sqlite have support for callback functions ? ie: asyncronous queries ? cheers James -- -- -"Problems are Solved by Method" - - James Mills <[EMAIL PROTECTED]> - HomePage: http://shortcircuit.net.au/~prologic/ - IRC: irc://shortcircuit.net.au#se Please avoid

RE: [sqlite] quickest way to duplicate table data?

database on its own dedicated volume could speed this up too. Of course, if your file is smaller than around 50MB, you might well just be able to use a regular OS copy routine inside your 1-2 second window. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] sqlite Text fields Vista/ 64 bit/core 2 duo machines

This may be a problem specific to Vista alone, but I'm running 64 bit and a core 2 dou machine. When I try to read a Text field with more than about 35 characters I get a: "System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other

RE: [sqlite] SQLite on Mac

ion > that I could download? There's no need to download it; Apple includes a version, and uses it. If you need a more recent version, you can build from source. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] CREATE TABLE

t's hard to say, but it seems plausible that you didn't actually execute all of the statements. Is only the first table getting created? -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] sqlite testing with Boundschecker

an indeterminate pointer has undefined behavior according to the C standard. Note that I do mean reading the value of the pointer, not dereferencing it (which is more obviously invalid). As for whether it's worth setting the pointer to null after the memory to which it pointed is freed, that's subjective. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Unicode collation

t I propose aren't actually any changes in SQLite, but rather > publishing something that would guide all SQLite developers. I thought that was what was being responded to; publishing such a recommendation leads to problem (1), because the collation rules will not match in different environmen

RE: [sqlite] transaction best practices, post-committal headaches

tion restores auto-commit mode, so far as I know. There should be no need to execute a dummy statement. That seems to work in all of my tests. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] --prefix

Sorry, my mistake: I didn't notice the "ptmp" prefix. Reminder to self: don't post without a proper night's sleep. We install SQLite3 to a custom path here (on Solaris, without Tcl support enabled) with no problem, so I don't know what's happening in your situation. -- James >

RE: [sqlite] --prefix

failed for target `tcl_install' > > > > Is my syntax for --prefix correct and is that supposed to correct the > above error? Looks like it's correct syntax, and that it's doing the right thing and attempting to install under /usr/local -- but that the user account you're usin

[sqlite] Documentation/specification of sqlite3_get_table/sqlite3_free_table

(a) call it unconditionally, and know that it's safe when its argument is NULL, or (b) call it only when sqlite3_get_table succeeds, knowing that *resultp != NULL is guaranteed in that case. -- James

RE: [sqlite] runtime errors in DEBUG with byte overflow in RC4-based random (3.3.15)

ned char. Am I to understand that you have > a compiler that does not limit the range of an unsigned char > to 0x00 through 0xff? Even if it does, the sum is promoted as needed, and so is generally an int in the range 0x00 to 0x1fe. Masking off the bits is, in pract

RE: [sqlite] Re: Table with 2 primary keys... what's the problem?

, and in C the type of x==y is still int, whereas in C++ it's bool.) -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Passing Arguments to SQLite3 from C++

It's worth briefly, for the record, mentioning that the code using += is what often causes SQL injection security issues, and that prepared statements using parameters are the way to avoid that. -- James > -Original Message- > From: nshaw [mailto:[EMAIL PROTECTED] > Sent: Mond

RE: [sqlite] Passing Arguments to SQLite3 from C++

is off-topic here, and hopefully can be ignored by others instead of attracting flames.) -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Version 3.3.14

Something that would be very useful in the shell code in a future release would be the ability to handle data containing embedded binary data. I use the shell to populate tables and many of the files I need to load have the odd \n or \000 embedded in what whould be ascii text. Sybase handles this

RE: [sqlite] Issue with trailing blanks

ts, but can be handled slightly more efficiently in many databases so we accept ugly code to deal with it. I'd definitely recommend removing the trailing blanks when you move away from a schema/database that requires them. -- James

RE: [sqlite] stupid man's manual to sqlite?

Removing the index is one of the silliest suggestions I've ever encountered. A book without an index is almost useless, unless of course you're blessed with a photographic memory. As far as putting in on a CD or on the web, that's fine as long as a _good_ index is also included in the book. I

RE: [sqlite] Is there an inverse for .import?

Not an option for what I'm doing. -Original Message- From: Rich Shepard [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 5:19 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there an inverse for .import? On Fri, 9 Mar 2007, Dennis Cote wrote: > You can get csv output

RE: [sqlite] Is there an inverse for .import?

Yes, unlike .dump, that works. Thanks very much. jim -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 5:05 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there an inverse for .import? Anderson, James H (IT) wrote: > I need to &quo

RE: [sqlite] Is there an inverse for .import?

limiter using the .separator command, or you can use .mode to use a predefined format. -Clark - Original Message From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Friday, March 9, 2007 9:04:29 AM Subject: [sqlite] Is there an inverse fo

RE: [sqlite] Is there an inverse for .import?

] Is there an inverse for .import? On 3/9/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > I need to "export" a table to a file in the same format as used by > .import, but I don't see any such cmd. Am I missing something, or does > such a cmd just not exist? .dump

[sqlite] Is there an inverse for .import?

I need to "export" a table to a file in the same format as used by .import, but I don't see any such cmd. Am I missing something, or does such a cmd just not exist? jim

RE: [sqlite] stupid man's manual to sqlite?

FWIW, excepting the index which is truly terrible, this is one of the better technical books I've encountered. It has certainly been invaluable for me. jim -Original Message- From: Mike Owens [mailto:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 9:16 PM To: sqlite-users@sqlite.org

RE: [sqlite] stupid man's manual to sqlite?

You won't be disappointed , it's a terrific book! -Original Message- From: Jakub Ladman [mailto:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 9:51 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] stupid man's manual to sqlite? Thank you i will try my possibilities buying from

[sqlite] bug in the cmd shell

The .import cmd has a problem when it encounters binary zeros embedded in data. I have a large tab-separated text file which has some garbage (aka binary zeros) in one of the fields of one of the records. The .import cmd trips on this and terminates with this msg:

RE: [sqlite] Re: Any way to know the numbers of rows affected by a cmd?

, James H (IT) wrote: > I guess I forgot to mention the context. I'm interested in doing this > from the cmd shell. > > James, You can use the command pragma count_changes=1 in the shell to have it report the number of rows affected by insert, update, or delete statemen

RE: [sqlite] Any way to know the numbers of rows affected by a cmd?

to know the numbers of rows affected by a cmd? Indeed, try: select count() ... update count() ... delete count() ... Dr. Tom - Original Message - From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Thursday, March 01, 2007 3:40 PM

RE: [sqlite] Re: Any way to know the numbers of rows affected by a cmd?

? Anderson, James H (IT) wrote: > For a select, the number of rows selected. Just count them as you step through them. > For an update, the number of rows updates. > > For a delete the number of rows deleted. sqlite3_changes, sqlite3_total_changes Ig

[sqlite] Any way to know the numbers of rows affected by a cmd?

For a select, the number of rows selected. For an update, the number of rows updates. For a delete the number of rows deleted. jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive

RE: [sqlite] .dump-n-reload vs. vacuum - which is better?

ing it up.) -- James > -Original Message- > From: Travis Daygale [mailto:[EMAIL PROTECTED] > Sent: Monday, February 26, 2007 1:05 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] .dump-n-reload vs. vacuum - which is better? > > Tangentially, but hopefully in

[sqlite] sybase => sqlite "translation" ???

I'm trying to implement the equivalent of the following sybase query in sqlite, but I suspect I've got it wrong. Any help much appreciated, jim update tmpRR_ML_final set id = case when a.CDRefSNP <> 'NR' then b.id when a.CDRefSNP = 'NR' and a.CDRefMoody

RE: [sqlite] Re: Re: Looking for equivalent syntax

OK, thanks again. -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 20, 2007 10:56 AM To: SQLite Subject: [sqlite] Re: Re: Looking for equivalent syntax Anderson, James H (IT) wrote: > In order to improve my understanding, I'd like to as

RE: [sqlite] Re: Looking for equivalent syntax

ry 19, 2007 2:04 PM To: SQLite Subject: [sqlite] Re: Looking for equivalent syntax Anderson, James H (IT) wrote: > I'm trying to convert the following statement in Sybase syntax into > the > equivalent sqlite syntax: > > update C1_credDerivEvent >set a.CDEvent = a.CDEvent || ',' |

RE: [sqlite] Re: Looking for equivalent syntax

Thanks! I'll give it a try. -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Monday, February 19, 2007 2:04 PM To: SQLite Subject: [sqlite] Re: Looking for equivalent syntax Anderson, James H (IT) wrote: > I'm trying to convert the following statement in Syb

RE: [sqlite] Looking for equivalent syntax

On Behalf Of P Kishor Sent: Monday, February 19, 2007 1:56 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Looking for equivalent syntax On 2/19/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > I'm trying to convert the following statement in Sybase syntax into the > eq

[sqlite] Looking for equivalent syntax

I'm trying to convert the following statement in Sybase syntax into the equivalent sqlite syntax: update C1_credDerivEvent set a.CDEvent = a.CDEvent || ',' || b.CDEvent from C1_credDerivEvent a, C1_tmp_credDerivEvent b, tmp_eventsc where a.CDId= b.CDId

RE: [sqlite] retrieval speedup help requested

Where does one get "analyze"? -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: Saturday, February 17, 2007 5:25 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] retrieval speedup help requested Try running: analyze city_loc after adding the index. RBS

[sqlite] Disk corruption?

Is this likely to just be a hardware error. database disk image is malformed(1) at dbdimp.c line 398 jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of

RE: [sqlite] Re: another

A syntax error, "duplicate column name". -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 14, 2007 10:24 AM To: SQLite Subject: [sqlite] Re: another Anderson, James H (IT) wrote: > If I run the following sql > > c

[sqlite] another

If I run the following sql create table table_C as select A.col_1, B.col_2 from table_A A, table_B B where A.col_3 = B.col_4 The table_C is created with the following column names: "A.col_1", "B.col_2" Quotes and all. How bizarre is that? Am I doing something wrong? (The only way

RE: [sqlite] help with syntax

That did the trick. Thanks very much. jim -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 4:55 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] help with syntax Anderson, James H (IT) wrote: > I have the following sybase qu

RE: [sqlite] help with syntax

Thanks, Dennis, I'll try that. Yes, "*=" means "LEFT JOIN" in sybase syntax. -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 4:55 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] help with syntax Anderson, James H

[sqlite] help with syntax

I have the following sybase query (a left join) that I'm having trouble translating into the "LEFT JOIN" syntax. Any help appreciated. Thanks, jim. create table tmpRR_ML as select b.ratingCodeas ratingCode, a.CDSpreadCurve as CDSpreadCurve from tmpRR a, MasterList b,

RE: [sqlite] What does this mean???

Looks like removing the semi-colon did the trick. Thanks very much. -Original Message- From: Matt Sergeant [mailto:[EMAIL PROTECTED] Sent: Thursday, February 08, 2007 11:09 AM To: Anderson, James H (IT) Cc: sqlite-users@sqlite.org Subject: Re: [sqlite] What does this mean??? On 8-Feb

RE: [sqlite] What does this mean???

The output after setting $dbh->trace(3): insert or replace into TMP_credDerivOrig select A.date, A.CDId, A.CDName, A.CDTicket, A.tradeId, A.tapsAccount, A.CDBook, coalesce(A.CDFid,'') CDFid, A.CDStatus, A.CDTradeDate, A.CDExpDate, A.CDNotional, A.CDCurr, A.CDSellBuy, A.CDType, A.CDExerType,

RE: [sqlite] What does this mean???

ot;not an error" on $sth->execute is bound to be nasty to diagnose. FWIW, it looks like "not an error" is the result of a call to sqlite3_errmsg(). Unrelated to your issue is a DBI presentation you may be interested to look through at http://search.cpan.org/src/TIMB/DBI_Adv

RE: [sqlite] What does this mean???

sure if any of that helps at all. "not an error" on $sth->execute is bound to be nasty to diagnose. FWIW, it looks like "not an error" is the result of a call to sqlite3_errmsg(). Unrelated to your issue is a DBI presentation you may be interested to look through at http://search

RE: [sqlite] What does this mean???

; on $sth->execute is bound to be nasty to diagnose. FWIW, it looks like "not an error" is the result of a call to sqlite3_errmsg(). Unrelated to your issue is a DBI presentation you may be interested to look through at http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/index

RE: [sqlite] What does this mean???

ailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: Wednesday, February 07, 2007 6:16 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] What does this mean??? On 2/7/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > Context :) > > insert or replace into TMP_cred

RE: [sqlite] What does this mean???

Clark - Original Message From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, February 7, 2007 2:33:21 PM Subject: [sqlite] What does this mean??? not an error(21) at dbdimp.c line 398 I'm using DBD::SQLite and got this e

RE: [sqlite] What does this mean???

affected: 566606 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: Wednesday, February 07, 2007 5:39 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] What does this mean??? On 2/7/07, Anderson, James H (IT) <[EMAIL PROTECTED]>

[sqlite] What does this mean???

not an error(21) at dbdimp.c line 398 I'm using DBD::SQLite and got this error. What does it mean and how best to hanle it? Thanks, jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive

RE: [sqlite] Another sybase conversion question

Thanks, Joe! That looks like it might be the solution. -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 9:58 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Another sybase conversion question --- "Anderson, James H (IT)&quo

RE: [sqlite] Another sybase conversion question

. -Original Message- From: Rich Shepard [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 6:39 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Another sybase conversion question On Fri, 2 Feb 2007, Anderson, James H (IT) wrote: > The following works fine in sybase, but beca

[sqlite] Another sybase conversion question

The following works fine in sybase, but because in sqlite "update" does not support "from" it doesn't work. Is there another way of doing this? Thanks, Jim update C1_credDerivEvent set CDEvent = a.CDEvent || ',' || b.CDEvent from C1_credDerivEvent a, C1_tmp_credDerivEvent b,

RE: [sqlite] "select into" ?

Perfect! Thanks. -Original Message- From: Gerry Snyder [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 5:28 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] "select into" ? Anderson, James H (IT) wrote: > Sybase supports "select into" but sqllite d

RE: [sqlite] "select into" ?

t; ? > - Original Message - > From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> > > Sybase supports "select into" but sqllite does not seem to. Here's a > sybase example: > > select distinct CDId, CDEvent > into credDerivEvent > f

[sqlite] "select into" ?

Sybase supports "select into" but sqllite does not seem to. Here's a sybase example: select distinct CDId, CDEvent into credDerivEvent from credDerivOrig This query creates the table credDerivEvent. Is there anythin comparable in sqlite? Thanks, jim

RE: [sqlite] Function question

That's an interesting idea, thanks, Kees. -Original Message- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 2:57 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Function question Hi Jim, On Thu, 1 Feb 2007 09:08:44 -0500, you wrote: >From the CLP

RE: [sqlite] Function question

OK, thanks. -Original Message- From: Nemanja Corlija [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 2:33 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Function question On 2/1/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > Does the fact that I have

RE: [sqlite] Function question

Does the fact that I have received no reply mean that there's no way to get this functionality within the CLP? -Original Message- From: Anderson, James H (IT) Sent: Thursday, February 01, 2007 9:09 AM To: sqlite-users@sqlite.org Subject: [sqlite] Function question >From the CLP (

[sqlite] Function question

>From the CLP (i.e., w/o user-defined functions) is there any way to get the equivalent of the sybase ltrim, rtrim functions? (ltrim/rtrim trim spaces from the right/left end of a column value.) jim NOTICE: If received in error, please

RE: [sqlite] Equivalent syntax?

Thanks. Unfortunately my background is sybase and that's anything but standard :-( -Original Message- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 6:52 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? On Wed, 31 Jan 2007 17:30:29

RE: [sqlite] Equivalent syntax?

Thanks, somehow I had missed it. -Original Message- From: Nicolas Williams [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 6:43 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? On Wed, Jan 31, 2007 at 06:31:20PM -0500, Anderson, James H (IT) wrote

<    5   6   7   8   9   10   11   >