Re: [sqlite] Possible bug

Hello. The EzTools office is closed for 1 week holidays. Will be open again around 17 April. If you have purchase a product, we will process your order then. Sorry for any inconvenience. EzTools Support ___ sqlite-users mailing list

Re: [sqlite] Sqlite 2

Hello. The EzTools office is closed for 1 week holidays. Will be open again around 17 April. If you have purchase a product, we will process your order then. Sorry for any inconvenience. EzTools Support ___ sqlite-users mailing list

Re: [sqlite] Sqlite, vb6 and date time field

Hello. The EzTools office is closed for 1 week holidays. Will be open again around 17 April. If you have purchase a product, we will process your order then. Sorry for any inconvenience. EzTools Support ___ sqlite-users mailing list

Re: [sqlite] Hello I am a newbie : for SQLite : Create db : VB6

Hello. I happened to see this thread (I'm EzTools suppport). The Sqlite open function automatically creates a new file if the file doens't exist. SqlitePlus does the same thing (since it just passes through to Sqlite). However, I have added an additional, optional parameter that will cause the

Re: [sqlite] garbage mail messages

OK Dan, you have the solution.  The count was including the terminating NULL char.  Making it not include the NULL char fixed the problem. Another question:  For an empty result, should I return 0 or -1?  And should the string be NULL or "" ?  Bear in mind that its an empty result - not a

Re: [sqlite] Can't get concat operator to work

Yes, this works fine.  I get three columns: login date, empty column, login time Quoting Stephen Oberholtzer : > On Mon, Mar 10, 2008 at 7:36 PM,  wrote: >> >> >>    I'm trying to get the concat operator to work with my user-defined >>   function.  This works fine: >> >>    SELECT

Re: [sqlite] Can't get concat operator to work

Here is what the code does.  I set up the UDF after I open a file, like this:       � sqlite3_create_function( pDb, "format_time", -1, SQLITE_UTF16, 0, format_time, 0, 0 ); The format_time function formats the time according to a template and calls sqlite3_result_text16, like this:      

Re: [sqlite] Can't get concat operator to work

Thanks Tom.  Yes, I have tried that.  The function definitely returns a valid string. Quoting BareFeet : > Hi Brett, > >>   I'm trying to get the concat operator to work with my user-defined >> function.  This works fine: >> >>   SELECT UPPER(FirstName) || ' ' || UPPER(LastName) FROM 

[sqlite] Can't get concat operator to work

I'm trying to get the concat operator to work with my user-defined function.  This works fine: SELECT UPPER(FirstName) || ' ' || UPPER(LastName) FROM  Employees But this doesn't work: SELECT FORMAT_DATE(login_time) || ' ' || FORMAT_TIME(login_time) FROM  Sessions I get only the

[sqlite] User defined functions and SQL Expressions

Hello. I've written a UDF named ENCRYPT. I want to do something like this: UPDATE Employees SET EncryptedName = ENCRYPT(LastName + ', ' + FirstName) The UDF gets called, but not with my data - rather something like "0.0". Kind of weird. Does Sqlite handle SQL expressions inside the

Re: [sqlite] Semantic Database Design

FYI, here is a good article describing how to serialize .NET data (as BLOB) to Sqlite database: http://www.windevtools.com/show_article.asp?pg=dotNET%20Serialization%20to%20SQLite%20Database/howto.html cheers This message was

[sqlite] Is it a bug?

for the column when I call sqlite3_column_decltype for the column. The return value is NULL. I must have the column data type, else my code can't properly interpret the value. This must be a bug, right? -brettg This message

Re: [sqlite] Memory DB to disk DB

Very good Keith. I think this will work fine for me. thanks Quoting Keith Herold <[EMAIL PROTECTED]>: > I am/was doing this in application, with 2.8.15 . I simply attached > the on-disk database to the memory, and then wrote a bunch of dump > queries to drop the memory data to disk (from the

[sqlite] Memory DB to disk DB

I have a situation where I start with an in-memory DB, then need to save the entire thing to a new disk DB. Does anyone know the best way to do this? Would I attach the memory DB to a newly created disk DB? Is this even possible? I notice the COPY command is not supported in 3.x according to

Re: [sqlite] db admin tool

Hello Sten. Please see www.sqliteplus.com for an excellent tool, and also a COM DLL wrapper that you can use from VB, C++ and .NET. Quoting Sten Larsson <[EMAIL PROTECTED]>: > Is there any free or commercial DB admin tool that works with sqlite 3.08 and > runs under Windows. > > (No webbased

Re: [sqlite] Whole word searches

Thanks Kurt. I think glob looks promising. best regards -brett Quoting Kurt Welgehausen <[EMAIL PROTECTED]>: > > How do I search on whole words ... > > find ... "main" and don't want ... "maintain" > > I tried using brackets as specified in the SQL spec > > There are no brackets in the SQL

[sqlite] Whole word search

I asked this question yesterday but got no answer, so here goes my second try. How do I search on whole words within a text field. For example, if I want to find the whole word "main" and don't want records with "maintain", how can I do that with Sqlite? I tried using brackets as specified in

[sqlite] Whole word searches

How do I search on whole words within a text field. For example, if I want to find the whole word "main" and don't want records with "maintain", how can I do that with Sqlite? I tried using brackets as specified in the SQL spec but I get errors. Here is some documentation from MS SQL Server: [

Re: [sqlite] SQLite manager for Windows

SqlitePlus - www.sqliteplus.com Quoting Edovia Technologies <[EMAIL PROTECTED]>: > Hi, > > > > Anyone knows about a SQLite 3 manager for Windows? The only ones I've found > so far seems to only be compatible with SQLite 2. > > > > Thanks! > > > > Luc Vandal > Edovia Technologies Inc. > [EMAIL