LiveCode Forums.

Hello- still newbie here. I've developed a prototype application that stores data in a SQLite database. Now I'm trying to get the database off the iphone and back to my desktop PC. There doesn't appear to be a way to copy the file directly, so I thought I'd try using the mobileComposeMail command. However, when the email opens, it does not appear to contain an attachment and when I receive it, there is no attachment. Here's my code- I realize the attachment type is wrong, but I was expecting to just receive a text file with the name of the database at this point... I also changed my email address so it's not posted. Thanks in advance.

if the environment = "mobile" then
put DatabasePath into tAttachment["data"]
put "text/plain" into tAttachment["type"]
put "MeteorCount.SQLite" into tAttachment["name"]
mobileComposeMail "Meteor Data " & date(), "myemail@myserver.com",,"Here is the SQLite Database",tAttachment
end if

If you copy your DB into the "documents" directory [ specialFolderPath("documents") ] and you enable the "File Sharing" flag on the Standalone Application settings, you can access the folder directly from iTunes to read/write files.

Guglielmo

Sweet- thanks! Works great.

I would still like to know how to attach the database to an email if anyone has an answer to that.

mobilecomposemail has an attachment parameter

Do you mean something different from what I posted in my code?

You might want to base64encode the DB before you send it in mail.. or zip + encode it before sending as attachment...?

Ahh - just checked the iOS release notes and this doesn't seem necessary - sorry...!

Hi,

It looks like a comma is missing:
Kind regards,

Mark

Whoops- thanks so much and sorry about the dumb question! I'm a noobie with livecode, but I've been coding for 25 years and should know better than that! It's working now.