Return value from picker that is not the label

[SpyderDriver]

Is it possible to return a value from a picker that isn't what it has as it's label? I would like to return the primary key of the value listed in my picker. The values are loaded from sqlite.

[RickMaddy]

Look at it this way. You provided a picker view delegate that returned a title based on a row number and component number.

When the user picks a value you get notified with the same values - a component number and row number. Use the same logic to get your other data.

[SpyderDriver]

Are you saying to just fake the primary key by using the row number and hope that it is the same as the actual primary key? What if the query is reordered, it won't line up at that point. Is there a way to get the primary key of the record without having to do a whole query to get that?

[RickMaddy]

How did you get the data to begin with to populate the picker? I can't give too concrete of an answer because I don't know what you are doing. But in general I assume you are reading some data from a database to populate your pick view data model. Save enough info in that data model so that when a user picks a row from a component, you can grab enough data from the model to do whatever further query you need from the database.

[SpyderDriver]

Before the query I create an array. After the query I do

NSString *NameField = [NSString stringWithUTF8String:(char *)sqlite3_column_text(selectstmt, 1)];
[myArray addObject:NameField];

I don't understand how I would go about adding another value to my array. I come from a web background and understand multidimensional arrays but I do not know the syntax to create one in Cocoa. That's why I asked if there was a way to setup the view picker like a select box on the web -- the label being different from the value.

[RickMaddy]

Two arrays would work or an array of dictionaries where each dictionary contains the label and key you need.

[SpyderDriver]

Thanks, I didn't realize that you could do an array of dictionaries.

I didn't really know the proper question to ask and I appreciate the help.