Re: [sqlite] v3 like and collation

Miguel Angel Latorre Díaz wrote: Shoudn't the LIKE and GLOB function use a collation if present (either in column definition or by the COLLATE xxx word) ? The new collation functions are used to compare strings, and that's what LIKE and GLOB do (sort of). That way it would correctly handle the >

Re: [sqlite] Alternating Output

Ya.. I thought about all that, but the web pages will be built based on queries, so the support needs to come from the SQL statement. Using the key value is just not practical. What I am thinking about is adding a custom function (I think sqlite supports that) and just using a boolean static

[sqlite] v3 like and collation

Shoudn't the LIKE and GLOB function use a collation if present (either in column definition or by the COLLATE xxx word) ? The new collation functions are used to compare strings, and that's what LIKE and GLOB do (sort of). That way it would correctly handle the > ASCII(127) characters. -- Miguel

Re: [sqlite] 3.0 ship date?

Ned Batchelder wrote: I don't mean to be pushy, but do you have a timeframe, even a vague one? The time between 2.0 alpha and ship was eight days. Are you thinking in terms of days, weeks, or months? That really depends on how hard the user community tests on it. SQLite 3.0 already passes all of

RE: [sqlite] 3.0 ship date?

I don't mean to be pushy, but do you have a timeframe, even a vague one? The time between 2.0 alpha and ship was eight days. Are you thinking in terms of days, weeks, or months? --Ned. http://nedbatchelder.com -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent:

Re: [sqlite] 3.0 ship date?

Ned Batchelder wrote: I'm very pleased to see the 3.0 code stream, it looks like a lot of good changes. I'd really like to use it. Is there a planned date for it leaving beta and becoming official, as in "OK for production use"? I would say that 3.0 is OK to begin integrating with product. But

[sqlite] 3.0 ship date?

I'm very pleased to see the 3.0 code stream, it looks like a lot of good changes. I'd really like to use it. Is there a planned date for it leaving beta and becoming official, as in "OK for production use"? --Ned. http://nedbatchelder.com

Re: [sqlite] question on sqlite3 api

CARIOTOGLOU MIKE wrote: I am creating a Delphi wrapper for sqlite 3 API. I am having some trouble interpeting the documentation and c header files. specifically, I am not sure how to handle these: int sqlite3_bind_blob(sqlite3_stmt*, int, const void*, int n, void(*)(void*)); int

Re: [sqlite] question on sqlite3 api

CARIOTOGLOU MIKE wrote: I am creating a Delphi wrapper for sqlite 3 API. I am having some trouble interpeting the documentation and c header files. specifically, I am not sure how to handle these: int sqlite3_bind_blob(sqlite3_stmt*, int, const void*, int n, void(*)(void*)); int

Re: [sqlite] How to handle slashes (\) in text columns

"Lawrence Chitty" <[EMAIL PROTECTED]> writes: [...] > There may be better ways to handle this ?. I did a quick search but didn't > come up with any conclusive. You could ask this question on comp.lang.tcl > and see if they have a cleaner suggestion if no-one else here replies. If you don't need

[sqlite] question on sqlite3 api

I am creating a Delphi wrapper for sqlite 3 API. I am having some trouble interpeting the documentation and c header files. specifically, I am not sure how to handle these: int sqlite3_bind_blob(sqlite3_stmt*, int, const void*, int n, void(*)(void*)); int sqlite3_bind_text(sqlite3_stmt*, int,

[sqlite] Changing of Column Type

Hi. I have to change the Column Type of two coumn in the database. In the old Day's with MySQL it was doing with the following statement: ALTER TABLE Invoice CHANGE SQLKnr SQLKnr VARCHAR(8); This change the column-type from integer to varchar(8) I was trying this with several variations but

Re: [sqlite] Alternating Output

> Is there an easy way to have an "alternating" column value ...? No easy or reliable way that I can see. Given a table with an integer primary key (ipk), you could let (ipk % 2 == 0) => white and (ipk % 2 != 0) => gray, but that would work only if (1) you never delete a row or (2) you delete

[sqlite] ANN: Delphi/Cpp builder ASQLite3 components for SQLite3.0.x released

Today the first version of the open source Delphi components for SQLite 3.0.2 is released. It can be downloaded from sqlite.aducom.com. To work you need the correct dll of SQLite3.dll. This is not on the current website due to the fact that not all of the api is correctly exported. You need

Re: [sqlite] updates, triggers and "out of order"

> Is there a guarantee ... rows are updated in table sort order? No, theoretically a table is a set of rows; the rows have no inherent order. An implementation (like SQLite) may store rows in some order for convenience, but it's always free to change the storage scheme as long as the external

[sqlite] malloc() failed

Can you explain me what the possible reasons for an error code 7 can be? (SQLITE_NOMEM /* A malloc() failed */) (on a P4 2.6G 500MB) Thanks Tim

Re: [sqlite] OT: mailing list nomail option?

You can do this with ezmlm, but it requires Richard to set something up on the sqlite.org server - a new subscription address ([EMAIL PROTECTED]) which just adds users to the "allow" file. I don't know how easy or hard that would be though. On 21 Jul 2004, at 10:51, Nuno Lucas wrote: Hi, I

[sqlite] OT: mailing list nomail option?

Hi, I decided to switch to the gmane newsgroup way of reading this mailing list. But I don't seem to find any way of keeping subscribed and not receiving any mail. Gmane says to send a message to [EMAIL PROTECTED], but that doesn't seem to work. Is there another way, or should I just put a filter

[sqlite] Alternating Output

Is there an easy way to have an "alternating" column value in a query, using sqlite ? I want to have a column that alternates its value on every row. The application is web based. I want to alternate colors for each row in a table.. Something row1 = gray background, row2 = white, row3=grey,