[sqlite] User Defined Function vs.Keyword

2004-10-01 Thread programmer
Hello again, thanks for your reply yesterday. I'm limited in my mailing possibilites, therefore no reply yesterday, but this new issue today. I did not yet try to write a collation function but began with simple user defined functions. My first try was an IIF function similar to MySQL's IF-Funct

[sqlite] Syntax

2004-09-30 Thread programmer
Hi, I'm just trying to port some MySQL-4.1.5-gamma DB to SQLite3. I exported the MySQL-DB-Metadata using PHPMyAdmin and SQLite did not accept it for several reasons. One reason is MyAdmin exports colum-names in "strange" quotes. There's IMHO no urgent need for SQLite to process these. Next issue

[sqlite] SQLITE OMIT VACUUM-Macro

2004-09-20 Thread programmer
Hi, I'm not sure whether it's a problem with my english or the SQLite code. SQLite in version 2 and 3 knows several macros which defined or not add or remove certain functionalities to eventually reduce the memory footprint of the SQLite library. SQLiteInt.h introduces: /* ** When building SQLit