Database :: Flex - Creating Multiple Tables In Adobe Air
Nov 30, 2011
I want to create 2 tables in a single adobe air database. I am using Adobe flash builder with the import flash.data.*;
I tried initializing the statement below. it give me the error on creating the second table. Do I have to use other API so that
private function db_opened(e:SQLEvent):void {
sqls.sqlConnection = sqlc;
sqls.text = "CREATE TABLE IF NOT EXISTS test_table ( id INTEGER PRIMARY KEY AUTOINCREMENT, first_name TEXT, last_name TEXT);";
sqls.execute();
[Code] .....
ERROR
Error: Error #3106: Property cannot be changed while SQLStatement.executing is true.
at Error$/throwError()
at flash.data::SQLStatement/set text()
View 1 Replies
Similar Posts:
Sep 18, 2011
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;
View 1 Replies
Sep 26, 2011
Here is the issue: a client wants his entire equipment inventory accessible by persons navigating to his jquery mobile site. The inventory that exists on the desktop site was, as I understood, built with Flex. Is it possible to access this database for the jquery mobile site? I believe it is. I was then given this information from someone in the know:
Database:
mlxx.db.xxxxxxx.hostedresource.com
login: mxxx
[code]...
View 1 Replies
Oct 26, 2011
I have a flash project that connect with a server. I get all data from the server as raw tables as XML. So I have to do the server logics client side. (Don't ask why!)
I have looked for a framework or some code base that have solved this. A framework that can do mapping of keys asf. Basically a frame work that stores the data and handles retrieving of the data like SQL.
Ie. I can get user with the userid without iterating through all the instances. This gets more complex when you have more id in the same table.
So is there a data framework for flash out there?
(the HTML 5 sqlLight would be great if more browsers supported it)
View 2 Replies
Jul 24, 2010
I am trying to save the information for a layout of movie clips on my stage. I am using the sqlite functionality in order to be able to save the layout to the local database. Each layout consists of several movie clips. My plan was to store pertinent information regarding these movie clips (such as x and y position) in order to be able to reload some new clips in the exact same place.
My problem here is that I want to create just one row in my database for each layout, but I want one column in that row to store the information for each of those clips (in a single row). Is there some kind of nested table functionality in sqlite?6564
View 2 Replies
Oct 7, 2009
I am trying to connect to database from the Adobe FLex AIR application.
Is it possible to connect to database(SQL Server / ORACLE) from Action script.
View 2 Replies
Jul 17, 2011
Can I build flash application that connects to database? (MySQL) For example: Photo Gallery that brings me the photos from database...
View 3 Replies
Feb 11, 2012
Case1: When a client makes a remoteObject request ie to save some Info... A call is made to Java SAVE_INFO method. If request failed ie came back to FaultHandler ( we save the info in an arrayCollection).Later we call SAVE_INFO again for each item in arrayCollection ie( if arrayCollection has 10 items.. We call 10 times the same method.. I know that's kind of stupid but we have no control over java to write a overloading method). Some times we see there are multiple records of same info in DB. I am not sure if this happens when looping over arraycollection and making calls or during normal one time call. We could not find a pattern to reproduce. Java LOG level is at Error level in production. can't set to INFO in production to monitor all calls. We dont know if this multiple times saved record is, the one in arrayCollection or normal one.
Flex3 RemoteObject --> WAS 6.1 , lCDS 3.0, Java1.5 --> Webservice -- > Java (hibernate) --> Oracle 10gCase2: When application is left open and user leaves for the day and submits info the following morning, we see duplicate records in DB of that info.(No arrayCollection here. Simple straight one call)Flex3 RemoteObject --> OC4J Blazeds Java1.5 (JDBC) --> Oracle 10g.Recently one of our Testers testing case 2 application found this pattern and I am starting to think that may be in the case 1 also.. users might be leaving for lunch/break and resubmitted the arrayCollection after coming back. During lunch java might have killed the sessions for the client and after resubmitting 10 at same time.
View 1 Replies
Apr 27, 2011
I've been looking for some examples on creating a custom statusbar for an AIR application, but haven't found anything really useful. That was until I started looking around in the Tour de Flex AIR app for an example, and it was right there (part of the app itself). Would anyone have some suggestions on replicating this statusbar. The trouble I'm having is that I cannot seem to get the value of a dynamic variable to display. I'm attempting to display the current user.
View 2 Replies
Jul 9, 2011
I am working on a game in flex, and I am trying to figure out how to create menus in the game. I am was thinking it would be easy just to add and remove a child for the menu, but then it would be a pain to make interactive.I am trying to do both a pop up menu and an always on screen menu, like a bottom menu bar, so if anyone has any ideas please let me know. I am completely new to flash and flex and don't really know where to start past making the actual game.
View 2 Replies
May 5, 2011
I will create a voice chat application with Adobe Flex and I want use the opensource Red5 as a server.But, I confuse how to start it. it's possible just use NetStream and NetConnection?
View 1 Replies
Nov 28, 2009
How to create multiple processes in Adobe Air program? Docs? Tuts? Algorithms? (for ex I have some design logic and some services client logic i want to run them in separate processes) (Air 2.0 is ok for me)
View 4 Replies
Feb 17, 2010
I am trying to figure out the best way for doing spellcheck in flex application. I need a support of multiple languages, like: english, russian and so on. Also, I don't need a realtime spellchecking, only in some particular moment(for example, user click button: "check my text"). I found clientside solution here - flex:SpellCheck , but looks like it able to check only english text. So now I am thinking serverside solution, that recieve a text and needed language, check it(for example with aspell) and returns result. How do you think: is this a good way or I am missing something?
View 1 Replies
Jun 5, 2010
How to be able to start up same Adobe Air applications multiple times? How to make it to my app?
View 1 Replies
Feb 9, 2011
This is more of a database design issue but almost everybody here uses database integration with their apps so I feel it is important. I am integrating AS3 + mysql + php and need to clear up the database design for multiple students results in various activities. Developing an online e-learning course with a "dashboard" or teacher control panel with all kids results in each activity. I have read the database design rules by Codd etc... understand the need for parent and child tables so information is relational and not duplicated etc... BUT I am not sure how to design the results part. Various students do various lessons with 10 activities which each give a mark out of ten. The table would be updating every few seconds as 10,000 users would be online at the same time
1. Would I create a results table with all the students results going in the same table ie: Tom would be the first row
[Code]....
View 5 Replies
Mar 30, 2011
Im currently creating a list in Adobe Flex/Actionscript for a person search app. At the moment, the list shows 1 line of text:
<fx:Script>
<![CDATA[
import model.PersonSummary;
[Code].....
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
Jun 7, 2010
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything. So, my issue is this. I have a mySQL database hosted I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.Here is my licenseTracker.mxml
<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark"
[code]....
View 9 Replies
Aug 31, 2011
I have updated the mxml code to only show the needed code for the program to run the update.
I am new to Flex and have an issue I hope you all can help me out with.
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything.
So, my issue is this. I have a mySQL database hosted on 000webhost.com, I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.
Here is my licenseTracker.mxml
<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark"
[Code].....
View 1 Replies
Nov 14, 2011
1) Can Adobe Air Database create more than 1 table in the DB?will it work by just executing two create table statement work?[code]
2) How can i do SQL indexing for a table in a database?[code]Will this work for indexing?
3) If all the above work, how to i check if the database is implementing the above?
View 1 Replies
Aug 25, 2009
I actually wanted to create an itemrenderer which will contain below code :
<mx:HBox xmlns:mx="[URL]" width="0" height="0" >
<mx:Label text="{data.xval}" />
<mx:Spacer width="100%" />
<mx:Image source="edit.gif" width="16" toolTip="Edit" />
</mx:HBox>
Now when I click on the image datgrid column should be editable, for that I am using a textinput as an itemeditor. Now I also want to highlight all those cell for this datagrid column which are having data more than 8 characters. I am able to do this separately using 2 different itemrenderers. But I want to get this all together. Can we have multiple itemrenderer for any datagrid column?
View 1 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
Apr 21, 2011
Is it possible to install a SQLite database that is readable and writable by all users on a computer (windows or mac)?As far as I've seen in the API docs the only folders I can read/write access to are local to the specific user of the computer.
View 1 Replies
Sep 7, 2010
I want to know can we use access's database to work with flash or adobe air?
and if u have any sample of a database which work with air or flash in local
View 1 Replies
Jan 11, 2010
I am planning to develop a standalone application, which infact will be used for personal purposes. So only single user access may be there. I want to develop it in Flex. Just want some opinions from the gurus over here : Whether i should use Flex or AIR (I know only Flex, AIR i need to start learning)Which database i should use? SQLLite or HSQLDB or some other.
View 3 Replies
Jul 17, 2011
Short explanation:->>>So. I have an xml with this:
[CODE]<apps>
<cls id="1" name="CustomClass01"/>
<cls id="..." name="..."/>
[code]....
View 5 Replies
Mar 21, 2011
Multiple axis creation via MXML works fine:
http:[url]...
But when I'm trying dynamically create horizontal and vertical axis then I'm getting extra axes. I believe this is Adobe bug. How I can fix this behavior?
<?xml version="1.0" encoding="utf-8"?>
<s:Application
minHeight="600"[code].....
View 2 Replies
Jul 17, 2011
Short explanation:->>>So. I have an xml with this:
Code:
<apps>
<app id="1" name="CustomClass01"/>
[code]......
View 2 Replies
Dec 14, 2011
I am writing a large flex app that has to connect to a database many times. I currently am using asp pages to connect, but I would like to use the most efficient option. What do you think is the best way to connect to a database from a flex app?
View 1 Replies
Jul 20, 2011
I would like to create a database and read/write data via actionscript3. I'm an absolute beginner in this field, where do I have to start?
View 9 Replies