On Thu, Jun 12, 2008 at 5:50 AM, Harold Wood [EMAIL PROTECTED] wrote:
Hello Igor
the create table statement:
CREATE TABLE Items
(
ID INT NOT NULL PRIMARY KEY ASC,
SubCatId INT NOT NULL,
Description VARCHAR(60) NOT NULL,
LastUnitPrice NUMERIC(6,2)
Harold Wood [EMAIL PROTECTED]
wrote in message news:[EMAIL PROTECTED]
the create table statement:
LastPurchaseDate DATETIME,
You seem to be under impression there's a dedicated DATETIME type in
SQLite. This is not the case: it's just the nature of SQLite's manifest
typing
В сообщении от Friday 06 June 2008 03:51:38 P Kishor написал(а):
http://sqlite.org/contrib/download/extension-functions.c?get=22
$ wget http://sqlite.org/contrib/download/extension-functions.c?get=22
$ mv extension-functions.c?get=22 extension-functions.c
$ gcc -fPIC -shared
Dear All,
We are using SQLite for our application development which would be
deployed in a pocket pc of type DTX 10 processor ARMV4T.Also we have
generated the lib file specific for ARM processor using the LIB.exe with the
parameters DEF:sqlite3.def MACHINE:ARM and the sqlite3.lib and
In the file you have downloaded, there is the following statement:
Note: You cannot use these functions from the sqlite3 program, you
must write your own program using the sqlite3 API, and call
sqlite3_enable_load_extension. See Security Considerations in
IF you are using SQLite with eVC, you must enabled function level linking,
because
ARM linkers had a bug before eVC SP4 that generated corrupt image files.
On Thu, Jun 12, 2008 at 9:39 AM, sqlite [EMAIL PROTECTED] wrote:
Dear All,
We are using SQLite for our application development which
Note: You cannot use these functions from the sqlite3 program, you
must write your own program using the sqlite3 API, and call
sqlite3_enable_load_extension. See Security Considerations in
http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions.
I can load other extensions and use them.
Hm... I sent this message last night as a non-list member. I
received a notification that it would need to be approved by a moderator
before being made public. About 15 hours later, I received a Post was
rejected... No reason given message. Why's that? So now I'm
subscribed again.
On Jun 12, 2008, at 11:08 PM, Jeff Godfrey wrote:
dbMem eval {select distinct(owner) from lockinfo order by owner} {
do something with $owner
}
That works correctly in my original app using 3.4.2, but complains
that
there is no such variable owner when using 3.5.9.
Solution 1:
BareFeet wrote:
I get the same result above when using the command line tool of the
built in SQLite version 3.4.0 or the latest binary version 3.5.9.
FYI, this: select julianday('2008-06-12','utc');
gives: 2454629.0833
and this: select datetime(2454629.0833, 'localtime');
D. Richard Hipp wrote:
On Jun 12, 2008, at 11:08 PM, Jeff Godfrey wrote:
dbMem eval {select distinct(owner) from lockinfo order by owner} {
do something with $owner
}
That works correctly in my original app using 3.4.2, but complains
that
there is no such variable owner when using
On Jun 13, 2008, at 12:22 AM, Jeff Godfrey wrote:
Thanks for the quick solution. I've adjusted my code accordingly.
So,
do you consider this a buglet or more just the closing of a gap that
shouldn't have existed in the first place? It's interesting that the
original code works outside
Isn't there a SQLite 3 compiled library for Power PC Macs running OS X? We
do have a G5 Mac here running OS X 10.4 and it has a dylib named
libsqlite3.0.dylib but it's only about 60K in size. I'm guessing that this
is just a front end for SQLite binaries which have been integrated into the
D. Richard Hipp wrote:
On Jun 13, 2008, at 12:22 AM, Jeff Godfrey wrote:
Thanks for the quick solution. I've adjusted my code accordingly.
So,
do you consider this a buglet or more just the closing of a gap that
shouldn't have existed in the first place?
The column naming algorithm
thanks.
--- On Thu, 6/12/08, Igor Tandetnik lt;[EMAIL PROTECTED]gt; wrote:
From: Igor Tandetnik lt;[EMAIL PROTECTED]gt;
Subject: Re: [sqlite] Date Selection
To: sqlite-users@sqlite.org
Date: Thursday, June 12, 2008, 7:51 AM
Harold Wood lt;[EMAIL PROTECTED]gt;
wrote in message news:[EMAIL
Hi all,
I need to dump the data to file in csv format and I have done the following:
sqlite .output dataFile
sqlite .mode csv
sqlite select * from myTable;
sqlite.quit
The data is dump to the file correctly but I want to able to
1) append another table to this dataFile
2) Print the
I was able to reproduce this by setting by TZ to GMT +10:00. It's a
floating point rounding issue in the julian date functions. We're
investigating how to best correct it, but I don't have a fix for you now.
On 6/12/08, BareFeet [EMAIL PROTECTED] wrote:
Hi Shane,
This: select
On 6/12/08, Shane Harrelson [EMAIL PROTECTED] wrote:
I was able to reproduce this by setting by TZ to GMT +10:00. It's a
floating point rounding issue in the julian date functions. We're
investigating how to best correct it, but I don't have a fix for you now.
I can reproduce this bug on
The custom sqlite3_create_collation( ) is a perfect solution for
implementing an Internet Protocol Routing Table.
But I am not sure if SQLite will call a custom collation function if column
values are blobs. In other word, are blobs considered for collation?
One can format a blob with route
On Jun 12, 2008, at 6:35 PM, Alex Katebi wrote:
The custom sqlite3_create_collation( ) is a perfect solution for
implementing an Internet Protocol Routing Table.
But I am not sure if SQLite will call a custom collation function if
column
values are blobs. In other word, are blobs
I can still keep my routes in text presentation notation like 1.1.0.0/16 or
fe80::/16.
Thanks,
-Alex
On Thu, Jun 12, 2008 at 7:32 PM, D. Richard Hipp [EMAIL PROTECTED] wrote:
On Jun 12, 2008, at 6:35 PM, Alex Katebi wrote:
The custom sqlite3_create_collation( ) is a perfect solution for
On Thu, Jun 12, 2008 at 04:26:13PM +0400, Alexey Pechnikov scratched on the
wall:
В сообщении от Friday 06 June 2008 03:51:38 P Kishor написал(а):
http://sqlite.org/contrib/download/extension-functions.c?get=22
$ wget http://sqlite.org/contrib/download/extension-functions.c?get=22
$ mv
On Thu, Jun 12, 2008 at 10:54:09AM -0400, Carl Gundel scratched on the wall:
Isn't there a SQLite 3 compiled library for Power PC Macs running OS X? We
do have a G5 Mac here running OS X 10.4 and it has a dylib named
libsqlite3.0.dylib but it's only about 60K in size. I'm guessing that this
Dear Virgilio,
Thanks for your Quick reply, we dont know how to enable the funtional level
linking using SQLite with eVC, so kindly tell us how to enable the same.
Thanks Regards,
kartthikeyan
Virgilio Alexandre Fornazin-2 wrote:
IF you are using SQLite with eVC, you must enabled
Dear Virgilio,
We enabled the functional level linking using SQLIte, but we are getting
the unresolved exteral symbol sqlite3_open referenced in function error
which means the sqlite3.lib file we have generated is not valid? if so
kindly help us to generate the lib file for ARMV4T processor.
Hi
I am trying to put multiple commands/statements in a command line args
list to sqlite3 (Win XP command line/batch file).
This works (sq is alias for sqlite3.exe):
sq data\data1.db3 DROP TABLE IF EXISTS list; VACUUM; CREATE TABLE IF
NOT EXISTS list (Assno,Custno);
These are all statements.
Dear Virgilio,
We enabled the functional level linking using SQLIte, but we are getting
the unresolved exteral symbol sqlite3_open referenced in function error
which means the sqlite3.lib file we have generated is not valid? if so
kindly help us to generate the lib file for ARMV4T processor.
27 matches
Mail list logo
