Issue: Unable to execute a SQLite VACUUM command from actionscript. Reason: flash.events.SQLErrorEvent SQLError detailID : 2037 details : VACUUM is not allowed from SQL. Solution: use method compact() to reclaims all unused… more »

Issue: ROWIDs in a SQLite table has been changed after executed a VACUUM command. Reason: VACUUM command rebuilds the entire database, and recreates rowid for all tables. Solution: Although query by ROWID could be fast, but it sho… more »

Issue: SQLite database file size keep increasing. SQLite database file size not reduced after deleted tables or rows. Reason: In SQLite, when an object (table, index, or trigger) is dropped from the database, it leaves behind empty space… more »

Sorry for lateness in replying message from visitors. Due to unknown reason, my blog stop sending me notification email, hence I wouldn't know immediately when someone send me a comment. Besides, due to huge amount of spam messages, visitors are enco… more »

If you are using Embedded Visual C++ 4 in Windows Vista or Windows 7, you may face problem cannot create a new project, cannot cannot select CPUs from the list, get an alert "You must select a platform." Try run the EVC4 program in compatibility mode… more »

A single SWF file generates diagrams for all kinds of guitar chords. Pass a variable from HTML to SWF e.g: chord=C,x,3,2,0,1,0 chord=G,3,5,5,4,3,3 chord=Db(C#),9,11,11,10,9,9 more »

Issue: Unable to create an New Flex Project with Application Type = Desktop (runs in Adobe AIR). Flash Builder program stop responding. Found error below in Windows Event Viewer Application Logs. Event 1000, Application Error Faulting application… more »

Issue: An ActionScript error has occurred: VerifyError: Error #1014: Class IIMEClient could not be found. at flash.display::MovieClip/nextFrame() at mx.managers::SystemManager/deferredNextFrame()[E:\dev\4.0.0\frameworks\projects\framework\src\mx… more »

I have my website blog platform upgraded, with a new look, new logo, and soon I'll have more new posts coming in. The passed year was a busy year for me, working on several projects with the company, though I had not much time to blog, but I learned… more »