RE: [flexcoders] sqlite database physical path?

[Jim Hayes]

File.applicationStorageDirectory will be somewhere in your "Documents and 
settings" directory and will be user and application specific.

try trace(File.applicationStorageDirectory.nativePath) to see where it is for 
your app.

>How to do this if I want to create the sqlite in the following path 
>c:\db\sqlite1.db.

var dbFile:File =  new File("c:\\db\\sqlite1.db"). Note that you need to escape 
the backslashes in the string (\\ rather than \)

you might want to check that c:\db exists first, I have no idea whether the 
sqlite code will create folders for you in addition to the db file.


-----Original Message-----
From: flexcoders@yahoogroups.com on behalf of markflex2007
Sent: Mon 25/08/2008 15:21
To: flexcoders@yahoogroups.com
Subject: [flexcoders] sqlite database physical path?
 
Hi,

I have a question for the sqlite physical path.

for instance

 var dbFile:File =
File.applicationStorageDirectory.resolvePath("Sqlite1.db");  
        if(dbFile.exists) { 
          conn.addEventListener(SQLEvent.OPEN, openHandler);  
        } else {
          conn.addEventListener(SQLEvent.OPEN, createHandler);
        }
        conn.open(dbFile);

I can not see the Sqlite1.db in c:\

How to do this if I want to create the sqlite in the following path
c:\db\sqlite1.db.

I get error when I try :

 var dbFile:File =
File.applicationStorageDirectory.resolvePath("c:\db\Sqlite1.db");

Thanks

Mark





______________________________________________________________________
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>>