Data-On-Demand ListBox

Playing around with Kem’s Data-On-Demand ListBox with a PostgreSQL database. I can’t seem to figure out how to get the data from the PostgreSQL database to the DOD Virtual Database.

I created a recordset (rs) but the RequestRowData event does not move through the data like the example Valentina database, so the code:

lbDOD.Cell(dataRow,0) = rs.Field("last_name").StringValue + ", " + rs.Field("first_name").StringValue

just displays the same data in the listbox for every row.

Not sure how this works.

Rs.movenext

That did load the listbox on demand with the data. Thanks.