Sqlite (phone and url fields)

Hi Bill and Chris,

Thanks for the great book and all of the sqlite info!

I have created an events database and display it on navigation based application. I have created an event class that holds the name of the event, description and an image. I created an array that reads the events from the database. Everything works great! Except I want to add a field so they can tap on the phone number and it will dial and also a field for clickable url that will open a webpage in the google browser.

I am close to my wits end… and any direction would be very very much appreciated.

Happy holidays…

Hi MauiG,

Sounds great! Please let us know when you get the app in the app store so we can all buy a copy :)

You can get the phone to dial a number by calling

[[UIApplication sharedApplication] openURL:[NSURL URLWithString:@”phone:1234560987”]]

some of that is prob wrong I don’t have a compiler in my brain, but hopefully this gives you what you need.

Good luck, and thanks for the kind words!

Thanks Bill, That helped alot. Now the only issue I am having (and can’t find the answer anywhere) is how to pass the url?? Do I need a uibutton in the interface builder to make the link work? Or could I somehow modify the text view and it reads the url address? I am not sure I am using the right lingo so apologize…

Hi Maui,

Again I’m late responding. Sorry!

Well, you could so something like this;

- (IBAction)phone {
  [[UIApplication sharedApplication] openURL:[NSURL URLWithString:@"tel:1234567890"];
}

Then wire a button from IB to the phone method. If I understand your question correctly this should work for you. If I’ve misunderstood please clarify and I’d be happy to answer more (and I won’t be so late next time:)