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
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.
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
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
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
> $
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
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
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 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
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:
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
thanks.
--- On Thu, 6/12/08, Igor Tandetnik [EMAIL PROTECTED] wrote:
From: Igor Tandetnik [EMAIL PROTECTED]
Subject: Re: [sqlite] Date Selection
To: sqlite-users@sqlite.org
Date: Thursday, June 12, 2008, 7:51 AM
"Harold Wood" [EMAIL PROTECTED]
wrote in message news:[EMAIL PROTECTED]
the create
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
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
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
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} {
>>
>> }
>>
>> 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.
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,
On Jun 12, 2008, at 11:08 PM, Jeff Godfrey wrote:
>
> dbMem eval {select distinct(owner) from lockinfo order by 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:
dbMem eval
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.
> 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
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
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
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
В сообщении от 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
"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
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
27 matches
Mail list logo
