Today i post other thing about AIR, how to create, read and write files using AIR, File Class.

Basically i create a class named recFile ( com.dLibs.air.recFile ) that you can download by SVN using the link : http://asdatalibs.googlecode.com/svn/trunk/

How to use this class ? So simple, you will create the recFile object and after that will set what the string you want record into this file like show bellow:

var recfile:recFile = new recFile();
recfile.writeData = "Data to record on the file";

For more info access the blog post at the : http://blog.des84.com/2009/04/09/create-write-and-read-file-using-air.des84

Hi for all .. here i will explane a little bit of how to use the videoPlayer class of dLibs classes. It support:

• Support HD (h.264)
• Play and Pause button together;
• Mute button;
• Seek bar and loaded bar;
• Time played and total time of video.

See the code bellow, it will create a video player and other controlls like play and pause button, mute and seek bar, you can see the sample working in my blog post http://blog.des84.com/2009/02/10/video-class-in-actionscript-3.des84

package
{
        import flash.display.MovieClip;
        import flash.events.MouseEvent;
        import com.dLibs.video.videoPlayer;
 
        public class main extends MovieClip
        {
                private var videoObject:videoPlayer;
                private var videoURL:String = "http://adobe.edgeboss.net/download/adobe/adobetv/flasher_magazine/issue_1/issue1.mp4";
                private var videoWidth:uint = 700;
                private var videoHeight:uint = 400;
                private var videoStart:Boolean = false;
 
                public function main():void
                {
                        videoObject = new videoPlayer(videoURL,700,400,false);
                        videoObject.addBuffer           = newBuffer;
                        videoObject.addPlayPause        = playPause;
                        videoObject.addMuteSound        = muteIcon;
                        videoObject.addDuration         = seekControll.theTime;
                        videoObject.addSeek             = {progress:seekControll.seekProgress, loader:seekControll.seekLoader};
                        newVideo.addChild(videoObject);
 
                        // @ Change status of playPause Button
 
                        playPause.addEventListener(MouseEvent.CLICK, changePlayPause);
                }
 
                private function changePlayPause(m:MouseEvent):void
                {
                        if ( m.currentTarget.currentFrame == 1 )      { m.currentTarget.nextFrame(); }
                        else                                                                               { m.currentTarget.prevFrame(); }
                }
        }
}

PROBLEM

Always when execute the AIR app we can connect with the database file and create the same table and this may do loose data.

SOLUTION

The simple way to resolve it is verify if the table is created into database file using a simple SQLite instruction IF NOT EXISTS

DETAILED DESCRIPTION

One way to resolve this problem is the code bellow. First function only connect with the database.db and the second function will create the table into database. A normal way to create one table, with out verify if the table alread created into database.db, using SQLite instructions is only CREATE TABLE, but it will create always when run app the table. Using IF NOT EXISTS we can resolve it.

private function init():void
{
        conn = new SQLConnection();
        try
        {
                 var dbFile:File = File.applicationStorageDirectory.resolvePath("database.db");
                 conn.open(dbFile);
        }
        catch (error:SQLError)
        {
                trace("Error opening database");
                trace("error.message:", error.message);
                trace("error.details:", error.details);
                return;
        }
        createTable();
}
 
private function createTable():void
{
        createStmt = new SQLStatement();
        createStmt.sqlConnection = conn;
        var sql:String = "";
        sql += "CREATE TABLE IF NOT EXISTS rssURL (";
        sql += "        id              INTEGER PRIMARY KEY AUTOINCREMENT,";
        sql += "        postName        TEXT,";
        sql += "        postURL         TEXT,";
        sql += "        postText                TEXT";
        sql += ")";
        createStmt.text = sql;
        
        try
        {
                createStmt.execute();
        }
        catch (error:SQLError)
        {
                trace("Error creating table");
                trace("CREATE TABLE error:", error);
                trace("error.message:", error.message);
                trace("error.details:", error.details);
                return;
        }
}

O *Adobe Group Goiás* está querendo saber quais são seus anseios e o que deseja com o grupo. Estamos fazendo o *cronograma e planejando* os encontros e para isso vamos precisar de você: deixe sua opnião com o conteúdo que você está procurando ou esperando agregar a você. Com sua ajuda o grupo irá crescer e fazer uma unificação de conhecimentos muito maior dando oportunidades de grandes profissionais aparecerem. O grupo está aqui para entre outras coisas: * Busca de informações e tecnologias * Busquem e ofereçam trabalhos * Troca de informações com outros profissionais * Encontros mensais para palestras e mini cursos e muito mais. Grande abraço a todos e usem o grupo sem moderação.

Hi for all, the AUGO (Adobe User Group Goiás - Brazil) will show one project make by 7Mares Midia Digital, Actionscript Programmer Pablo Davi and PHP Programmer Marcell (Equylybra). AMF ( Action Message Format ) is a binary data to be loaded into Flash using AS2 and AS3. Flex Service data (AMF3) and Flash Remoting (AMF0) and to install and implement this no need use nothing extension, only upload amfphp folder and done. This is my first project using AMFPHP and have an incredible performance to response all these requests. Athletics is a Gym in Goiânia/Goiás. The URL is : http://athletics.com.br