‘unique’ as column name in SQLite table and SQLError

Hi,

I have just learned that “unique” is not a good name for column name when creating table. If you try to use it then you will get following meaningless (at least to me) error:

SQLError: 'Error #3115: SQL Error.', details:'near 'BOOLEAN': syntax error'

So whenever you will have similar error and at first glimpse everything looks fine then check your column IDs.

Posted in actionscript, air for android, flash, SQLite3 (in AIR) | Tagged , , , | Comments Off on ‘unique’ as column name in SQLite table and SQLError

SQLite – open and openAsync methods NOT create folders for created database file

If you run into problems with connecting to the database and you are using open or openAsync with CREATE mode then check if folder location exists for your database file,

following code will generate SQLError

SQLError: ’Error #3125: Unable to open the database file.’, 
details:’Connection closed.’, operation:’open’, detailID:’1001’

Continue reading

Posted in actionscript, air for android, flash, SQLite3 (in AIR) | Tagged , , , , , , , , | Comments Off on SQLite – open and openAsync methods NOT create folders for created database file

Saving on SDCARD

When your application will try to save any data on sdcard using either of:

	File.desktopDirectory;//file: ///mnt/sdcard
	File.documentsDirectory;//file: ///mnt/sdcard
	File.userDirectory;//file: ///mnt/sdcard

and you notice that you can’t to do so then unplug your device from your PC:)

Posted in air for android, android | Tagged , , , | Comments Off on Saving on SDCARD

Halloween pumpkin

My first ever made:)

The Haloween Pumpkin

Haloween pumpkin

The Haloween Pumpkin

Haloween Pumpkin

The Haloween Pumpkin

Haloween Pumpkin

Posted in Uncategorized | Tagged , , | 1 Comment

Chuck Norris and iPhone – LOL

That made my day:)

Chuck Norris was once asked why he doesn’t use an iPhone, he responded, the same reason I don’t use tampons!

Hehe:)

Posted in Uncategorized | Tagged | Comments Off on Chuck Norris and iPhone – LOL