Search found 45 matches

by Knightlite
Sun Mar 30, 2014 11:02 pm
Forum: iOS Deployment
Topic: How do you load images for landscape and portrait positions?
Replies: 1
Views: 2099

How do you load images for landscape and portrait positions?

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 hav...
by Knightlite
Tue Feb 26, 2013 6:49 pm
Forum: iOS Deployment
Topic: Text To Speech and rrenarrator
Replies: 2
Views: 2970

Text To Speech and rrenarrator

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: 1...
by Knightlite
Thu Oct 25, 2012 7:33 pm
Forum: Databases
Topic: Question About Using Andre Garzia's DBLib
Replies: 1
Views: 3037

Question About Using Andre Garzia's DBLib

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 "contacts" t...
by Knightlite
Thu Oct 25, 2012 3:46 pm
Forum: Databases
Topic: How Can I Save Changes To SQLite Database?
Replies: 37
Views: 35763

Re: How Can I Save Changes To SQLite Database?

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 databas...
by Knightlite
Wed Oct 24, 2012 7:57 pm
Forum: Databases
Topic: How Can I Save Changes To SQLite Database?
Replies: 37
Views: 35763

Re: How Can I Save Changes To SQLite Database?

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 it. ...
by Knightlite
Tue Oct 23, 2012 9:52 pm
Forum: Databases
Topic: How Can I Save Changes To SQLite Database?
Replies: 37
Views: 35763

Re: How Can I Save Changes To SQLite Database?

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 help. ...
by Knightlite
Tue Oct 23, 2012 9:51 pm
Forum: Databases
Topic: How Can I Save Changes To SQLite Database?
Replies: 37
Views: 35763

Re: How Can I Save Changes To SQLite Database?

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
by Knightlite
Mon Oct 22, 2012 9:09 pm
Forum: Databases
Topic: How Can I Save Changes To SQLite Database?
Replies: 37
Views: 35763

Re: How Can I Save Changes To SQLite Database?

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 the ...
by Knightlite
Mon Oct 22, 2012 8:14 pm
Forum: Databases
Topic: How Can I Save Changes To SQLite Database?
Replies: 37
Views: 35763

Re: How Can I Save Changes To SQLite Database?

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 li...
by Knightlite
Mon Oct 22, 2012 7:43 pm
Forum: Databases
Topic: How Can I Save Changes To SQLite Database?
Replies: 37
Views: 35763

Re: How Can I Save Changes To SQLite Database?

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" & "',addre...
by Knightlite
Mon Oct 22, 2012 6:30 pm
Forum: Databases
Topic: How Can I Save Changes To SQLite Database?
Replies: 37
Views: 35763

Re: How Can I Save Changes To SQLite Database?

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 this...
by Knightlite
Mon Oct 22, 2012 5:25 pm
Forum: Databases
Topic: How Can I Save Changes To SQLite Database?
Replies: 37
Views: 35763

Re: How Can I Save Changes To SQLite Database?

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 declare ...
by Knightlite
Sun Oct 14, 2012 2:42 pm
Forum: Databases
Topic: How Can I Save Changes To SQLite Database?
Replies: 37
Views: 35763

Re: How Can I Save Changes To SQLite Database?

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 connection ID:...
by Knightlite
Wed Aug 15, 2012 1:57 pm
Forum: Databases
Topic: How Can I Save Changes To SQLite Database?
Replies: 37
Views: 35763

Re: How Can I Save Changes To SQLite Database?

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 the ap...
by Knightlite
Wed Aug 15, 2012 12:55 pm
Forum: Databases
Topic: How Can I Save Changes To SQLite Database?
Replies: 37
Views: 35763

Re: How Can I Save Changes To SQLite Database?

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" into txtID...