Known Participant

Answered

Im new to Actionscript 3.. when i clicked the green circle it turns into red and i want it to stay that way?

Forum|Forum|10 years ago
April 24, 2015
1 reply
928 views

Im new to Actionscript 3.. when i clicked the green circle it turns into red and i want it to stay that way but it wont saved.I dont know but the color wont saved help anyone?... but its flushing.

the instance name for the movie clip is green

heres the source code

var myS:SharedObject = SharedObject.getLocal("sdsds");

var my_color:ColorTransform = new ColorTransform();

my_color.color = 0xFF0000;

green.object = myS.data.me;

green.addEventListener(MouseEvent.CLICK... myClick);

function myClick (e:MouseEvent):void{

trace("I was clicked!");

green.transform.colorTransform = my_color;

trace(myS.flush());

}

trace(myS.data.me);

This topic has been closed for replies.

Correct answer kglad

use:

var myS:SharedObject = SharedObject.getLocal("sdsds",'/');

var my_color:ColorTransform = new ColorTransform();

my_color.color = 0xFF0000;
if(myS.data.my_color){

green.transform.colorTransform=my_color;

}

green.addEventListener(MouseEvent.CLICK,myClick);

function myClick (e:MouseEvent):void{

green.transform.colorTransform = my_color;

myS.data.my_color=true;

}

kglad

Correct answer

Community Expert

use:

var myS:SharedObject = SharedObject.getLocal("sdsds",'/');

var my_color:ColorTransform = new ColorTransform();

my_color.color = 0xFF0000;
if(myS.data.my_color){

green.transform.colorTransform=my_color;

}

green.addEventListener(MouseEvent.CLICK,myClick);

function myClick (e:MouseEvent):void{

green.transform.colorTransform = my_color;

myS.data.my_color=true;

}

raultorresAuthor

Known Participant

can you tell me how to make it a save file in flash so it can trace it?

raultorresAuthor

Known Participant

database coding is for intermediate-advanced actionscripters. it's not a good place to start if you're just leaning.

the forums are a good place to ask for general direction help and for specific issues. but you won't get me or anyone else to run through all the code or even all the major steps involved in creating an air project when you don't know the basics.

you should start with the flash basics before you start this project. i suggest trevor mccauley's tutorials: senocular.com - Flash Tutorials

Im working on my project now. I'm trying to add data in database using a text field and when you click the save button the data from the text field will be added to the database.

Here is the code:

import fl.data.DataProvider;

import flash.data.SQLResult;

import flash.data.SQLConnection;

import flash.filesystem.File;

import flash.data.SQLStatement;

import flash.data.SQLConnection;

var conn:SQLConnection;

var createStmt:SQLStatement;

var insertStmt:SQLStatement;

var insertStmt2:SQLStatement;

var insertStmt3:SQLStatement;

var selectStmt:SQLStatement;

var insert1Complete:Boolean = false;

var insert2Complete:Boolean = false;

loadBtn.addEventListener(MouseEvent.CLICK, getData);

init();

function init():void

{

conn = new SQLConnection();

conn.addEventListener(SQLEvent.OPEN, openSuccess);

conn.addEventListener(SQLErrorEvent.ERROR, openFailure);

status.text = "Creating and opening database";

// Use these two lines for an on-disk database

// but be aware that the second time you run the app you'll get errors from

// creating duplicate records.

// var dbFile:File = File.applicationStorageDirectory.resolvePath("DBSample.db");

// conn.openAsync(dbFile);

// Use this line for an in-memory database

conn.openAsync(null);

}

function openSuccess(event:SQLEvent):void

{

conn.removeEventListener(SQLEvent.OPEN, openSuccess);

conn.removeEventListener(SQLErrorEvent.ERROR, openFailure);

createTable();

}

function openFailure(event:SQLErrorEvent):void

{

conn.removeEventListener(SQLEvent.OPEN, openSuccess);

conn.removeEventListener(SQLErrorEvent.ERROR, openFailure);

status.text = "Error opening database";

trace("event.error.message:", event.error.message);

trace("event.error.details:", event.error.details);

}

function createTable():void

{

status.text = "Creating table";

createStmt = new SQLStatement();

createStmt.sqlConnection = conn;

var sql:String = "";

sql += "CREATE TABLE IF NOT EXISTS employees (";

sql += " empId INTEGER PRIMARY KEY AUTOINCREMENT,";

sql += " firstName TEXT,";

sql += " lastName TEXT,";

sql += " salary NUMERIC CHECK (salary >= 0) DEFAULT 0";

sql += ")";

createStmt.text = sql;

createStmt.addEventListener(SQLEvent.RESULT, createResult);

createStmt.addEventListener(SQLErrorEvent.ERROR, createError);

createStmt.execute();

}

function createResult(event:SQLEvent):void

{

createStmt.removeEventListener(SQLEvent.RESULT, createResult);

createStmt.removeEventListener(SQLErrorEvent.ERROR, createError);

addData();

}

function createError(event:SQLErrorEvent):void

