silent fail of revDataFromQuery() in standalone; works in IDE

2014-05-23 Thread Dr. Hawkins
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 clientName

Re: silent fail of revDataFromQuery() in standalone; works in IDE

2014-05-23 Thread Matthias Rebbe | M-R-D
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 m

Re: silent fail of revDataFromQuery() in standalone; works in IDE

2014-05-23 Thread Dr. Hawkins
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

Re: silent fail of revDataFromQuery() in standalone; works in IDE

2014-05-24 Thread Peter Haworth
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" wrote: > Th

Re: silent fail of revDataFromQuery() in standalone; works in IDE

2014-05-24 Thread Pierre Sahores
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 exp

Re: silent fail of revDataFromQuery() in standalone; works in IDE

2014-05-24 Thread Mike Bonner
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, Pi

Re: silent fail of revDataFromQuery() in standalone; works in IDE

2014-05-24 Thread Dr. Hawkins
On Sat, May 24, 2014 at 1:08 AM, Peter Haworth 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 hav

Re: silent fail of revDataFromQuery() in standalone; works in IDE

2014-05-24 Thread Matthias Rebbe | M-R-D
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

Re: silent fail of revDataFromQuery() in standalone; works in IDE

2014-05-25 Thread Dr. Hawkins
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.