Re: [sqlite] Math functions

yes you can implement math functions with user defined functions by the sqlite3_create_function. sqlite.org is your freind :) 2007/4/4, Nathan Biggs <[EMAIL PROTECTED]>: Does anyone know if there is a floor function in sqlite, or of a way to implement it.

Re: [sqlite] Transferring the oracle databse to sqlite database

a way to export your database is to generate the sql script database to a file, and from sqlite type '.read path_to_file/file' if it doesn't work try to change the sql script exported so it can be understanded by sqlite for example delete stored procedure and change triggers if any way you have

Re: [sqlite] Sqlite for Embedded Devices

I'm using sqlite on embedded device and I didn't have issues till now. good performance and scalability. 2007/3/1, Jakub Ladman <[EMAIL PROTECTED]>: Dne čtvrtek 01 březen 2007 13:11 Pavan napsal(a): > Hi, > > Could anyone share their observations/comments on having used sqlite as DB > for

Re: [sqlite] Crosscompiled sqlite was: developer mailing list

you must change the configure file to use the tool chain to cross compile your lib. you must do modifications like gcc becomes gcc-arm-linux for example. but what kind of target do you have? do you have a tool chain 2007/2/27, Jakub Ladman <[EMAIL PROTECTED]>: Dne úterý 27 únor 2007 16:3

Re: [sqlite] SQL error: database is locked

there's another process using the data base or executing a transaction 2007/2/27, Jakub Ladman <[EMAIL PROTECTED]>: Dear Friends Please let me know what should i do with this? SQLite version 3.3.13 Enter ".help" for instructions sqlite> create table tbl1(one varchar(10), two smallint); SQL

Re: [sqlite] Crosscompiled sqlite was: developer mailing list

you need the libsqlite.so.0... or the libsqlite3.so crosscompiled if you need the commande line copy sqlite3 or sqlite to your target 2007/2/27, Jakub Ladman <[EMAIL PROTECTED]>: Hi everybody Which files do i need at target (small embedded linux system)? after make i have these files alter.o

Re: [sqlite] Re: trigger with conditions

Thx :) 2007/2/26, Igor Tandetnik <[EMAIL PROTECTED]>: anis chaaba <[EMAIL PROTECTED]> wrote: > Can you tell how can i trigger with conditions such as: > create trigger foo > begin > if (NEW.VALUE = 'something') > insert into tables values.. > e

[sqlite] trigger with conditions

Hello people, Can you tell how can i trigger with conditions such as: create trigger foo begin if (NEW.VALUE = 'something') insert into tables values.. endif END; thanks in advance - To unsubscribe, send email to

Re: [sqlite] Select and deletion

with which language are you trying to do this? to execute the delete statement you can use transactions to ensure atomicity. regards,

Re: [sqlite] database is locked

program it raises the error message database is locked. How can i avoid this issue? thanks a lot 2007/2/5, Dennis Cote <[EMAIL PROTECTED]>: anis chaaba wrote: > Hello > Please can you tell me how can i avoid having error message "database is > locked'? > thanks > You will ha

[sqlite] database is locked

Hello Please can you tell me how can i avoid having error message "database is locked'? thanks

Re: [sqlite] Re: Shared Lock Transactions

How do I enable shared locking? 2007/1/25, Ken <[EMAIL PROTECTED]>: From os_unix.h:... After reading this, locking makes more sense! Although the Lock may physically be an exclusive lock, the implementation is actually a logcially "SHARED" lock. /* The following describes the

[sqlite] database is locked

Hello, I have processes that access to my database, one writing on it and the other just reading. when this case take place an error message occure saying that database is locked. I saw in sqlite3 docs that sqlite3 enable this type of access but i don't know how can I activate this option. Is

Re: [sqlite] how to cross compile sqlite 3

thanks i've user sqlite 3.3.11.tar.gz and i made some modifications on configure and make file and it works 2007/2/1, C.Peachment <[EMAIL PROTECTED]>: On Thu, 1 Feb 2007 10:41:25 +0100, anis chaaba wrote: >I'm cross compiling sqlite3 for arm and there's errors in the &

[sqlite] how to cross compile sqlite 3

Hello everybody I'm cross compiling sqlite3 for arm and there's errors in the configure and the makefile generated. Do anyone of you cross compiled sqlite3? thanks in advance - To unsubscribe, send email to [EMAIL

Re: [sqlite] [Fwd: rummage bin of C API questions]

2007/1/25, anis chaaba <[EMAIL PROTECTED]>:hello 1-I'm trying to remember and i think that all routines that execute queries need to free the error message variable like sqlite_exec or others. 2- No transactions fail while you're writing clean code 3- While u'r allocationg and freeing al

Re: [sqlite] sqlite3 lib do not open old sqlite databases

er. The new file format is very different and is completely incompatible with the version 2 file format." At the bottom of that page are some suggestions for upgrading your database to the current format. - Trey - Original Message ----- From: "anis chaaba" <[EMAIL PROTECTED]&

[sqlite] php sqlite compliance

Can you please tell me what version of sqlite is supported by php5? Thanks in advance

[sqlite] sqlite3 lib do not open old sqlite databases

Hello everybody I'm moving from sqlite 2.8.17 to sqlite3.3.11 but when i'm trying to open my databases created with sqlite 2.8.X i have this error message: file is encrypted or is not a database Is that normal or did i have a mistake somewhere? Thank you for your help in advance