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
sqlite-users@s
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
sqlite-users@s
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
sqlite-users@s
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
Sq
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
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 UPPER
Sorry, I forgot to answer your question about using other Sqlite
built-in functions for date and time. I need my own custom version
because my database dates can be stored as either a double value (OLE
Date scheme) or as text representation. My custom functions can also
accept a format templ
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:
sqlit
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
Em
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 form
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 parenthe
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 s
type 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 m
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 m
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 t
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 to
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 spec
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 th
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:
[
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 PRO
20 matches
Mail list logo