SQLite problem on iOS Simulator

Klaus major-k klaus at major-k.de
Sun Jul 6 10:46:35 EDT 2014


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





More information about the use-livecode mailing list