identify record number

[222]

Hi all,

Refer to the attachment, I used the DB Tools Execute Query.vi to select the particular data out. May I know how can I identify the selected data's record number? I was trying to use the DB Tools Get Properties -> unbundle -> Record Index to get the current record number but I get -2 value. Your assistance on this is highly appreciated.

[rolfk]

---

@222 wrote:
Hi all,

Refer to the attachment, I used the DB Tools Execute Query.vi to select the particular data out. May I know how can I identify the selected data's record number? I was trying to use the DB Tools Get Properties -> unbundle -> Record Index to get the current record number but I get -2 value. Your assistance on this is highly appreciated.

---

Unless you have included a specific autoincrement field there is not anything like an absolute record number for most databases. You can have relative record numbers in a query result set with multiple records but that is only in respect to the current queries result set.

Rolf Kalbermatter

[falkpl]

Usually you have a "key" instead of the recoard number since the order in a db often does not matter.