Contents is missing in debugger for databaserow

Databases
1

Xojo 2019 Release 3
If you debug each line below, you will see a contents object in the debugger for the databaserecord, but not for the databaserow.

Dim rec As New databaserecord
rec.Column(“test”)=“test”
rec.Column(“test2”)=“test”
rec.Column(“test3”)=“test”
rec.Column(“test4”)=“test”

Dim row As New databaserow
row.Column(“test”).StringValue=“test”
row.Column(“test2”).StringValue=“test”
row.Column(“test3”).StringValue=“test”
row.Column(“test4”).StringValue=“test”

How can you see the contents of the row you are are building. Is this an error in databaserow?

2

I went ahead and filed a bug report.
<https://xojo.com/issue/58665>

3

Ah, thought it was issue my end! thanks Dale

4

Dale can you also confirm rowcount does not show in the debugger?

5

RowCount does not have meaning with DatabaseRow in this context since a new Row structure is being created and not yet applied to the database.

6

Sorry it was not in this context it was a rowset

7

RowCount does not show in the Debugger for a RowSet. For that matter, it doesn’t show in the old RecordSet either. If you need that, simply put a line of code like Var rc As Integer = rs.rowcount immediately after the SELECT SQL statement.

8

you can only see a property in the debugger, and recordcount are method results.
it is like this for years , and pretty sure it will not be changed soon.

9

also bear in mind that not ALL Database engines even return a valid recordcount… (SQLite does, but not all do)