Re: [sqlite] sqlite3.lib for ARMV4T processor
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. Thanks & Regards, kartthikeyan.s Virgilio Alexandre Fornazin-2 wrote: > > 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 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 >> sqlite3.dll >> files are generated. When we compiled the application with the sqlite >> functions like sqlite3_open() the application gets compiled and the exe >> also >> gets generated with out any errors. But when we run the application in >> the >> DTX10 device it throws an error "Application is not a valid WINCE >> application" but when we remove the function call sqlite3_open() from the >> application and run it in the device it is running without any errors. >> Have >> we generated the sqlite3.lib and sqlite3.dll files correctly? because we >> have mentioned the machine name as ARM and using the sqlite3.lib file for >> ARMV4T processor, is it correct? if not how to generate the sqlite3.lib >> file >> for the processor ARMV4T, kindly help us in this regard. Or if possible >> provide us the sqlite3.lib file meant for ARMV4T processor. >> >> Thanks >> Kartthikeyan >> -- >> View this message in context: >> http://www.nabble.com/sqlite3.lib-for-ARMV4T-processor-tp17798977p17798977.html >> Sent from the SQLite mailing list archive at Nabble.com. >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/sqlite3.lib-for-ARMV4T-processor-tp17798977p17815435.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite3 command line usage
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. This does not work: sq data\data1.db3 ".mode column" "select assno,custno,asset,custnum,branch from list,a1 where asset == assno;" A "." command followed by a statement. Variations I have tried: - quoting the full arg list as a single string - using ; / \ \n \r \r\n as separators after column Can this be made to work? and if so, how? -- Regards John McMahon [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3.lib for ARMV4T processor
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. Thanks & Regards, kartthikeyan.s sqlite wrote: > > 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 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 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 >>> sqlite3.dll >>> files are generated. When we compiled the application with the sqlite >>> functions like sqlite3_open() the application gets compiled and the exe >>> also >>> gets generated with out any errors. But when we run the application in >>> the >>> DTX10 device it throws an error "Application is not a valid WINCE >>> application" but when we remove the function call sqlite3_open() from >>> the >>> application and run it in the device it is running without any errors. >>> Have >>> we generated the sqlite3.lib and sqlite3.dll files correctly? because we >>> have mentioned the machine name as ARM and using the sqlite3.lib file >>> for >>> ARMV4T processor, is it correct? if not how to generate the sqlite3.lib >>> file >>> for the processor ARMV4T, kindly help us in this regard. Or if possible >>> provide us the sqlite3.lib file meant for ARMV4T processor. >>> >>> Thanks >>> Kartthikeyan >>> -- >>> View this message in context: >>> http://www.nabble.com/sqlite3.lib-for-ARMV4T-processor-tp17798977p17798977.html >>> Sent from the SQLite mailing list archive at Nabble.com. >>> >>> ___ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > -- View this message in context: http://www.nabble.com/sqlite3.lib-for-ARMV4T-processor-tp17798977p17815345.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3.lib 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 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 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 >> sqlite3.dll >> files are generated. When we compiled the application with the sqlite >> functions like sqlite3_open() the application gets compiled and the exe >> also >> gets generated with out any errors. But when we run the application in >> the >> DTX10 device it throws an error "Application is not a valid WINCE >> application" but when we remove the function call sqlite3_open() from the >> application and run it in the device it is running without any errors. >> Have >> we generated the sqlite3.lib and sqlite3.dll files correctly? because we >> have mentioned the machine name as ARM and using the sqlite3.lib file for >> ARMV4T processor, is it correct? if not how to generate the sqlite3.lib >> file >> for the processor ARMV4T, kindly help us in this regard. Or if possible >> provide us the sqlite3.lib file meant for ARMV4T processor. >> >> Thanks >> Kartthikeyan >> -- >> View this message in context: >> http://www.nabble.com/sqlite3.lib-for-ARMV4T-processor-tp17798977p17798977.html >> Sent from the SQLite mailing list archive at Nabble.com. >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/sqlite3.lib-for-ARMV4T-processor-tp17798977p17815078.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite 3 library for Power PC Macs?
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 > is just a front end for SQLite binaries which have been integrated into the > OS. Transplanting this library to another machine doesn't work (no > surprise). Mac OS X 10.4.11 for PPC includes the following files: -rwxr-xr-x 1 root wheel 36448 /usr/bin/sqlite3 -rwxr-xr-x 1 root wheel 284508 /usr/lib/libsqlite3.0.dylib The first is the CLI front-end, while the second is the SQLite library. The library is the "core" of the SQLite system, and the "sqlite3" program depends on it. Apple's CoreData framework also links directly against /usr/lib/libsqlite3.0.dylib, making it slightly dangerous to replace. As noted, the library is much larger than 60K. Since this is the PPC version of 10.4, these files are single-architecture. If your lib file is only 60K, something isn't right. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Math Functions
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 extension-functions.c?get=22 extension-functions.c > $ gcc -fPIC -shared extension-functions.c -o libsqlitefunctions.so > $ sqlite3 :memory: > SQLite version 3.5.9 > Enter ".help" for instructions > sqlite> SELECT load_extension('./libsqlitefunctions.so'); > SQL error: ./libsqlitefunctions.so: undefined symbol: log > > What can I do? The extension-functions file doesn't actually implement any of the math functinos, it simply acts as a glue layer between SQLite and the system math library. In this case, it looks like the run-time linker that loads the extension can't resolve the call for log() from the extension into the math library, resulting in an unresolved link. On many systems the math library is part of the standard set of libs that are imported by the linker for all applications. There are a few systems, however, where the math library is not part of the standard lib set. On those systems, you need to explicitly tell the linker you want the math library made avaliable. You can do that by compiling the lib with -lm to import the math library. The math lib won't be pulled into the .so, but it will be noted that if the run-time linker pulls in the extension, it will also need to pull in the math library before it attepts to resolve all the symbols. At least, in theory. What OS are you trying this on? -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Collation & 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 > > 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? > > > > Blob always sort in memcmp() order. The sorting rules for SQLite are > (and always have been): > > 1. NULLs sort first > 2. Numbers sort next in numerical order (floating point values > and integers interleave as appropriate). > 3. Text sorts next in the order determined by the collating > sequence > 4. BLOBs sort last in memcmp() order. > > > > D. Richard Hipp > [EMAIL PROTECTED] > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Collation & blobs
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 considered for collation? > Blob always sort in memcmp() order. The sorting rules for SQLite are (and always have been): 1. NULLs sort first 2. Numbers sort next in numerical order (floating point values and integers interleave as appropriate). 3. Text sorts next in the order determined by the collating sequence 4. BLOBs sort last in memcmp() order. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Collation & 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 mask length in the first byte followed by the destination address bytes. Thanks, -Alex ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] datetime bug
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 Mac OS X 10.5.3 with SQLite 3.5.9 without having to tinker with TZ. > > > On 6/12/08, BareFeet <[EMAIL PROTECTED]> wrote: > > > > Hi Shane, > > > > >> This: select datetime(julianday('2008-06-12','utc'), > > >> 'localtime'); > > >> > > >> should give this: 2008-06-12 00:00:00 > > >> > > >> but instead gives: 2008-06-11 24:00:00 > > > > > Can you provide some details of your test setup? What version of > > > SQLite? > > > What platform (compiler, O/S, processor, 32bit vs 64bit, etc.)? > > > > I'm using Mac OS X 10.5.3 on an iMac Intel dual 2.4GHz. I'm in > > Australia, near Sydney (GMT +10:00 I think). > > > > 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'); > > gives: 2008-06-11 24:00:00 > > > > Thanks, > > Tom > > BareFeet > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] datetime bug
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 datetime(julianday('2008-06-12','utc'), > >> 'localtime'); > >> > >> should give this: 2008-06-12 00:00:00 > >> > >> but instead gives: 2008-06-11 24:00:00 > > > Can you provide some details of your test setup? What version of > > SQLite? > > What platform (compiler, O/S, processor, 32bit vs 64bit, etc.)? > > I'm using Mac OS X 10.5.3 on an iMac Intel dual 2.4GHz. I'm in > Australia, near Sydney (GMT +10:00 I think). > > 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'); > gives: 2008-06-11 24:00:00 > > Thanks, > Tom > BareFeet > > -- > SQLite GUI tools compared at: > http://www.tandb.com.au/sqlite/compare/?ml > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sqliite Command for appending the data to file
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 tablename and table's column name to this dataFile as well I have read the.help but I couldn't find any command to help me to do these format at all. Please help if you know the way to append the data to the file and print the tablename as well as table's columns name to the file. Thanks in advance, JP ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Date Selection
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 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 (http://sqlite.org/datatype3.html) that allows one to specify any odd identifier as a column type. You have a choice of storing dates and times as strings (e.g. '2008-06-10'), as integer number of seconds since Unix epoch, or as floating point Julian day number. You manipulate these representations using built-in date/time functions: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code
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 for results > without an AS clause has changed in the past and will probably change > again in the future. So make no assumptions. Always use an AS clause. > Noted for future reference, and code (re)adjusted... ;^) Thanks, Jeff ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite 3 library for Power PC Macs?
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 OS. Transplanting this library to another machine doesn't work (no surprise). I haven't written any C code in about 20 years, so I am not really competent to compile this library myself. I placed a bid on rentacoder to see if I could get someone to compile this library from sources but so far no takers. It surprises me that the library isn't available for download at sqlite.org. -Carl Gundel Easy Windows programming - http://www.libertybasic.com Easy web programming - http://www.runbasic.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code
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 of a proc in 3.5.9, but not inside... > The TCL interface assigns values to variables where the name of the variable is the "column name" in the result set. But SQLite makes no promises about what a column name is going to be unless you use an "AS" clause on each column. The column naming algorithm for results without an AS clause has changed in the past and will probably change again in the future. So make no assumptions. Always use an AS clause. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code
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. >> > > Solution 1: > >dbMem eval {SELECT DISTINCT owner FROM lockinfo ORDER BY owner} { > puts $owner >} > > Solution 2: > >dbMem eval {SELECT DISTINCT(owner) AS owner FROM lockinfo ORDER BY > owner} { >puts $owner >} > > Solution 3: > >dbMem eval {SELECT DISTINCT(owner) FROM lockinfo ORDER BY owner} { > puts ${(owner)} >} > 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 of a proc in 3.5.9, but not inside... Again - thanks. Jeff ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] datetime bug
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'); > gives: 2008-06-11 24:00:00 > Tom, There does seem to be a roundoff error in the calculation while adding the local timezone offset. SQLite version 3.5.9 Enter ".help" for instructions sqlite> select datetime(2454629.0833); 2008-06-11 14:00:00 The base value for the hour is 14, and you are in a timezone with a +10 hour offset. It must be coming up with a sum that is slightly less than 24 hours so that it doesn't increment the day. The value is rounded correctly when formatted for display. More fun with floating point representation. :-) Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code
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 {SELECT DISTINCT owner FROM lockinfo ORDER BY owner} { puts $owner } Solution 2: dbMem eval {SELECT DISTINCT(owner) AS owner FROM lockinfo ORDER BY owner} { puts $owner } Solution 3: dbMem eval {SELECT DISTINCT(owner) FROM lockinfo ORDER BY owner} { puts ${(owner)} } D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code
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. Anyway... == Hi All, I am upgrading a Tcl/SQLite based application from SQLite 3.4.2 to SQLite 3.5.9. I'll mention that I'm also upgrading from Tcl 8.4.19 to Tcl 8.5.2 in case it's relevant, though both versions of Tcl behave the same when using SQLite 3.5.9. Anyway, I have a number of procedures that operate like the following: 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. Interestingly, I've found that the above code works under 3.5.2 when not inside a Tcl procedure. Inside the procedure though, it breaks as described. Also, a few other variations... Inside a procedure, using 3.5.2, replacing "distinct(owner)" with just "owner" works correctly and replacing "distinct(owner) with just "*" works correctly, though neither obviously does what I need. Is this an intended change to SQLite Tcl bindings, a bug, or just something else I'm missing? Thanks for any insight. Jeff Godfrey ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Math Functions
> 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. > When I try your load from the command line, I get a similar > (but not the same) error. > sqlite> SELECT load_extension('./libsqlitefunctions.so'); > SQL error: ./libsqlitefunctions.so: undefined symbol: sqrt > and I certainly have a sqrt function and use these extensions > without problems. So I guess it's a symptom of the security feature > in sqlite that prohibits loading extensions. sqlite> SELECT load_extension('./libsqlitefunctions.so'); SQL error: ./libsqlitefunctions.so: undefined symbol: log sqlite> select sqrt(1); SQL error: no such function: sqrt > On the chance that log is not defined for your environment. > I recommend you change the line > #define HAVE_LOG10 1 > to > #define HAVE_LOG10 0 > and try again. I try with no effect. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3.lib for ARMV4T processor
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 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 sqlite3.dll > files are generated. When we compiled the application with the sqlite > functions like sqlite3_open() the application gets compiled and the exe > also > gets generated with out any errors. But when we run the application in the > DTX10 device it throws an error "Application is not a valid WINCE > application" but when we remove the function call sqlite3_open() from the > application and run it in the device it is running without any errors. Have > we generated the sqlite3.lib and sqlite3.dll files correctly? because we > have mentioned the machine name as ARM and using the sqlite3.lib file for > ARMV4T processor, is it correct? if not how to generate the sqlite3.lib > file > for the processor ARMV4T, kindly help us in this regard. Or if possible > provide us the sqlite3.lib file meant for ARMV4T processor. > > Thanks > Kartthikeyan > -- > View this message in context: > http://www.nabble.com/sqlite3.lib-for-ARMV4T-processor-tp17798977p17798977.html > Sent from the SQLite mailing list archive at Nabble.com. > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Math Functions
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 http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions. When I try your load from the command line, I get a similar (but not the same) error. sqlite> SELECT load_extension('./libsqlitefunctions.so'); SQL error: ./libsqlitefunctions.so: undefined symbol: sqrt and I certainly have a sqrt function and use these extensions without problems. So I guess it's a symptom of the security feature in sqlite that prohibits loading extensions. On the chance that log is not defined for your environment. I recommend you change the line #define HAVE_LOG10 1 to #define HAVE_LOG10 0 and try again. Liam On Thu, Jun 12, 2008 at 8:26 AM, Alexey Pechnikov <[EMAIL PROTECTED]> wrote: > В сообщении от 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 extension-functions.c -o libsqlitefunctions.so > $ sqlite3 :memory: > SQLite version 3.5.9 > Enter ".help" for instructions > sqlite> SELECT load_extension('./libsqlitefunctions.so'); > SQL error: ./libsqlitefunctions.so: undefined symbol: log > > What can I do? > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite3.lib for ARMV4T processor
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 sqlite3.dll files are generated. When we compiled the application with the sqlite functions like sqlite3_open() the application gets compiled and the exe also gets generated with out any errors. But when we run the application in the DTX10 device it throws an error "Application is not a valid WINCE application" but when we remove the function call sqlite3_open() from the application and run it in the device it is running without any errors. Have we generated the sqlite3.lib and sqlite3.dll files correctly? because we have mentioned the machine name as ARM and using the sqlite3.lib file for ARMV4T processor, is it correct? if not how to generate the sqlite3.lib file for the processor ARMV4T, kindly help us in this regard. Or if possible provide us the sqlite3.lib file meant for ARMV4T processor. Thanks Kartthikeyan -- View this message in context: http://www.nabble.com/sqlite3.lib-for-ARMV4T-processor-tp17798977p17798977.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Math Functions
В сообщении от 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 extension-functions.c -o libsqlitefunctions.so $ sqlite3 :memory: SQLite version 3.5.9 Enter ".help" for instructions sqlite> SELECT load_extension('./libsqlitefunctions.so'); SQL error: ./libsqlitefunctions.so: undefined symbol: log What can I do? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Date Selection
"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 (http://sqlite.org/datatype3.html) that allows one to specify any odd identifier as a column type. You have a choice of storing dates and times as strings (e.g. '2008-06-10'), as integer number of seconds since Unix epoch, or as floating point Julian day number. You manipulate these representations using built-in date/time functions: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Date Selection
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) DEFAULT 0.0, > AvgUnitPrice NUMERIC(6,2) DEFAULT 0.0, > MinUnitPrice NUMERIC(6,2) DEFAULT 0.0, > LastPurchaseDate DATETIME, > LastQtyPurchase NUMERIC(6,2) DEFAULT 0.0, > PurchaseUnit VARCHAR(20), > NumTimesPurchased INT DEFAULT 0, > NeedIt BIT DEFAULT 0, > FOREIGN KEY (SubCatId) REFERENCES Subcategory(ID) > ); > where is DateCol ? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users