Hi James, I haven't seen that error but I have successfully loaded and used an SQLite extension. The extension is available at http://www.monkeybreadsoftware.de/SQLiteExtension/ and has a bunch of new string and math functions in it. It's not free but has a demo version.
The only difference between your code and mine is that I use revDataFromQuery rather than revExecuteSQL. I know that you get a "revdberror" back from that if there's something wrong with the load_extension call - I had a typo in the filename initially which resulted in an error. Also, the error message is curious since it says it's a compile error, but you got it at runtime. Could it be an issue with whatever extension you are trying to load? Pete 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, Mar 30, 2014 at 8:02 PM, James Hale <ja...@thehales.id.au> wrote: > Hi, > > I am starting to get this error when running my scripts: > compile error "rotate: error in angle description" > > Which if I was doing anything remotely graphical I could perhaps > understand. > But I am not doing anything to do with angles or rotation. > > The most recent example of getting this error was with the following > handler: > > On loadextension > Put getDatabaseID() into tDatabaseID > put specialfolderpath("documents")&"/sqlite test/okapi_bm25.sqlext" into > the_extension > put "SELECT load_extension('"&the_extension&"')" into tSQL > revExecuteSQL tDatabaseID, tSQL > End loadextension > > Stepping through the handler the error only comes up on executing the > "revExecuteSQL" command. > > I connected with the database using the new syntax enabling the loading of > extensions yet it does seem as if the database call is having some > difficulty. > > Two questions I guess. > 1. Anyone had this error message when not doing anything with rotations? > If so, did you discover what it meant? > > 2. anyone had luck on loading extensions to SQLite? > > Perplexed, > > James > _______________________________________________ > 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