dimanche 8 mars 2015

How can I use text and numbers in a single row using SQLite?

I'm using objective c to add data to my SQLite db. I have a column with the text attribute. The problem is, there will be both, numbers and letters in that row. When I tried doing that, it gave me an error. But when I took away the number, there wasn't any error, and it worked just fine.


Here's my code:



insert into myTable values(null '%@'), myText; // myText = @"2 Phones"


My question is, how is it possible to have both, numbers and regular text inside a row in SQLite?


Aucun commentaire:

Enregistrer un commentaire