View Issue Details

IDProjectCategoryView StatusLast Update
0008755ADK-Xojo-V4RBRBDB APIpublic2020-03-20 08:47
ReporterDeltaworXAssigned ToIvan Smahin 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformINTELOSMAC OS OS Version*
Product Version10.0.x 
Target VersionFixed in Version10.1.x 
Summary0008755: RBDB API returns RecordSet instead of RowSet in Xojo API 2
DescriptionWhen using Xojo API 2 to get a RowSet from a VRBDatabase the result is not a RowSet, but a RecordSet (Xojo API 1 style) with the SelectSQL() function introduced in Xojo 2019R2

DB is a VRBDatabase

Example:

Var rs As RowSet
rs = DB.SelectSQL("SELECT * FROM accounts WHERE ID = ?", 1 )

XojoDebugger shows that the result is a RecordSet, App is crashing.
TagsNo tags attached.

Activities

DeltaworX

DeltaworX

2020-03-19 20:33

reporter   ~0011178

Additional infos:

RecordSet contains data (visible in Xojo Debugger), but this data is not accessible. If I try to populate a listbox with listbox.AddRow(rs.Column("name").StringValue) the result is a hard crash.

Issue History

Date Modified Username Field Change
2020-03-19 16:53 DeltaworX New Issue
2020-03-19 20:33 DeltaworX Note Added: 0011178
2020-03-20 08:47 Ivan Smahin Assigned To => Ivan Smahin
2020-03-20 08:47 Ivan Smahin Status new => resolved
2020-03-20 08:47 Ivan Smahin Resolution open => fixed
2020-03-20 08:47 Ivan Smahin Fixed in Version => 10.1.x