Have you checked the contents of tDBID? I don;t see it as a a parameter to your function.
Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Sun, Jul 6, 2014 at 7:46 AM, Klaus major-k <kl...@major-k.de> wrote: > 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 > kl...@major-k.de > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
