Using SQLite from Objective-C

Question

I am having problems writing statements, especially when updating.

I want to update a column with a parameter, but I don't know the special characters to use like @ or %d.

I tried to do:

const char *sqlStatement = [[NSString stringWithFormat:
  @"update lugar set frecuencia ='d%'aumentador Where idLugar = '%d'",
  idLugarParametro] cStringUsingEncoding:NSUTF8StringEncoding];

But I get a problem with: frecuencia ='d%'aumentador

How can I find a guide or tutorial for using this special characters for creation statements? (Using Objective C specifically.)

There is no good reason to use the sqlite C api directly. Use a wrapper: cocoaheads.byu.edu/resources/sqlite — Dave DeLong
– Dave DeLong, Commented Dec 5, 2009 at 1:40

martin clayton · Accepted Answer · 2011-02-09 19:11:32Z

2

Here's An Introduction To The SQLite C/C++ Interface.

Here's the Apple documentation for NSString stringWithFormat, and string format specifiers.

I note that it seems you typed d%, but probably meant %d for the format specifier (you might need an extra space in there too), and that you've only supplied one arg (idLugarParametro), but your format string has two specifiers:

------------------------------1v------------------------------2v
update lugar set frecuencia ='%d' aumentador Where idLugar = '%d'

so you need to supply two values - the new frecuencia value is not there.

Lastly, suggest that you look in to the use of prepared statements once you've got the hang of the basics - see the SQLite docs.

edited Feb 9, 2011 at 19:11

answered Dec 5, 2009 at 1:10

martin clayton

78.6k33 gold badges220 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using SQLite from Objective-C

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related