SQLite problem on iOS Simulator

[Klaus major-k]

Hi all,

of course I need to check "SQLIte" on the "iOS" tab in the standalone builder settings! 8-)

Am 06.07.2014 um 16:46 schrieb Klaus major-k <klaus at major-k.de>:

> Hi friends,
> 
> strange problem when using SQLite in the iOS Simulator.
> LC 6.6.2, XCode 5.1, Simulator iOS 7.1
> 
> Database file copied to specialfolderpath("documents")
> 
> In general all database access runs fine, but there is one handler where CONSOLE 
> outputs an script error, found out by using a TRY structure.
> Not to mention that this runs fine on the desktop!?
> 
> This function:
> ##########################################
> function db_getPickContent tTable
>   put numtochar(1) into tRowDel
>   put numtochar(2) into tLineDel
>   put db_id() into tDBID
> 
>   put "SELECT name,id FROM" && tTable into tSQL
>   try
>      put revDataFromQuery(tRowDel,tLineDel,tDBID,tSQL) into tRetValue  
>   catch ernum
>      put ernum
>   end try
>   return db_pickcontent2array(tRetValue)
> end db_getPickContent
> ###########################################
> 
> ALWAYS outputs this errorcode: 219,488,11,revDataFromQuery 
> 219 = error in function handler and points to the "revDatafromquery" function 
> on line 488 of my script!? So the "revDatafromquery" never gets executed!
> 
> I am clueless, any hints very welcome!
> Or are there problems in general with SQLite in the simulator?
> Do not have a real device to test.
> 
> Thanks a lot in advance!

Best

Klaus

--
Klaus Major
http://www.major-k.de
klaus at major-k.de