HI Frank. All the applications I know are using SqueakDBX but trought GlorpDBX (an ORM). But anyway, I am not sure I undertand your problem. I recommend you to take a look to all the tests in the class DBXQueryTest.

For example, you can do this:

testIterateResultSet
��� | conn result select aRow |
��� conn := self doConnectAndOpen.
��� select := 'SELECT * FROM student'.
��� result := conn execute: select.
��� [ aRow := result nextRow.
"Do something with aRow"
�] doWhileTrue: [ aRow notNil ].
��� self assert: aRow isNil.
��� result releaseResult.
��� conn disconnect

And to DBXRow, you can ask values (accessing by index or by name), descriptions, converting or not so String, etc...

For example, check the class DBXTranscript >> showResultSet: resultSet
showResultSet: resultSet
��� | stream |
��� stream := String new writeStream.
��� resultSet columnDescriptions
��� ��� do: [:each | stream nextPutAll: each name]
��� ��� separatedBy: [stream nextPutAll: ' | '].
��� Transcript show: stream contents;
��� ��� �cr.
��� resultSet
��� ��� rowsDo: [:row |
��� ��� ��� stream := String new writeStream.
��� ��� ��� row values
��� ��� ��� ��� do: [:each | stream nextPutAll: each asDbxString]
��� ��� ��� ��� separatedBy: [stream nextPutAll: ' | '].
��� ��� ��� Transcript show: stream contents;
��� ��� ��� ��� �cr]


What I mean is that since you have reified DBXRow, DBXResultSet, etc...then you can do whatever you want with that.

Cheers

Mariano


