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.