ActionScript 3.0 :: Create Connection With SQL Lite Local Database (AIR)?
Jan 4, 2012
I have got Flash CS5 and i create AIR desktop application. I would like to create and edit sql lite local air database. I know i should use SQLStatement and sqlConnection. Could someone give me any advice about doing that. Maybe some tutorial or something what let me to do that.
I don`t know should i create that database sql lite file earlier and include it to air project or should i create that database in dynamic way by as3? How can i get and edit data from this database? How can i save that local database if it included in air project (i would like to that database file would be inside of air project)?
View 4 Replies
Similar Posts:
Jan 4, 2008
I want to make an offline desktop app. that stores my company's customers and their data in an XML file, just like a database. so that I'm able to load, edit (create new customers, add to their data) and save it into the XML file which is stored locally. i then want to make a Local Connection to the XML file somehow, so that others in the company can do the same from their PC.. Can anybody tell me if this is possible at all? (making a flash app that writes XML files to any location on a PC that only has network.. edit XML files through Local connection function in flash).
View 3 Replies
Jan 29, 2009
In AS2, and creating a local connection between two swfs, what do the commands "comeBack" and "section" do?What's there place in the process?[code]...
View 1 Replies
Mar 21, 2011
Id like to know if theres any way, to create a local database, with actionscript, php and mysql.And communicate with the database, like inserting data to the database, and selecting data from the database,I mean,if actionscript is able to communicate with the local database through php and mysql.
View 3 Replies
Dec 17, 2009
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.
View 2 Replies
Jan 17, 2011
I am planning on using Flash Builder 4/Flex to write an AIR application which is primarily based around recording, storing and analyzing data.I'll be creating charts etc that need to update in almost real time.It's essential to me that the application be able to function without an internet connection so I need a local database of some variety,but I would also eventually like to build in online synchronization of the data where either database can be update each other based on newer information. Moreover, some type of encryption would definitely be welcome, and speed is a large concern
Synchronization: Primarily updates/additions/deletions will be done on the offline database, but ideally I want to have a web interface that will allow the same updates/additions/deletions and will be synced (beyond that I'm not sure exactly how to do it as I can model that based on what is most achievable).I'm wondering if there's any prebuilt engine that could handle the synchronization of 2 databases. I may end up having the web interface only be for additions, which would be significantly easier to sync.. and I may start that way, but i want to build with technologies that will best allow me to implement full online crud at some point.
View 1 Replies
Feb 4, 2010
I've started with Flex recently, I've noticed that some plugin for Visual Studio exist, instead of buying a licence for another program (Flex Builder).I was wondering how I could manage to remotely connect to my database with a Flash/Flex application with the help of C#/Asp.Net.
If I've correctly understood what I've read in the last few days, there is basically no way to 'query' to a database with Flex 3. So I suppose there is another way by using a webservice in C# on the database server that would respond to the Http query from Flex.
View 3 Replies
Jan 9, 2012
So, we want to move out from Air (Adobe stopping support and really bad implementation for the sqlite api, among other things). I want to make 3 things:
Connect with a flash (not web) application to a local mysql database.
Connect with a falsh (not web) application to a remote mysql database.
Connect with a flash (web) application with a remote mysql database.
[Code]...
if you can connect with socket wit mysql server, why use a web server (for example with php) to connect like a inter connectioN? why not connnect directly? I have done this a lot of times, using AMFPHP for example, but wouldn't be faster going directly? In the case of accessing local machine, it will be a more simple deploy application that only require the flash application + mysql server, not need to also instal a web server.
View 2 Replies
Jan 16, 2009
I have some troubles writing a database connection in AS2.0.I use LoadVars for loading and sending data. This is an example how it works, but when I use this inside a class it doesn't work.
ActionScript Code:
var loadVars_in:LoadVars = new LoadVars();
var loadVars_out:LoadVars = new LoadVars();
[code].....
View 5 Replies
Apr 29, 2011
i have been trying to execute a simple flash program that communicates with a php page which is linked to a mysql database. somehow the php is not returning any data to flash , and even falsh is not sending any data to php.. I am using wamp server on win7.
[Code].....
View 4 Replies
Aug 24, 2010
How can I establish connection of a Flash site with a database(i.e. MYSQLetc)?
View 4 Replies
Mar 14, 2011
When working with CRUD operation in flex, I want to know how to open only one time for all update and delete operations. How can I do this?
View 2 Replies
Nov 10, 2009
I want to create the following: Suppose I have 2 swfs open in an HTML doc. The first sfw has 3 buttons: red, green, blue. When I hover over these buttons, I want the words "red", "green", "blue" to appear respectively in the second swf.
I found out that I can use "local connection" to to this, but it's too advanced for me.
View 1 Replies
Dec 29, 2010
Basically, I need some help from mac users. I've made a portfolio site at: URL... and I'm using the 'Local Connection' function for communication between the thumbnail menus and the displayed images.However, I discovered that this wasn't working on macs... and after some digging, I found out that I should add the statement:[code]So, I added this, but I have no way to test whether it's now working or not as I don't have access to a mac. Is it right?
View 3 Replies
Oct 12, 2010
i have a very complex object, i wanted to pass on the object from AS2 to AS3 through Local connection. Looks like it doesnt accept more than 40k. Right now i am splitting the object and merging from AS3. i knew this is not so efficient enough. Is there any way i can share the object without splitting or any efficient way to achieve this.
View 3 Replies
Feb 27, 2010
Is it possible to connect to the same Local Connection more than once?
What if I have a Flash signature with same flash movie on the page 3 times and I click on the button on the first movie. Can the other 2 movies do the same action the first movie is doing?
I thought thats what LocalConnection was for but when the second movie tries to LocalConnection.connect it says the connection is already connected.
View 3 Replies
Nov 14, 2002
how to make a connection with my swf and an Access DataBase... or do you know where can I found this information?
View 2 Replies
Jan 30, 2009
I am really getting stuck with the 'Local Connection' action script vibe. All the tutorials show adding text from one swf and it appearing in another, but to this day i still cannot find a way of rolling over a button and it triggering the rollover on a button in anther swf.
My theory is that if it is possible to add text to another swf...surely connecting buttons is possible..
View 4 Replies
Sep 20, 2010
We're loading a AS2 SWF into a AS3 Container. Then we want the AS2 SWF to run a function in the AS3 container...Is this possible without a local connection?
View 2 Replies
Feb 2, 2010
I have 3 Flash banners on 1 page that run through a synched animation together. At the end of the animation, there is a replay button in each of the 3 banners. I want the replay button when clicked in any of the banners to call a replay function in all 3 banners. Is there any easy way to do this? Using localconnection?
The banners are already using a local connection for the syching of the animation, if that helps.
View 3 Replies
Feb 2, 2012
I am using 2 swf movies to comminicate text like in the following example[URL]it all works well, accept, the text dosn't scroll up in the recieving movie. How would i make it do that?
View 1 Replies
Jan 10, 2009
I need to check to see if the connection is already open, and if so, remove it so I can reconnect (sending a new variable on the new connection).[code]...
View 9 Replies
Nov 22, 2010
I want to be able to pass the mouse click / evt with local connection[code]...
View 1 Replies
Aug 5, 2011
When I try loading 2 swfs that use a local connection to communicate I get this error
ActionScript Code:
SecurityError: Error #2070: Security sandbox violation: caller file:///C:/Users/Siggy2xc/Adobe Flash Builder 4.5/Mass Media CG/bin-debug/swf/controlPanels/animation/Test.swf cannot access Stage owned by app:/Mass_Media_CG.swf.
[Code].....
How can I allow the 2 swfs using a local connection to communicate?
View 0 Replies
Oct 9, 2006
I have three swf's using local connection to communicate. Basically a top and bottom navigation communicating with a main module. All this works fine and looks a little like this:
Top_Nav:
[AS]
Actions.LINKFunction = function(){
outgoing_lc = new LocalConnection();
[code]....
As I mentioned this all works fine. Where I am having trouble is that there is one link that takes the user to an eCommerce area of the site that lacks the main module. It only has the top and bottom navigation. So the navigation is basically broken once the user heads to this area. By putting a getURL into the top nav function I can easily get back to index.html, but I can't figure out how to send the functions once the page has loaded. Basically looking for a way for the functions to execute after the new html page has loaded. So the user hit's the LINK button, the page index.html is loaded along with the three swf's and instead on the default movie's loading in the main-module, the functions in the main module corresponding to LINK are run.
View 1 Replies
Mar 24, 2007
Ive used local connection before, it always comes up as a bit fishy, but the best reulst i got was following the emaple in the help file, but it only works when the files are online, and i need the receiving/listening SWF to be online..and the sending should be able to work both from localhost and a domain,
[Code]...
The following example sends a string to the previous SWF file and displays a status message about whether the local connection was able to connect to the file. A TextInput component called name_ti, a TextArea instance called status_ta and a Button instance called send_button are used to display content
[Code]...
LocalConnection objects can communicate only among SWF files that are running on the same client computer, but they can be running in different applications--for example, a SWF file running in a browser and a SWF file running in a projector.
View 4 Replies
Oct 26, 2006
Is it possible to create a database driven website using these alone? Or do i need to learn any other technology? If i do then what should i learn? I know j2se for the desktop and oracle SQL/MySQL i finally got the feeling that i need to learn PHP anyway along with css and javascript. So it is fine. Also another query. Which CMS should i consider? Wordpress or Joomla?
View 1 Replies
Mar 22, 2010
I have an mp3 player(AS3) loads in external mp3. I am trying to attach the flash local connection script to the mp3 script so that I can have the mp3 pop up in a smaller browser and it be controlled by the main homepage.
here is an example, [URL] select track 4, you will see it starts playing but also another small window pops up but its behind the main browser. this is then controlled with a 'Stop' and 'Play' function on the main home page.
thats what I am trying to create:
ok;
I have an example working for the flash local connection where you can drag a ball and it also moves in the smaller pop up window, see here: [URL]
So I have that working and I have the mp3 working, but I need to put both togther and cross over the flash local connection script and incorporate into the mp3 script.
What is the best way for me to send script information, I don't want to flood the thread with AS. You can download the flash lconnection files and the mp3 player from here!
[URL]
View 7 Replies
Feb 2, 2011
How do i send a text file between air applications using local connection?Sender AIR
private var conn:LocalConnection;
public function init():void
{
[code]......
View 2 Replies
Jun 7, 2011
I am creating a local app that is going to be a swf file. Is there anyway to check if the user has internet while they are using my app. I tried this, it works great if testing the movie from flash, however, It does not work when running the swf file independently. I'm guessing this is because it is strictly intended for air app.[code]...
View 3 Replies
