ActionScript 2.0 :: Database - Make A Local Connection To The XML File
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).
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)?
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 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 managed to make a local streaming (connection) to the server,by seting the FME at rtmp://localhost(or my IP)/live.But now i want to make a non local streaming.
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.
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.
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.
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();
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.
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.
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?
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.
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.
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..
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?
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.
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?
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]...
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.
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.
i want to intertwine php, MySql and flash. so i can make a flash movie display text that is in the sql database and a php script to change the database, php > sql = i can do but sql > flash = i can't do..i want it so the sql data show's in a text box in the flash movie...
I created a simple interface for our laptop users to use to call files to change internet settings. Most of the files are batch files but I have one .exe and two registry setting files that change proxy settings. I want buttons that will call each file when clicked. Seems simple but I have been trying to figure this out and I'm getting no where. I'm attaching my flash file. It's a flash cs4 file. Can I not attach the script to each button? For some reason I thought I used to do it this way but when I highlight it it says I cannot attach script to the object.
