Correct path for sqlite database???

[paulsr]

Greetings:

Plz can someone help me discover what is wrong with the flwg code:

Code: Select all

put specialFolderPath("documents") into g_sfp_docs

put g_sfp_docs & "/airnews/sqlite/newsapp.sqlite" into t_sqlpath  

answer(t_sqlpath)
  
put revOpenDatabase("sqlite",t_sqlpath, , , ) into g_DBid
   
answer("g_DBid="&g_DBid)

I am running it on the iOS simulator. If works fine in any other environment.

The response to the first "answer" statement is:

/Users/paulr/Library/Application Support/iPhone Simulator/5.1/Applications/8202ED65-3120-4DB7-B3D9-953F2CADDAF0/Documents/airnews/sqlite/newsapp.sqlite

That's what I would expect, and newsapp.sqlite is at that location. It is owned by 'paulr' and has perms of 777.

The second "answer" statement is never reached and so produces no output.

I assume therefore there is an error in the "revOpenDatabase" statement, but as I say, it works if the environment is not mobile (and the database is in the expected documents area for that environment).

Have I put the sqlite database in the wrong place for iOS?

TIA...

--paul

[endernafi]

Hi Paul,

Could you try answer without parenthesis'?

Code: Select all

answer t_sqlpath
...
answer "g_DBid = " & gDBid

Regards,

~ Ender Nafi Elekçioğlu

[endernafi]

No, it wasn't that
But, I've found what's wrong
Please, go to Standalone Application Settings,
and be sure that this little box Sqlite is checked.
Here is an implementation:
http://cloud.keehuna.com/3O2p0Y0B2H3D

Regards,

~ Ender Nafi Elekçioğlu

[paulsr]

No, it wasn't that
But, I've found what's wrong
Please, go to Standalone Application Settings,
and be sure that this little box Sqlite is checked.
Here is an implementation:
http://cloud.keehuna.com/3O2p0Y0B2H3D

Regards,

~ Ender Nafi Elekçioğlu

Thanks so much for finding the solution. It's been driving me mad all day!

I had no idea the standalone settings were needed for the simulator!

It's early evening here, so I shall crack open a beer to celebrate.

Thanks again...

--paul

[endernafi]

Cheers