sqlite is missing several basic database features compared to typical SQL servers and unfortunately padding is one of them. For a most situations though, you can use a simple hack to get the same functionality. This trick uses a combination of concatenation and substr: — the statement below is almost the same as — select [...]
Archive | SQLite RSS feed for this section
Working with dates in Flex AIR and SQLite
UPDATE 3/25/09: Paul Robertson from the AIR team stopped by and writes that declaring your SQLite column affinity (ie column type) as “DATE” will instruct AIR to handle all date conversions for you automatically. The problems I experienced mainly surfaced in a DataGrid when using a DateField and I have not had a chance to [...]
Ridiculous date formatting in SQLite
The following code outputs a SQLite date into a standard date format with month abbreviations that, believe it or not, Flex/AIR will accept as a Date value (Though SQLite itself doesn’t recognize it as a valid DATETIME!). I created this atrocious code while trying to figure out the mysterious interaction between AIR and SQLite date [...]
