LiveCode Forums.

Hi,

I am writing an iPad app with an image used for the background. I have two images. One for portrait and the other for landscape. I am also using MobGui. I was wondering if there was any easy way to load the correct image at development time depending on the orientation of the IDE? Or does it ...

Hi,

I am trying to write an app for the iPad and have the functionality of text to speech. I just need to have the iPad read out loud a simple text field. I am told that the rrenarrator can do this, but I can't seem to get the example to work. I have LiveCode 5.4 and Xcode 4.6. This is what I did ...

Hi,

Hope this is not off topic for this forum, but it is related to databases.

I am trying to use Andre's DBLib and I am running into a few problems. In his example he links a SQLite table to a DataGrid using two lines of code.

put dbGet("contacts") into tDataA
set the dgdata of control ...

Hi Mark,

Thank you for your message. I actually have the multiple choice testing GUI functioning the way I want it. Almost everything works except for:

Being able to save data in the iPad simulator and on the actual iPad device.

I would also like to be able to use Andre's DBLib to update the ...

Hi Mark,

Thank you so much for your message. I will check out your newsletters, and again, I appreciate your help.

I actually have Andre's DBLib and I am trying to figure that out as well.

There are two problems I am having with his DBLib and I know its all me. I am sure there is a way of doing ...

Hi marksmithhfx,

Thanks so much for taking the time to code that project. I really appreciate the time you put into it.

Its really different than what I was doing, so it looks like I was doing everything wrong. It will take me a few days to figure out what you did, but I really appreciate the ...

Hi Adrian,

Thank you for the tip. I just don't know how to do that. I am very new to Livecode and as my posts show, I am struggling with just about everything.

I will try to look up what you are talking about it.

Thanks.

Jim

Hi mwleder,

Oops, yes I did get spell the tSQLQuery right. Typing too fast.

Can I just ask you one more question? ..... for now at least. :-)

In that example lets say I make a change in one of the fields like the first name, how can I make the recordset display the change without having to load ...

This is actually the line I was looking for:

Put "UPDATE info SET name='" & the text of field "txtName" & "',address='" & the text of field "txtAddress" into tSQLQuery
Put "',email='" & the text of field "txtEmail" & "' WHERE id='" & the text of field txtPrimaryKey & "'" after tSQLQuery

// This ...

Hi mwleder and Adrian,

Thank you again for your help. I really appreciate it.

I think Adrian has the solution here, yet it still does not save. I think tho code will work, but I still think the final execute line may not be right.


Put "UPDATE info SET name='" & the text of field "txtName ...

Hi mwleder,

Thank you for your message.

What I am trying to do is to write some code that would allow the user to make a change in one of those 3 fields and then when the user clicks the Update button, the changes are saved to the database.

I just don't know what the code is for doing that, and ...

Dear Klaus and sturgis,

Thank you so much for trying to help me. I have spent a week trying to figure out things that you guys posted and I'm still having problems.

Klaus, you said the following:

somewhere in the card script?
If not, then "sDatabaseID" is not known at this place, unless you ...

Hello,

I am still trying to get how I update a record in a SQLite database, and I am getting nowhere. When I try to update a record, I get an "invalid connection ID error.

I open the card with this code:

local sDatabaseID, sRecordSetID


I use this code to open the database and save the ...

Hi Klaus,

you obviously did not take a look at UPDATE example in the "SQLite Sampler.rev" stack,
where you can see a working example of the UPDATE syntax.

Well, I actually did check this sample out and I found it difficult to follow. I would also say, its not exactly a "working example" since ...

Forget RealBasic, there is no equivalent to these commands in Livecode!

Stupid question: Did you ever EXECUTE tSQLQuery?


Not a stupid question at all. I don't think that I am doing that correctly. Here is the code I have.


put "X" into Field "lblX"
put fld "lblX" into lblX
put fld "txtID ...