SQLite problem on iOS Simulator

[Peter Haworth]

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 <klaus at 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
> klaus at major-k.de
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>