{

status.text = "Error creating table";

createStmt.removeEventListener(SQLEvent.RESULT, createResult);

createStmt.removeEventListener(SQLErrorEvent.ERROR, createError);

trace("CREATE TABLE error:", event.error);

trace("event.error.message:", event.error.message);

trace("event.error.details:", event.error.details);

}

function addData():void

{

status.text = "Adding data to table";

insertStmt = new SQLStatement();

insertStmt.sqlConnection = conn;

var sql:String = "";

sql += "INSERT INTO employees (firstName, lastName, salary) ";

sql += "VALUES ('Bob', 'Smith', 8000)";

insertStmt.text = sql;

insertStmt.addEventListener(SQLEvent.RESULT, insertResult);

insertStmt.addEventListener(SQLErrorEvent.ERROR, insertError);

insertStmt.execute();

insertStmt2 = new SQLStatement();

insertStmt2.sqlConnection = conn;

var sql2:String = "";

sql2 += "INSERT INTO employees (firstName, lastName, salary) ";

sql2 += "VALUES ('John', 'Jones', 8200)";

insertStmt2.text = sql2;

insertStmt2.addEventListener(SQLEvent.RESULT, insertResult);

insertStmt2.addEventListener(SQLErrorEvent.ERROR, insertError);

insertStmt2.execute();

}

function insertResult(event:SQLEvent):void

