ActionScript 3 « intelligent e-Services – the new challenge for open minded people

8
Jun/100

7 rules to work with highest performance in SQLite databases in Adobe AIR/Flex

This article shows 7 rules how to get out the most of your SQLite application in AIR:

Create VO’s (value objects or classes) for each query extending a VO with contains at least the “ROWID”
Always use SQLStatement.itemClass and to query for an object – it automatically casts the
Use the “AS” alias in your SQL queries (e.g. SELECT count(name) AS “numberOfNames”) to fit it to your value object.
Use SQLConnection.columnNameStyle = SQLColumnNameStyle.SHORT as possible.
Try to avoid the same name in different tables (which has to be joined at one point)
Use SQL transactions: Start with sqlConnection.begin(); continue with “INSERT INTO (‘firstName’) VALUES (‘:firstName’) and SQLStatement.parameters[':firstName'] = VOList[numberOfVO][firstName]; and end with SQLConnection.commit();
If you want to get the current database Schema (‘SELECT * FROM sqlite_master WHERE type = “table”‘) open the database in read mode SQLConnection(_sqlFile, SQLMode.READ), load the Schema sqlConnection.loadSchema() and push SQLConnection.getSchemaResult() into an Array

3
Jun/100

If you are using var the NativeMenu on Mac and don’t know how to assign the backspace key, then you are here completely right.

This is how it works:

You just to set keyEquivalent = ‘\b’ (On German Keyboard: Alt Gr – Shift – 7)

Example:

menuItem:NativeMenuItem = nativeMenu.addItem(new NativeMenuItem(“MyMenuItem”));

menuItem.keyEquivalentModifiers = [Keyboard.COMMAND];

menuItem.keyEquivalent = ‘\b’;

menuItem.enabled = false;

menuItem.addEventListener(Event.SELECT, eventHandler);

No Comments