Cannot get value from recordset

[ts-d]

I can create a connection to an existing database
and I can create a recordset with a select-command,
and I c a n n o t get a value from the recordset.

Can somebody give me a satisfactionable answer?

Thanks.

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply. It also makes it easier for others who come searching for the same solution. I have also removed the swearing and split the post to a new thread. Few people would see it at the bottom of a thread that was already marked as Solved. (TheGurkha, Moderator).

[cornouws]

Hi ts-d

Something as this: ?

Code: Select all

	while oRowSet.next()
		Result(nRow) = oRowSet.GetString(1) & " " & oRowSet.GetString(2)
		nRow = nRow + 1
	Wend

Where Result() is a string array to do further work with.