{

var stmt:SQLStatement = event.target as SQLStatement;

stmt.removeEventListener(SQLEvent.RESULT, insertResult);

stmt.removeEventListener(SQLErrorEvent.ERROR, insertError);

if (stmt == insertStmt)

{

insert1Complete = true;

}

else

{

insert2Complete = true;

}

if (insert1Complete && insert2Complete)

{

status.text = "Ready to load data";

}

function insertError(event:SQLErrorEvent):void

{

status.text = "Error inserting data";

insertStmt.removeEventListener(SQLEvent.RESULT, insertResult);

insertStmt.removeEventListener(SQLErrorEvent.ERROR, insertError);

trace("INSERT error:", event.error);

trace("event.error.message:", event.error.message);

trace("event.error.details:", event.error.details);

}

function getData(event:MouseEvent):void

{

status.text = "Loading data";

selectStmt = new SQLStatement();

selectStmt.sqlConnection = conn;

var sql:String = "SELECT empId, firstName, lastName, salary FROM employees";

selectStmt.text = sql;

selectStmt.addEventListener(SQLEvent.RESULT, selectResult);

selectStmt.addEventListener(SQLErrorEvent.ERROR, selectError);

selectStmt.execute();

}

function selectResult(event:SQLEvent):void

{

status.text = "Data loaded";

selectStmt.removeEventListener(SQLEvent.RESULT, selectResult);

selectStmt.removeEventListener(SQLErrorEvent.ERROR, selectError);

var result:SQLResult = selectStmt.getResult();

resultsGrid.dataProvider = new DataProvider(result.data);

// var numRows:int = result.data.length;

// for (var i:int = 0; i < numRows; i++)

// {

// var output:String = "";

// for (var prop:String in result.data)

// {

// output += prop + ": " + result.data[prop] + "; ";

// }

// trace("row[" + i.toString() + "]\t", output);

// }

}

function selectError(event:SQLErrorEvent):void

{

status.text = "Error loading data";

selectStmt.removeEventListener(SQLEvent.RESULT, selectResult);

selectStmt.removeEventListener(SQLErrorEvent.ERROR, selectError);

trace("SELECT error:", event.error);

trace("event.error.message:", event.error.message);

trace("event.error.details:", event.error.details);

}

import fl.data.DataProvider;

import flash.data.SQLResult;

import flash.data.SQLConnection;

import flash.filesystem.File;

import flash.data.SQLStatement;

import flash.data.SQLConnection;

var conn:SQLConnection;

var createStmt:SQLStatement;

var insertStmt:SQLStatement;

var insertStmt2:SQLStatement;

var insertStmt3:SQLStatement;

var selectStmt:SQLStatement;

var insert1Complete:Boolean = false;

var insert2Complete:Boolean = false;

loadBtn.addEventListener(MouseEvent.CLICK, getData);

init();

function init():void

{

conn = new SQLConnection();

conn.addEventListener(SQLEvent.OPEN, openSuccess);

conn.addEventListener(SQLErrorEvent.ERROR, openFailure);

status.text = "Creating and opening database";

// Use these two lines for an on-disk database

// but be aware that the second time you run the app you'll get errors from

// creating duplicate records.

// var dbFile:File = File.applicationStorageDirectory.resolvePath("DBSample.db");

// conn.openAsync(dbFile);

// Use this line for an in-memory database

conn.openAsync(null);

}

function openSuccess(event:SQLEvent):void

{

conn.removeEventListener(SQLEvent.OPEN, openSuccess);

conn.removeEventListener(SQLErrorEvent.ERROR, openFailure);

createTable();

}

function openFailure(event:SQLErrorEvent):void

{

conn.removeEventListener(SQLEvent.OPEN, openSuccess);

conn.removeEventListener(SQLErrorEvent.ERROR, openFailure);

status.text = "Error opening database";

trace("event.error.message:", event.error.message);

trace("event.error.details:", event.error.details);

}

function createTable():void

{

status.text = "Creating table";

createStmt = new SQLStatement();

createStmt.sqlConnection = conn;

var sql:String = "";

sql += "CREATE TABLE IF NOT EXISTS employees (";

sql += " empId INTEGER PRIMARY KEY AUTOINCREMENT,";

sql += " firstName TEXT,";

sql += " lastName TEXT,";

sql += " salary NUMERIC CHECK (salary >= 0) DEFAULT 0";

sql += ")";

createStmt.text = sql;

createStmt.addEventListener(SQLEvent.RESULT, createResult);

createStmt.addEventListener(SQLErrorEvent.ERROR, createError);

createStmt.execute();

}

function createResult(event:SQLEvent):void

{

createStmt.removeEventListener(SQLEvent.RESULT, createResult);

createStmt.removeEventListener(SQLErrorEvent.ERROR, createError);

addData();

}

function createError(event:SQLErrorEvent):void

{

status.text = "Error creating table";

createStmt.removeEventListener(SQLEvent.RESULT, createResult);

createStmt.removeEventListener(SQLErrorEvent.ERROR, createError);

trace("CREATE TABLE error:", event.error);

trace("event.error.message:", event.error.message);

trace("event.error.details:", event.error.details);

}

function addData():void

{

status.text = "Adding data to table";

insertStmt = new SQLStatement();

insertStmt.sqlConnection = conn;

var sql:String = "";

sql += "INSERT INTO employees (firstName, lastName, salary) ";

sql += "VALUES ('Bob', 'Smith', 8000)";

insertStmt.text = sql;

insertStmt.addEventListener(SQLEvent.RESULT, insertResult);

insertStmt.addEventListener(SQLErrorEvent.ERROR, insertError);

insertStmt.execute();

insertStmt2 = new SQLStatement();

insertStmt2.sqlConnection = conn;

var sql2:String = "";

sql2 += "INSERT INTO employees (firstName, lastName, salary) ";

sql2 += "VALUES ('John', 'Jones', 8200)";

insertStmt2.text = sql2;

insertStmt2.addEventListener(SQLEvent.RESULT, insertResult);

insertStmt2.addEventListener(SQLErrorEvent.ERROR, insertError);

insertStmt2.execute();

}

function insertResult(event:SQLEvent):void

{

var stmt:SQLStatement = event.target as SQLStatement;

stmt.removeEventListener(SQLEvent.RESULT, insertResult);

stmt.removeEventListener(SQLErrorEvent.ERROR, insertError);

if (stmt == insertStmt)

{

insert1Complete = true;

}

else

{

insert2Complete = true;

}

if (insert1Complete && insert2Complete)

{

status.text = "Ready to load data";

}

function insertError(event:SQLErrorEvent):void

{

status.text = "Error inserting data";

insertStmt.removeEventListener(SQLEvent.RESULT, insertResult);

insertStmt.removeEventListener(SQLErrorEvent.ERROR, insertError);

trace("INSERT error:", event.error);

trace("event.error.message:", event.error.message);

trace("event.error.details:", event.error.details);

}

function getData(event:MouseEvent):void

{

status.text = "Loading data";

selectStmt = new SQLStatement();

selectStmt.sqlConnection = conn;

var sql:String = "SELECT empId, firstName, lastName, salary FROM employees";

selectStmt.text = sql;

selectStmt.addEventListener(SQLEvent.RESULT, selectResult);

selectStmt.addEventListener(SQLErrorEvent.ERROR, selectError);

selectStmt.execute();

}

function selectResult(event:SQLEvent):void

{

status.text = "Data loaded";

selectStmt.removeEventListener(SQLEvent.RESULT, selectResult);

selectStmt.removeEventListener(SQLErrorEvent.ERROR, selectError);

var result:SQLResult = selectStmt.getResult();

resultsGrid.dataProvider = new DataProvider(result.data);

// var numRows:int = result.data.length;

// for (var i:int = 0; i < numRows; i++)

// {

// var output:String = "";

// for (var prop:String in result.data)

// {

// output += prop + ": " + result.data[prop] + "; ";

// }

// trace("row[" + i.toString() + "]\t", output);

// }

}

function selectError(event:SQLErrorEvent):void

{

status.text = "Error loading data";

selectStmt.removeEventListener(SQLEvent.RESULT, selectResult);

selectStmt.removeEventListener(SQLErrorEvent.ERROR, selectError);

trace("SELECT error:", event.error);

trace("event.error.message:", event.error.message);

trace("event.error.details:", event.error.details);

}

And i want to add data using text field

Powered by Gainsight
Terms & Conditions Accessibility statement

Sign up

Already have an account? Login

To post, reply, or follow discussions, please sign in with your Adobe ID.
Sign in

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.
Sign in

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.
OK

Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information AdChoices