Re: silent fail of revDataFromQuery() in standalone; works in IDE
Richard, what does the function revOpenDatabase return? Is that function really successfully executed? Do you have any other handler in your script which traps the activity of the standalone builder and might prevent it to create a standalone with all needed information As i wrote before i ran into a similar problem (with 5.5.4 and 6.x) not with 4.6. A missing pass savestackrequest prevented the standalonebuilder to create a full functioning app. My standalone contained all database externals/drivers, but did not do any db communication. Even a manual selection of the inclusions did not help. But the following steps helped me to create the standalone even with my faulty script. Maybe you try the following. Just 2 minutes, but worth trying. In standalone Application Settings 1. select the select inclusions for the standalone application 2. select now manually what is needed for you applicaition 3. now DESELECT the sqlite and any other db selection in the field under Database support, but LEAVE Database support checked. 4. create again a standalone 5. copy the needed db drivers to the newly created standalone. 6. now try the standalone. If your app is running now then there could be something in your scripts what prevents the standalone builder to successfully complete the build of the standalone. Regards, Matthias Am 24.05.2014 um 02:57 schrieb Dr. Hawkins doch...@gmail.com: On Fri, May 23, 2014 at 3:50 PM, Matthias Rebbe | M-R-D matthias_livecode_150...@m-r-d.de wrote: Is it possible that you have a SaveStackRequest handler in your card or stack script? And if so, could you check if maybe the line pass savestackrequest in that handler is missing? Nope. Only just learned of it in this message :) In a script of hundreds of lines, it hits that line, executes the line before revDataFromQuery(), and never reaches the line after (where I could test the result!) Oh, and I'm usually using 5.5.4, but confirmed on 6.5.1 as well. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ 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
Re: silent fail of revDataFromQuery() in standalone; works in IDE
On Sat, May 24, 2014 at 11:25 PM, Matthias Rebbe | M-R-D matthias_livecode_150...@m-r-d.de wrote: what does the function revOpenDatabase return? Is that function really successfully executed? Normally, on successful execution, it would return empty, and an error message if unsuccessful. Do you have any other handler in your script which traps the activity of the standalone builder and might prevent it to create a standalone with all needed information No; it wasn't that. It turned out that an array wasn't being filled in time (but was built early in the IDE for a coherency check and to set static values). Because it wasn't set, opening the cache db returned an untrapped error, and the variable holding the db number was empty. So empty was passed to the revDataBaseQuery() call--which triggered an error causing no message, but the immediate silent exit of the calling handler. Putting it into a try/catch gave me some info (not really what I needed), but let me look and see the database number variable wasn't set. Thanks to all. And trap *every* database call for errors! -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ 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
Re: silent fail of revDataFromQuery() in standalone; works in IDE
What do you get in theRes when it works? CREATE shouldn't return any data. I always use revExecuteSQL for any SQL statement other than SELECT, although if revDataFromQuery works in the IDE it should work in the standalone. Pete lcSQL Software On May 23, 2014 11:33 PM, Dr. Hawkins doch...@gmail.com wrote: This section of code has worked for quite some time. Now, it's failing in standalones, but works just fine in the ide. I already have an in-memory SQLite database open at cacheDb. The ck command just puts to the message box and after a log window. dcmd is shown as dcmd: CREATE TABLE clientNameRemoved_001_dinfo (kywd VARCHAR(20), dTyp CHAR(1), usr VARCHAR(20), tstmp TEXT, val TEXT, dfl TEXT, dvl INTEGER, ddf INTEGER, dta TEXT, ch BOOLEAN, UNIQUE(kywd) ) ; For the code ck dcmd: dcmd put revDataFromQuery(,,cacheDb,dcmd) into theRes answer theRes: theRes I get to the answer in the IDE, with a table created successfully. In a standalone, though, the answer command is not reached, and the handler exits silently. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ 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
Re: silent fail of revDataFromQuery() in standalone; works in IDE
Hi Richard, I don’t know how the below value are set in LC-Server preferences (PHP values shown below) : max_execution_time 30 30 max_file_uploads20 20 max_input_nesting_level 64 64 max_input_time 60 60 max_input_vars 10001000 memory_limit64M but i expect your script could die because it reaches one of the corresponding ones. HTH, Pierre Le 24 mai 2014 à 02:57, Dr. Hawkins doch...@gmail.com a écrit : On Fri, May 23, 2014 at 3:50 PM, Matthias Rebbe | M-R-D matthias_livecode_150...@m-r-d.de wrote: Is it possible that you have a SaveStackRequest handler in your card or stack script? And if so, could you check if maybe the line pass savestackrequest in that handler is missing? Nope. Only just learned of it in this message :) In a script of hundreds of lines, it hits that line, executes the line before revDataFromQuery(), and never reaches the line after (where I could test the result!) Oh, and I'm usually using 5.5.4, but confirmed on 6.5.1 as well. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ 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 -- Pierre Sahores mobile : 06 03 95 77 70 www.sahores-conseil.com ___ 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
Re: silent fail of revDataFromQuery() in standalone; works in IDE
I wonder if the compiler is for some reason not including the sqlite driver. MIght look at the standalone settings and manually include the sqlite drivers and rebuild. Or put a try/catch around the revdatafromquery and see if you can get an error message out. On Sat, May 24, 2014 at 2:23 AM, Pierre Sahores s...@sahores-conseil.comwrote: Hi Richard, I don’t know how the below value are set in LC-Server preferences (PHP values shown below) : max_execution_time 30 30 max_file_uploads20 20 max_input_nesting_level 64 64 max_input_time 60 60 max_input_vars 10001000 memory_limit64M but i expect your script could die because it reaches one of the corresponding ones. HTH, Pierre Le 24 mai 2014 à 02:57, Dr. Hawkins doch...@gmail.com a écrit : On Fri, May 23, 2014 at 3:50 PM, Matthias Rebbe | M-R-D matthias_livecode_150...@m-r-d.de wrote: Is it possible that you have a SaveStackRequest handler in your card or stack script? And if so, could you check if maybe the line pass savestackrequest in that handler is missing? Nope. Only just learned of it in this message :) In a script of hundreds of lines, it hits that line, executes the line before revDataFromQuery(), and never reaches the line after (where I could test the result!) Oh, and I'm usually using 5.5.4, but confirmed on 6.5.1 as well. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ 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 -- Pierre Sahores mobile : 06 03 95 77 70 www.sahores-conseil.com ___ 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
Re: silent fail of revDataFromQuery() in standalone; works in IDE
On Sat, May 24, 2014 at 1:08 AM, Peter Haworth p...@lcsql.com wrote: What do you get in theRes when it works? CREATE shouldn't return any data. empty, unless there's an error I always use revExecuteSQL for any SQL statement other than SELECT, I've found it easier to just use the one form. I also have a process/wrapper that I use for non-memory commands. although if revDataFromQuery works in the IDE it should work in the standalone. It has for two years . . . I On Sat, May 24, 2014 at 1:23 AM, Pierre Sahores s...@sahores-conseil.comwrote: I don’t know how the below value are set in LC-Server preferences (PHP values shown below) : max_execution_time 30 30 ... but i expect your script could die because it reaches one of the corresponding Creating a simple table in an in memory database? That can only be a few milliseconds, if that. On Sat, May 24, 2014 at 7:17 AM, Mike Bonner bonnm...@gmail.com wrote: I wonder if the compiler is for some reason not including the sqlite driver. It's already opened the databases a this point, though. MIght look at the standalone settings and manually include the sqlite drivers and rebuild. Or put a try/catch around the revdatafromquery and see if you can get an error message out. try/catch set me on the trail. the database for the cacheDb wasn't a number. And by backtracing down about three levels (put in ck points, compile run, repeat), I finally found the culprit. I have a test for whether it's in the IDE or not, and the IDE branch was building an array to measure heights--so when I moved the normal place to build it . . . But I still don't think that bombing out in a funciton with no error message returned is acceptable . . . -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ 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
silent fail of revDataFromQuery() in standalone; works in IDE
This section of code has worked for quite some time. Now, it's failing in standalones, but works just fine in the ide. I already have an in-memory SQLite database open at cacheDb. The ck command just puts to the message box and after a log window. dcmd is shown as dcmd: CREATE TABLE clientNameRemoved_001_dinfo (kywd VARCHAR(20), dTyp CHAR(1), usr VARCHAR(20), tstmp TEXT, val TEXT, dfl TEXT, dvl INTEGER, ddf INTEGER, dta TEXT, ch BOOLEAN, UNIQUE(kywd) ) ; For the code ck dcmd: dcmd put revDataFromQuery(,,cacheDb,dcmd) into theRes answer theRes: theRes I get to the answer in the IDE, with a table created successfully. In a standalone, though, the answer command is not reached, and the handler exits silently. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ 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
Re: silent fail of revDataFromQuery() in standalone; works in IDE
Is it possible that you have a SaveStackRequest handler in your card or stack script? And if so, could you check if maybe the line pass savestackrequest in that handler is missing? I ran into this some time ago. I had a savestackrequest handler without the line pass savestackrequest. This missing line caused exact the same error you are describing. Regards, Matthias Am 24.05.2014 um 00:33 schrieb Dr. Hawkins doch...@gmail.com: This section of code has worked for quite some time. Now, it's failing in standalones, but works just fine in the ide. I already have an in-memory SQLite database open at cacheDb. The ck command just puts to the message box and after a log window. dcmd is shown as dcmd: CREATE TABLE clientNameRemoved_001_dinfo (kywd VARCHAR(20), dTyp CHAR(1), usr VARCHAR(20), tstmp TEXT, val TEXT, dfl TEXT, dvl INTEGER, ddf INTEGER, dta TEXT, ch BOOLEAN, UNIQUE(kywd) ) ; For the code ck dcmd: dcmd put revDataFromQuery(,,cacheDb,dcmd) into theRes answer theRes: theRes I get to the answer in the IDE, with a table created successfully. In a standalone, though, the answer command is not reached, and the handler exits silently. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ 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
Re: silent fail of revDataFromQuery() in standalone; works in IDE
On Fri, May 23, 2014 at 3:50 PM, Matthias Rebbe | M-R-D matthias_livecode_150...@m-r-d.de wrote: Is it possible that you have a SaveStackRequest handler in your card or stack script? And if so, could you check if maybe the line pass savestackrequest in that handler is missing? Nope. Only just learned of it in this message :) In a script of hundreds of lines, it hits that line, executes the line before revDataFromQuery(), and never reaches the line after (where I could test the result!) Oh, and I'm usually using 5.5.4, but confirmed on 6.5.1 as well. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ 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