Search local DB / get row Id

Hey Guys,
I find the documentation of the localDB to be very short and missing essential info.

So what Iam trying to do seems easy but Iam stuck.
I have a simple local Database. In there are two columns “name” “objectId”.
I show a list of the names in a listviewer. Now, when someone clicks an item I need to know and store the “objectId” of this item. Thought this would be easy but I have not found a way to do it yet.

Any ideas?

1 Like

There is more than one way of doing it.

One way is to have two lists, one list for “name” and another list for “objectId”.

In your list viewer you show the name list and when the user select a name use the [item click] even and use the green block [index] to read the item in the “objectId” list using the index which should return to you the relevant data.

Hope this helps.

1 Like

That seems doable. Thanks. But iam wondering. why have a database at all if you can not get items directly by querying?

1 Like

Use data viewer list to connect directly to your table.

The other advantage of data viewer list is the display of more than one field in each row.

2 Likes

ah! That is a superb solution. Thank you Sir!

2 Likes