Re: sqlite ios pragma

2013-07-18 Thread Mike Kerner
I filed the bug report a day or so ago, but I have a feeling that it won't be a huge priority, but one can hope... On Thu, Jul 18, 2013 at 4:34 PM, Björnke von Gierke wrote: > ah too bad.. At this point i'd go and ask support, if runrev disabled > something or used a different driver version (o

Re: sqlite ios pragma

2013-07-18 Thread Björnke von Gierke
ah too bad.. At this point i'd go and ask support, if runrev disabled something or used a different driver version (or different compile), then they'll probably know why this doesn't work on iOS. Not that that would actually help right now, but maybe it's an easily fixable bug in the external?

Re: sqlite ios pragma

2013-07-18 Thread Mike Kerner
It works fine in the IDE/Mac/Windows, so when I took it over to iOS and it didn't work, I spent a couple of hours trying to debug other things before I found out that NONE of the PRAGMAs seem to work. On Thu, Jul 18, 2013 at 5:37 AM, Björnke von Gierke wrote: > No, you're on your own there. I'd

Re: sqlite ios pragma

2013-07-18 Thread Björnke von Gierke
No, you're on your own there. I'd think it weird to not work there tho. Did your code work in the ide? On 17.07.2013, at 19:46, Mike Kerner wrote: > I found out about this because I couldn't get PRAGMA to work in the > simulator when it works fine on the desktop. So, BvG, are you saying it > wo

Re: sqlite ios pragma

2013-07-17 Thread Mike Kerner
I found out about this because I couldn't get PRAGMA to work in the simulator when it works fine on the desktop. So, BvG, are you saying it works for you on iOS? On Wed, Jul 17, 2013 at 1:08 PM, Peter Haworth wrote: > Yes, saw them after I made my post, sorry. > > Pete > lcSQL Software

Re: sqlite ios pragma

2013-07-17 Thread Peter Haworth
Yes, saw them after I made my post, sorry. Pete lcSQL Software On Wed, Jul 17, 2013 at 9:05 AM, Mark Schonewille < m.schonewi...@economy-x-talk.com> wrote: > Hi Pete, > > Have you read my next post and Björnke's follow-up? > > -- > Best regards, > > Mark Schonewille > > E

RE: sqlite ios pragma

2013-07-17 Thread John Dixon
LOL... I think that Pete like the majority of us, is unable to read posts before they are written...:-))) > Subject: Re: sqlite ios pragma > From: m.schonewi...@economy-x-talk.com > Date: Wed, 17 Jul 2013 18:05:20 +0200 > To: use-livecode@lists.runrev.com > > Hi Pete, > &g

Re: sqlite ios pragma

2013-07-17 Thread Mark Schonewille
Hi Pete, Have you read my next post and Björnke's follow-up? -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.

Re: sqlite ios pragma

2013-07-17 Thread Peter Haworth
Can't speak for iOS but on the desktop, PRAGMA is just another SQLite statement that can be executed fine via revDataFromQuery. Pete lcSQL Software On Wed, Jul 17, 2013 at 2:37 AM, Mark Schonewille < m.schonewi...@economy-x-talk.com> wrote: > Hi Mike, > > The external doe

Re: sqlite ios pragma

2013-07-17 Thread Björnke von Gierke
To be precise, the following code works for me (some parts removed): put the selectedText of me into theName put revopendatabase("sqlite",field "path",,,) into theID put revDataFromQuery(comma,,theID, "PRAGMA table_info =" && theName) into myPragma if myPragma begins with "revdberr" t

Re: sqlite ios pragma

2013-07-17 Thread Mark Schonewille
Hi again Mike, I've just been told that PRAGMA does exist on the desktop version of LiveCode now (thanks Björnke). It might also work on iOS. Perhaps you need to post some code. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-t

Re: sqlite ios pragma

2013-07-17 Thread Mark Schonewille
Hi Mike, The external doesn't include PRAGMA. It needs to be rewritten for that. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Use Color Converter to convert CM