Actionscript :: SQLite Insert Statements In A Transaction?
Aug 16, 2011
I'm trying to get my head around how to do a SQLite bulk insert using transactions in Flex / Actionscript 3 (using Adobe Air 2). This works, but it doesn't make sense to re-create a new SQLStatement in the loop:
private function onAddBulkContacts():void {
_responder = new Responder(resultEventHandler, errorEventHandler);
contacts_db.connection.begin(null, _responder);
var statement:SQLStatement;
[Code]...
But the latter code throw an error saying that it can't execute the second time through, since the statement itself is still executing (and I believe will be in that state until the commit). I guess I can understand that the statements get added to the execution queue, but it doesn't make sense that I have to add the SQL text within the loop, exactly the thing I'm trying to avoid. I'm sure there's a better way to do this, but I've spent way too long hacking and reading trying to figure out what the proper sequence is.
I'm using flex to develop my first desktop app and I'm working with sqlite for the first time as well. I'm creating my database and all the tables and I would also like to add a few rows of data into a couple of the tables so that the users have some data to work with on first install.
The only problem I'm having is every time I run the program it keeps inserting the same data over and over again. I'm just wondering if its possible to do a - INSERT INTO IF NOT EXISTS. or some other kind of work around.
I'm using flex to develop my first desktop app and I'm working with sqlite for the first time as well. I'm creating my database and all the tables just fine, but I would also like to add a few rows of data into a couple of the tables so the information is present on first install. The only problem I'm having is every time I run the program it keeps inserting the same data over and over again. here's what I'm trying, but it doesn't seem to be working.
I have a function that inserts data into a SQLite database. I can manually add data using
sqlStatement.text = "INSERT INTO users (First_Name, Last_Name) VALUES ('John', 'Doe')";
This works perfectly. Now I am trying to insert the data from a variable instead. I can trace my variable from this function- trace(Main._firstName); //returns John, but when I insert it using this:
I need to create an application that will use Flex on the client side and PHP on the server side. In my application I will need to have transactions opened for a long time (maybe 1, 2, 3 minutes). Can you give me any toughts on what PHP-FLEX fraework to use? I even found something like AS3FlexDB but it seem to not supporting transactions for a long time.
I am looking the way to batch several remote calls from flex-based application to java-based server, so that they would be processed within a single transaction on the server-side.My idea is to build several services on server-side with setter/getter like operations:
interface MyService1 { void setField1(long myEntity1Id, int field1Value); void setField2(long myEntity1Id, int field2Value);
i have few button to let user click and the symbol will insert into the input text. i change my input box to 'symbol' but i facing the problem that i can't insert character other than symbol...
If they get a question wrong in my quiz ( weakest link) the money clip goes to zero and it goes onto the next question. If they get it right the money clip advances and they go onto the next question. I want to include each time that it should only go onto the next question if all questions have been asked. SO i want an extra if clause in both sections, saying if current question is more than 11 go to '#game over"The questions are saved in the frame of the quiz
_root.qArray = new Array("question: A;B;C;D") _root.qArray.push("Question?:A;B; C; D")
There are 11 questions.At the moment at the section with choosing answers I have
function selectAnswer(n) { // correct if (answers[n] == correctAnswer) { _root.money.nextFrame();
I am wanting to try to use a sqlite database in my project.I have downloaded several sqlite managers from the internet and they all save the database with a sqlite extension.However I see in flash we use the db extension (is this correct?);How can I use the databases I create if they all save with a sqlite extension?
I'm working on a simple todo app that has a column for each day of the week. On startup, the app checks to see if there are any incomplete tasks from before the current date. If so, they're moved to the top of the current date's column. The app is cloud-based, but the tasks are backed up for offline mode with an SQLite db. I can easily move the tasks by updating their date property, but I need the order property of each task to increment starting at 0 to place them at the top. I need to be able to define a count variable in SQLite alone and increment it with each update that's performed. I know this code doesn't work, but it's an easy way of explaining what needs to be done:
I have an as3 app which utilises an sqlite db to save metrics data. It is well known that as3 is single threaded, so when I save to this db, the Stage Video I am playing becomes jumpy! I have heard that saving db data in batches can speed up this process so I save in a loop:
for (var i:int=0; i < metricsObject.metricsComponentData.length; i++){ switch (metricsObject.metricsComponentData[i].mouseType) { case MetricsCollator.MOUSE_OVER: this._query_txt = "INSERT INTO " + this._tablePath[0] + " VALUES (null, " + this._sessionID +
[code]...
I have looked into pseudo threading examples but they all require a sprite or stage instance, the class I am executing this code in, is not a display class, I don't really want to pass an instance of the stage into this class.
I am creating an application in Flex that uses an embedded SQLite database. The data in the database contains quotes and other special characters which are escaped using a backslash or ''.Before I retrieve the data and render it in a Flex text area control I want to remove the ''. Is there any function in Flex which can help me do this - some equivalent of stripslashes() in PHP?
I'm having a problem with an expression in my sql statement in SQLite for Adobe AIR basically I have this sql = "UPDATE uniforms SET status=@status WHERE customerId IN(19,20)"; updateStmt.parameters["@status"] = args[1]; updateStmt.execute();
if I run the above code it works, updating the status when the id are 19 and 20
but if I pass the ids list as a parameter like this
sql = "UPDATE uniforms SET status=@status WHERE customerId IN(@ids)"; updateStmt.parameters["@status"] = args[1]; updateStmt.parameters["@ids"] = "19,20"; updateStmt.execute();
it gives me and error, saying could not convert text value to numeric value, which make sense because I'm passing and string but the IN expression should convert it accordingly, like it does when I pass directly the list values, why is not working the other way,
I would like to save settings for an AIR application to a local SQLite database. Wherever I read, it's recommended that you use File.applicationStorageDirectory to save the database file.
My problem is that in most cases, the AIR application will be first started by an administrator that configs and setup the application (and save the settings to database) and later used by different users. And what I would like to know is if there is possible to save the database to a location that every user can load it from? As I understand it, File.applicationStorageDirectory points to the user directory? There is probably possible too make the admins set correct permissions and stuff, but I don't want to make it difficult too install...
I'm making an application (web based) using flex and i have a requirment to access the SQLite database on the local system. There is no server running and i've decided to give them the link to the html file and see how that works out.
So in the root directory, there will be all required swf, html files, etc and a .db file. Can i access that database thro the flex web application ?
I have been struggling with trying to interface with SQLite and Adobe AIR. I am using the Flex 4 SDK with AIR 2.0. I modified code from a tutorial by David Tucker on InsideRIA ([URL]). I am writing in FlashDevelop (which I suppose could be my problem), and I can compile and run the app. The issue is that when I go to search the db file, I always get some error which results in the 'BREAKER' trace (ie - the 'queryError' function is called). I have tried simply running the SQL command on the db and it works fine, so there is an issue somewhere in the way Flex or AIR is handling my query (or obviously I could have made a mistake in coding).
I am going to start doing a couple of Adobe AIR projects that will be using SQLite feature provided by AIR. Since this is the first time I am attempting to do this, Since this application will be accessing a local db, I think I can open a connection to the database at the start of the app and keep it open till the application closes. Is this a right approach to use here?
How should design my application if I am using an MVC framework like Mate or Cairngorm? Should I create some wrapper class to perform the db operations so I can reuse this in some other project? Looking forward to some valuable information...
This link: [URL] has an interesting class to do just that! Encrypt an unencrypted database: but I'm having difficulty with a few things: You can find where the author, @probertson! Now I've got the following error: Compiler Error: Error #2044: Unhandled error:. text=Error #3125: Unable to open the database
Let me start by saying the source file works, since I've been using it (and the path) in another application. The error arises in the call to attach the source db to the newly created db.
I tried looking on google but without luck. I have a SELECT SQLStatement and I want to use the LIKE operator but the parameters won't work and the query give me an error
public function getUsersList(username:String):SQLStatement { selectRecord= new SQLStatement(); selectRecord.sqlConnection = connection; selectRecord.text = "SELECT id_u
I'm developing a desktop application in Flash, but I can't seem to find any tutorials that aren't based on FLEX to connect my application to a database file.
Do I have to write my application in FLEX to use SQLite or can I create an AIR app in Flash and still use it?
[URL] I build the program in Flash Builder 4.0, the program created a database file 'data.db'. I can find the file: "C:Documents and SettingsOOiApplication DataSQLiteArticleLocal Storedata.db", and open it in SQLiteSpy, I can see the three tables with data....
I created an AIR program within Flash CS 5.5, and put the lines of code on the 1st frame:
Using the following SQLite statement: SELECT Customer, SUM(OrderAmount) AS TotalOrder FROM OrdersTable GROUP BY Customer I get the result of total sum (total order) of each customer. How can I put the above result into a itemRenderer label.text ?
I've read the flex language reference: [URL]. This property is true if execute() has been called and not all of the results have been returned from the database. However, I'm having trouble understanding what that means exactly. I keep receiving an error: Error #3106: Property cannot be changed while SQLStatement.executing is true.
I've tried creating an event handler for SQLEvent.RESULT, my thinking was that's how the results would get returned from the database and therefore executing() would return false - didn't work. Does this mean i'm trying to change my SQLStatement variable too quickly? how long does the execute() function take?
The code in question: private function fileProgress(p_evt:ProgressEvent):void { var char:String; var line:String = ""; var counter:int = 1; sqlStatement = new SQLStatement(); [Code] ....
Stream is a filestream. I'm trying to read a textfile and put every line into a new sqlite table row. I've also tried using sqlStatement.parameters as an alternative way to do my insert queries, but to no luck. that throws a different error: Error #3110: Operation cannot be performed while SQLStatement.executing is true.
I need to store a large amount of data that will be internally accessed often within a flash file. The database is temporary and does not need to be stored in an external file. Is it possible to use SQLite to create a database that may be used internally in flash? As far as access speeds are concerned, is this an efficient solution?
Let me start off by saying this is my first Flex project, so I've been reading a lot, learning a lot, but am still struggling to make this work. I am trying to display records from an SQLite database within my Flex mobile application. I have the input form saving data correctly to the database, and I have a datagrid that is outputting the records (so I can confirm everything looks good). However, my problem is making the data readable.
I want the user to be able to select an identifier from either a drop down or a list (even if it's just a 1 column datagrid), and have the labels to the right update to reflect that information.
Background: I am using SQLite database in my flex application. Size of the database is 4 MB and have 5 tables which are
table 1 have 2500 records table 2 have 8700 records table 3 have 3000 records table 4 have 5000 records table 5 have 2000 records.
Problem: Whenever I run a select query on any table, it takes around (approx 50 seconds) to fetch data from database tables. This has made the application quite slow and unresponsive while it fetches the data from the table.
How can i improve the performance of the SQLite database so that the time taken to fetch the data from the tables is reduced?
