Howdy group,
Although our store is a couple days to a week from being live, we have a
Sqlite. NET product for windows. You can read about it at
http://www.aspire.ws.
We are using Sqlite in some of our current and future products. Because of
some requests received earlier this year, we decided t
Hello.
I try to get a sqlite setup at WINDOWS with the LCC-32 C compiler to work.
I'm busy since a couple of weeks without success.
LCC-32 is a compiler that is nearly equal with VC-6.0. So that is not the
problem for shure.
I have trying several setups described at several websites. Non of then w
Eugene,
> create table test(a int, b datetime);
> insert into test values(1,'2004/1/3');
> select * from test where date(b)='2004/1/3'
> The SELECT statement returns no record.
But this works:
sqlite> select * from test where b='2004/1/3';
1|2004/1/3
The date is not encoded properly in the dat
Hi Rob,
>> size_t size = load_file->Length();
>>
>> char in[size];
>> unsigned long nLoadSize = load_file->Read((void *)in, size);
>> unsigned char out[2 +(257*nLoadSize)/254];
>> sqlite_encode_binary((const unsigned char*)in, 257*nLoadSize)/254,
>> (unsigned char*)out);
>
>
> This is actually re
You won't find /MM/DD in the list of legal time strings.
By the way, the developer(s) intend for dates to be stored
as floats (in tables). Try
select date(2453007.5);
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For add
On 3-jan-04, at 23:29, John Scott <[EMAIL PROTECTED]> wrote:
I want to use sqlite_encode_binary to encode zip files into sqlite
databse. But somehow I don't get the wanted result of this procedure.
Can someone tell me where i made a mistake??
Encoding:
wxFFile *load_file = new wxFFile();
load_f
Kurt,
Thanks for your message.
>>date() returns NULL because you're giving it an illegal time string
Well, I thought the date (not the time) string I'm giving is correct, e.g. "2004/1/3'.
It is in the correct format "/MM/DD".
I am not interested in the DATE part, that is why I'm calling "da
There seem to be some problems with the date/time functions,
but your statements will never work. Your select returns
NULL because date() returns NULL. date() returns NULL
because you're giving it an illegal time string. Read the
docs again, and pay attention to the list of legal time
str
Hi,
With regard to these new date/time functions as pointed out at:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
I have one question: I can't seem to be able to use them on actual datetime field in
the database. For instance, my test script as below:
create table test(a int, b dat
9 matches
Mail list logo
