ActionScript 3.0 :: Save The Path Of The Chosen File In Sqlite Database?
Jun 24, 2010
I m trying a make a database on sqlite using actionscript3 and flex.I can browse through file and select a file using browseForOpen().I can get the url by Filename.url and storing it into a string type variable fileUrl:String.I m creating table like:
CREATE TABLE IF NOT EXISTS test_table (id INTEGER PRIMARY KEY AUTOINCREMENT,user_name TEXT,password TEXT ,fileurl TEXT)
i made a text input form for entering user_name and password like:
I want to emded SQLite database (*.db file) to the AIR app, like images, mp3 etc.This is to ensure that it was impossible to copy my database for other users.
I want to create a Flex 3 application running in Adobe Air that accesses an SQLite database and I need to keep this database in sync with an SQL server 2005 database running a website.Is this something that Flex supports or is it going to be a custom script? Also, has anybody done anything like this?
Edit: The synchronisation can be done on a daily basis rather than real time. The data will be read only from a front end perspective with a CMS to do updates on the website.
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 not an expert in actionscript but I know a thing or two, but basically I've been given a task in a new web-based piece of software whereby users can drag and drop objects onto a background bitmap. The amount of objects and the co-ordinates of each object will then need to be saved for each user, so when they log back in (regardless of what machine they are using, they'll see where they have left off.)I've seen mentions of using the shared object, but this won't do as the user will not always be using the same machine.
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'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?
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 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?
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?
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'm having some trouble getting around a security restriction of flex. Saving a file is apparently an action that can only be invoked upon user interaction. The problem is that after my user clicks on the save button, I need to perform a database query to get the data for the file I want to save.
Because Flex works asynchronous, I have to make the database call and then catch the ResultEvent in a different function. In that function, I no longer have the user's mouseclick event. How am I then supposed to save this file?
I have a mobile application that uses an sqlite database. I cannot seem to figure out how to access the next record when the user presses the 'next' button. My database is using 'id' as primary key with autoincrement as integer.
private function nextMoveRPart(event:EffectEvent):void { var cardNumber:int = parseInt(cardNumberLabel.text);
I would like to have a Flash Application (not air) to connect to a local database. Air is not only getting unsupported by Adobe in LINUX but besides, it has serious problems and miss implementation with SQLite. So we want to connect to a local MySQL database. This application should be simple, so we do not want to also have an unnecessary web server (also local) to make a middle communication between the flash app and the MySQL server. There is this driver that allow to communicate Flash with MySQL [URL] Question is: Would it be any problem using this approach when installing the whole application to each client? (because we also in the installation should install a MySQL server).
Im creating an sqlite db in my air for android app inside the following function:[code]i can successfully create tables, insert and select, but each time i re-publish the app from flash cs5.5 the database is overwritten and all data is lost. Totally stumped, any ideas welcome!i'm publishing a debug release directly from flash pro via usb. When the app is initialised it calls the method above, on receiving the OPEN event it creates a table using the following SQL statement.[code]I can then run some operations, insert, select etc and everything is as expected. If i exit and re-luanch the app, the previous data sets are intact, but when i re-publish from flash any data stored from the previous release has disappeared.According to the documentation SQLConnection.open() will open a connection to the file supplied in the parameters and if it doesn't exist, it will create one...
I am working on a function to generate a form at runtime in Flex based on a call to the DB. The call to the DB returns the field types, id, tooltips etc as an arraycollection, the arraycollection is then parsed in order to ascertain what control to display based on the type field in the array - this bit works fine.However, i am stuck on trying to save the form fields back to the database using a CFC.my form rendering code is as follows but how do i save values entered back to the database? rendering code..
[Bindable] public var getglobalprofileb:ArrayCollection; public function init(event:ResultEvent):void {[code].......
This article on Livedocs says you should add the database name in front of tables.[URL]..My question is, should I do that everywhere where a table name appears or only once?In this query: select T1.col,T2.col from T1 left join T2 on T1.id=T2.id order by T2.order;
Should I add main.T1 and main.T2 everywhere or just after for, the first time: select T1.col,T2.col from main.T1 left join main.T2 on T1.id=T2.id order by T2.order;
It is only a "proof of concept" piece of code and it "lives" in the first frame of the timeline of the Flash IDE. What happens? When I compile my SWF (AIR for iPhone), I get this error:
I am willing to make a customize avatar for a registered user where the accessories will be save in a database. The item will be pulled from database to flas and after the user finished creating his avatar this will be save in the database. I mean my avatar application will be as like as farmville avatar customizetion using flash,php and mysql. I am fadeing up to find this solution.
My subject sums up the question. I want parents to be able to write their name and then save it to a database. I also want it to appear in an admin panel to make sure it isn't just scribble. I am trying to use flash to comply with the COPPA Childrens Online Privacy Protection Act.
I am making an application where the user needs to register himself. During the registration he needs to take a picture with the phones camera. All of this workds great. But if he completes the registration, the image taken by the users needs to be saved in the database(BLOB field). I searched a long time and the id behind it was to get the bitmapdata, get a bytestream and then encode with b64 to send it to the php service. So here is what I've done now:
ActionScript Code: var bitmapdata:BitmapData=this.data as BitmapData; var encoder:JPEGEncoder=new JPEGEncoder(85); var stream:ByteArray=encoder.encode(bitmapdata); var b64:Base64Encoder=new Base64Encoder();
[Code].....
But he won't insert it. I think it's something with the encoding but I don't find where the problem is exactly.
capture video and save to database,, i am trying to build an online aplication in flash to capture video (from the users camera ) and pass it to mysql or a folder in site root.
I have a complex custom class which contains custom subclasses and so on. I want to save the state of an instance of this class to a database.Currently I'm using a ByteArray.writeObject which seems to work well as I am using registerClassAlias, so all custom classes are being picked up and serialised correctly.writeObject uses the AMF standard to "flatten" classes, but is AMF the best way to go to store the entire state of a class into a database?
im new to this forum and kinda new to flash and php together...i have this project that would load a swf movie on a drawing board and user could draw something over then swf movie. It should be able to save the drawings to the database, so that the user could just load it for later use. for example if the user draws a zigzag line at frame 5 of swf movie and on frame 10 of the swf movie deletes the zigzag line and draw a circle and then saves it. then loads it later, from frame 1 to 4 of the swf movie the zigzag line should not show but on frame 5 to frame 9 it would show and on frame 10 shows only the circle. or just on the specific frame number of the swf movie it will show. like when user draw on frame 6 then on before or after frame 6 it wont show..the second one might be a bit easier to implement.
how do i save the user drawings over the swf movie? and how do i load it? do i have to save everthing (like x and y coordinates, movieclip names) in a textfile? and use that textfile to recreate the swf file drawn? what ways could i implemnt this? hopefully someone to could point me in the right direction.