Flash :: #3115 Error When Retrieving Data From SQLite Database
Oct 4, 2011
I have this little piece of code to retrieve data from a local SQLite database (to an AIR app):
import flash.filesystem.File;
import flash.data.SQLConnection;
import flash.data.SQLStatement;
[Code]....
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:
SQLError: 'Error #3115: SQL Error.', details:'no such table: 'background'', operation:'execute', detailID:'2013'
I created a basic db with a Firefox extension (SQLiteManager). What can cause this error? The table exists!
View 1 Replies
Similar Posts:
Apr 28, 2011
What I am trying to do is open a database in async mode and get some data from my database. To do I wrote this code down below:
[Code]...
My startstmt is a global SqlStatement variable. When I tested in Sqlite Manager it works fine this query but in adobe-air i am getting this error. Where did i do wrong and how can I solve this?
View 1 Replies
Oct 20, 2011
"SELECT * FROM locations JOIN section_has_location ON locations.location_id = section_has_location.location_id WHERE section_has_location.chapter_id =2 AND section_has_location.section_id=2"
I get the error:
SQLError: 'Error #3132: Data type mismatch.', details:'could not convert text value to numeric value.', operation:'execute', detailID:'2300'
[Code]...
How do I fix the query as to not cause the error? update: I exported all the data, and imported into a new clean database. This seems to have solved that error.
View 1 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
Apr 11, 2012
i'm making a mobile app with flash builder but i stumble upon an error. In short terms, you put a text in a text input, u click a button and it only lists the things from the database with that imputted text in it. Here are the codes:
'
First the Homeview.mxml:
<?xml version="1.0" encoding="utf-8"?>
<s:View xmlns:fx="http://ns.adobe.com/mxml/2009" [code]......
View 1 Replies
Jan 12, 2011
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?
View 1 Replies
May 13, 2010
just create database with SQLite Database Browser 2.0 b1 after creating the data base when i tried connect it in flash cs4-with air 1.1 its showing me error SQLError: 'Error #3115: SQL Error.', details:'no such table: 'contact'', operation:'execute', detailID:'2013' i tried to found every where but did not get the solution of this
[Code]...
View 0 Replies
Jan 10, 2012
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).
View 1 Replies
Nov 29, 2009
I am trying to establish a connection between my swf and a database using PHP. I keep getting the following error:
Error: Error #2101: The String passed to URLVariables.decode() must be a URL-encoded query string containing name/value pairs.
at Error$/throwError()
[code].....
View 2 Replies
Dec 14, 2009
I am having issues getting Flash to connect to a SQL 2000 Database. I keep getting an error with flash.data.*.The code is :
import flash.data.*
I receive the following error:
1172: Definition flash.data could not be found.
View 1 Replies
Nov 9, 2010
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?
View 4 Replies
Nov 16, 2010
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 ?
View 2 Replies
Dec 13, 2010
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).
[Code]....
View 1 Replies
Aug 30, 2010
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?
View 0 Replies
Feb 4, 2010
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.
View 2 Replies
Aug 26, 2010
How can I create and use an encrypted SQLite database for an AIR application, please?
View 1 Replies
Apr 26, 2011
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?
View 3 Replies
Jan 14, 2012
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.
View 2 Replies
Feb 2, 2012
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:
sqlStatement.text = "INSERT INTO users (First_Name, Last_Name) VALUES (" + Main._firstName + ", 'Doe')";
it inserts it as "null Doe".
View 1 Replies
Feb 27, 2011
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);
[Code].....
View 1 Replies
Feb 14, 2012
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...
View 2 Replies
Apr 2, 2012
Is it possible to open an sqlite file over http? I only need to read the db, and was hoping I could do something like:
var dbFile:File = new File("http://10.1.1.50/project/db.sqlite");
sqlConnection.open(dbFile);
Error #3125: Unable to open the database file.', details:'Connection closed.', operation:'open', detailID:'1001'
My situation calls for several apps compiled for various devices to share this file, which is served locally via wamp.
View 1 Replies
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
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:
<mx:TextInput x="50" y="10" width="117" id="user_name"/>
<mx:TextInput x="50" y="10" width="117" id="password"/>
Now i want to insert values into the table like:
sqls.text = "INSERT INTO testt_table (user_name, password,fileurl) VALUES('"+user_name.text+"','"+password.text+"',fi leUrl);";
but its giving errors.How can I enter the url or path of the file chosen into the table.
View 0 Replies
Jul 16, 2011
im having some problems trying to read a SQlite data base from flash using AS3. The data base was created with this php script:
[Code]....
As you can see, this creates a database like this: After this i need to read this database in AS3, using this very simple script:
[Code]...
View 2 Replies
Mar 23, 2011
I'm developing a flex application that displays a list of images along with some metadataThe images are less than 500kb. They are stored in the database as base64 encoded stringsretrieved using PHP, send over to flex as XML (which creates a fairly large XML output file)Now my problem is that, while I can display upto 2-3 images easily, anything more than 3 or sometimes 2 images will cause the images to be corrupt. Sometimes the whole app fails.I am guessing this is due to the large size of the generated XML. I know I am doing something wrong here. I want to know what is the proper method for storing/retrieving a lot of images in a flex application.
View 2 Replies
Nov 26, 2009
How do i save an array of objects, like this: [{n:1,bb:4},{n:2,bb:4,r:1},{n:6,bb:7},...] to a database? I was thinking i would have to convert it to string, but if i do that, when i retrieve it from the database, how am i going to use it?
EDIT: forgot to mention that the objects can contain an array of objects as well, but there won't be any more arrays beyond that point.
[{n:1,bb:4},{n:2,bb:4,r:1},{n:6,bb:7},{arr:[{a:11,b:2},{a:11,b:2},...],r:1},...]
View 2 Replies
Jun 1, 2009
I have a page, written in php that recives and ID value for Album information stored in an XML file. The XML File contains a links to "Samples": I'm trying to get my flash file to "retrive" the data (the ID value) from the php page (the flash file will be embedded), and make a list of samples that can be played. A sorta of an Audioplayer. I already know how to retrive XML data, but the retrival of the ID value from the PHP is a puzzle for me...
View 5 Replies
Sep 8, 2008
I am working on a flash movie for a client and I have not used flash much before at all. I have the object/embed code here below with the following src path sos.swf?wID=5. I need that wID so when I load certain variables from a php page later on in the movie I can access that persons information (wID correspons to the primary table key).
HTML Code:
<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="[URL]" WIDTH="383" HEIGHT="180" id="myMovieName">
<PARAM NAME=movie VALUE="sos.swf?wID=5">
<PARAM NAME=quality VALUE=high>
<PARAM NAME=bgcolor VALUE=#FFFFFF>
[Code] .....
I have tried several things and I am not sure just how to access the flash URL variables. To make sure I am putting the action script in the right place I have only one layer, and when I click on that, I enter the actionscript in the actionscript window for that layer. Is that the correct place to put it? I am pretty sure it is but I just want to double check. The variables.text at the bottom are my dynamic text boxes that are displaying information from the sos.php file. Nothing is showing up in my movie and I am unaware of good debugging techniques for actionscript. I have tried to trace(widgetID); but nothing shows up in my movie. I am not sure if that is because of the image I have on the screen or what.
By the way here is the part in my php script that sends the variables over. They do have data in them but nothing is being displayed in the dynamic text boxes.
PHP Code:
$vars = "&firstname=".$name."&years=".$totalYears."&months=".$totalMonths."&days=".$totalDays."&minutes=".$totalMinutes."&meals=".$var_meals."&meetings=".$var_meetings."&movies=".$var_movies;echo $vars;
View 6 Replies
Feb 16, 2009
Can anyone help me with getting a message that is said in flash (like a game) go to a mysql database?
View 2 Replies
