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" then
answer "error in Database: Pragma failed:" && myPragma & return & myQuery
exit to top
else if myPragma <> "" then
--0,ID,INTEGER,1,,1
repeat for each line theLine in myPragma
put item 3 of theLine & comma after theTypes
end repeat
delete char -1 of theTypes
end if
On 17.07.2013, at 11:44, Mark Schonewille wrote:
> 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-talk.com
> Twitter: http://twitter.com/xtalkprogrammer
> KvK: 50277553
>
> Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other colour
> spaces. http://www.color-converter.com
>
> Buy my new book "Programming LiveCode for the Real Beginner"
> http://qery.us/3fi
>
> Fill out this survey please
> http://livecodebeginner.economy-x-talk.com/survey/
>
>> On 7/16/2013 05:40, Mike Kerner wrote:
>>> anybody trying to use that combination: PRAGMA in sqlite on ios?
>>> Everything else with this DB seems to work fine, but PRAGMA does not -
>>> returns 0 whether I do PRAGMA database_list or table_info(tableName)
>>>
>>
>
> _______________________________________________
> 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 an alternative Dictionary viewer:
http://bjoernke.com/bvgdocu/
Chat with other RunRev developers:
http://bjoernke.com/chatrev/
_______________________________________________
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
