As far as I recall, there is some advice in the documentation to copy any database files to one of the users directories (such as application preference directory, for instance) if you are going to be writing to them. The reason being that certain operating systems (e.g. Vista) won't allow write access to files in the application directory.
I'd hazard a guess that this is the cause of the problem in your application. You should be ok if you're just retrieving values I should think, I use a database in the app directory for read only access just fine. However, I do specifically open it read only, it's possible that opening it for read/write just fails and you don't see any errors in the release player. I guess you could do a try/catch on it and alert an error message (or just package and install a debug version for testing, perhaps) -----Original Message----- From: flexcoders@yahoogroups.com on behalf of * Khairunnisa' * Sent: Thu 17/07/2008 14:41 To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] SQlite database and Vista User Account Both yes. The database is in the application directory - Once installed in Windows, it will be under Program Files >App Folder - together with the application. The application performs normal database actions such as retrieving and writing to the database. Retrieval returns blank while writing to database looks as if it's not performing anything. Does it got to do relative path to the database? but it be absolute? or is it really because of User Account Control present in Vista? To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Thu, 17 Jul 2008 14:04:52 +0100Subject: RE: [flexcoders] SQlite database and Vista User Account Is your database file in the application directory, and is the application writing to it?-----Original Message-----From: flexcoders@yahoogroups.com on behalf of KhairunnisaSent: Thu 17/07/2008 11:37To: [EMAIL PROTECTED]: [flexcoders] SQlite database and Vista User AccountI managed to run my AIR Desktop Application on Windows Vista Businesssuccessfully but not my client (who is running on the same platform).Even though he managed to run the application, dynamic data fromSQLite embedded in the application does not appear.ie, no dynamic dataappeared in the list or forms.I checked for his settings and realized that his User Account Controlis on while mine is turned off.When I turned on my User Account, the same thing happened to me -dynamic data doesn't appear.Is there any way to solve this problem without turning off the UserAccount Control in Vista?Yours, Nisa__________________________________________________________This communication is from Primal Pictures Ltd., a company registered in England and Wales with registration No. 02622298 and registered office: 4th Floor, Tennyson House, 159-165 Great Portland Street, London, W1W 5PA, UK. VAT registration No. 648874577.This e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient. If you have received it in error, please contact the sender immediately by return e-mail or by telephoning +44(0)20 7637 1010. Please then delete the e-mail and do not disclose its contents to any person.This email has been scanned for Primal Pictures by the MessageLabs Email Security System.__________________________________________________________ ______________________________________________________________________ This communication is from Primal Pictures Ltd., a company registered in England and Wales with registration No. 02622298 and registered office: 4th Floor, Tennyson House, 159-165 Great Portland Street, London, W1W 5PA, UK. VAT registration No. 648874577. This e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient. If you have received it in error, please contact the sender immediately by return e-mail or by telephoning +44(0)20 7637 1010. Please then delete the e-mail and do not disclose its contents to any person. This email has been scanned for Primal Pictures by the MessageLabs Email Security System. ______________________________________________________________________
<<winmail.dat>>