+2  A: 

Well, first change your query to your parameterized query like you have there. Then, just before you call sqlite3_step bind the right id to the parameter:

sqlite3_reset(getVisuelStatement);

//Add these two lines
int visuelId = 1;  //Put whatever id you want in here.
sqlite3_bind_int(getVisuelParcStatement, 1, visuelId);

while(sqlite3_step(getVisuelParcStatement) == SQLITE_ROW) {
Ed Marty
Thanks that help. But now, If I do what you say I will have to right: for visuelId =1 do that... visualId =2 do that............ I have created a UITableView and I want for example to put the number of the line for the visuelId. Hos to do that?
ludo
A: 
ludo