Over the weekend I had to put together a small Flex project to illustrate data in a pie graph. Also the data had to read in terms of its placement 1st 2d 3rd or 4th. While there are Flex validators for these types of things I prefer to write in Actionscript. I find it easier to follow and easily reusable in other non Flex projects.
Interesting quirk about SQLite table PRIMARY KEY's. I've been using ID as my table KEY name, a habbit adobted from MySQL. And in recent SQLite development I've been using
OK leading on from the previous post, here's a solution for the INSERT or UPDATE if row exists which seems like a very common question in forums.
I'm doing some work with SQLite in Adobe AIR. Doing some tests to figure out a cleaver TRIGGER to UPDATE or INSERT appropriately.