How Does Working With SQLite Databases Work In Flex 4.5.1 For Mobile Applications
Jun 26, 2011
How does working with SQLite databases work in Flex 4.5.1 for Mobile applications,I'm looking to create a general class that I can reuse. For now I only want it to handle queries and return results or fault events.Also, I am unsure if I should be using Synchronous or Asynchronous connections for mobile devices.
First off I am new to using Flex, but I have pieced this app together with help from online tutorials and information. Basically my app is like a directory of names, addresses and so forth, but I also have additional fields of "week" and "day". What I am trying to do is have a list that shows only the names of, for example Week 1 - Monday. Below is some of the code I am using to help you understand what I am trying to do.
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 have two mobile devices on a local network, A and B. I would ideally like A to be able call functions on B, returning a response to A.
I am aware of LocalConnection, but unfortunately this isn't supported on mobile. What is the best way to achieve this? Do I have to setup B as a server using BlaseDS?
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 realize this is probably a simple question but my google-fu is failing me. I would like to get a windows explorer like file browser to popup when I click a button to select images to upload to my AIR application.However I cannot find a component that handles File exploring. Does anyone know what to use?
I have some basic as3 knowledge and I have built 2 apps. in as3 but I want to use them for mobile systems as I guess for symbians.Which program should I use. I searched here flash lite but there is no forum about it. Ä°s there any other forum to help me learn flash mobile appliĆcations
i've got a few fonts embedded and am using them in my mobile application, and they are all working, except for the ones i try to use for the "ActionBar". They work everywhere else, and substituting "Comic Sans MS" for "titleCGF" changes it to Comic Sans. So why won't it work with my custom fontFamily?
I'm trying to use a SharedObject in a Flex 4.5 mobile project. The SDK I'm using is 4.5.1, and the AIR version is 2.6.0. I'm trying to locally store user credentials for my application using this piece of code:
I would like to move (right or left according the current view) between 2 views when I move my finger on the mobile screen; for example with Google+ mobile application, in profil section, you can change the view just on move your finger on the screen, and the offset and the moving speed must be checked before change complete view.
I'm creating a mobile app in which I need to show a calendar with months at the top. The months are part of a component that extends from SkinnableDataContainer (and has some custom scrolling/behaviour - which is why I did'nt use a spark list). I need the months to be shown as a 'trapezium' shaped tab and so I'm using a png image as a mask in the item renderer for the component.
When the mask is not applied, it all works well - the months render, the list/data container selection works when I click on a month and so on.When the mask is applied, it renders well, scrolling and everything else seems to work well - but when I click on a month, nothing happens visually. And from the trace statements in my code, it appears list item selection is not changing. Looks like mouse clicks are not working.
Code:
public class TopCalendarMonthRenderer extends LabelItemRenderer { [Embed(source="/assets/trapezium_alpha.png")] private static var TrapeziumMask:Class; private static var trapeziumMaskInstance:BitmapAsset;
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 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).
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'm trying to copy my SQLite file that is used in my Air app to user's selected directory using
var fileSaveDest:FileReference = new FileReference(); fileSaveDest.save(dbWorkedFile,'Inventory.DB'); dbWorkedFile is a File dbWorkedFile = File.documentsDirectory.resolvePath("Inventory.db");
I tried this but the saved file isn't a valid SQLite file. Also, I was wondering whether it's possible to embed SQLite to Air? If so how can I import and export the database?
I am going to make an Arabic application using Flex builder 4.5. I have two questions that need to be answered What is the difference between ActionScript Mobile Project and Flex Mobile Project. (AS Mobile Project supports iOS and Android but I doubt about it!!) Is Arabic support available in Flex Mobile Projects or AS Mobile Projects? I know TLF supports Desktop and web apps but does it support mobile platforms?
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'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.
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.