SQLConnection.attach() fails when file path contains apostrophe

hello,

 

any on appreciated. issue occurs when user has apostrophe in windows username , therefore apostrophe in file.applicationstoragedirectory path.

 

e.g. if user logs windows j.o'reilly, be:

c:\documents , settings\j.o'reilly\application data\application name\local store

 

have tried air runtimes: 2.5.0.16600,2.6.0.19120,3.2.2070

have tried air sdks: 2.0, 2.7, 4.5

 

to replicate without creating windows user apostrophe, same result occurs if files named apostrophe:

 

var __connection:sqlconnection;

__connection = new sqlconnection();

__connection.open( file.applicationstoragedirectory.resolvepath("mainfile.s3db"), sqlmode.update );

__connection.attach( "secondary", file.applicationstoragedirectory.resolvepath("user'name.s3db") );

 

 

result:

sqlerror: 'error #3125: unable open database file.', details:'near 'name': syntax error', operation:'attach', detailid:'2003'

    @ flash.data::sqlconnection/internalattach()

could please open new bug report on over @ bugbase.adobe.com?  please post url others affected can add comments , votes.

 

given has been around long, we'll need strong community support issue have chance @ being fixed.  there ways can work around in meantime?  can apostrophe escaped?

More discussions in AIR Bugs and Performance Issues

adobe