I created a means for my objects to request cursor names so that there would be no collisions among hardcoded cursor names, particularly when I use the same class twice in a form, yet the 2 classes retrieve different data from the back end.

I am confused about how I can get to the data in the cursor. Normally, the cursor "cursor" would be created here:

SQLEXEC(handle, sql_statement, "cursor")

and I could use the data in the cursor through:

some_text_edit.value = cursor.field1

I am confused about what to do when the name can not be hard-coded, such as in my case of computer generated cursor names. In my case, there is a function REQUESTNAME(name_stem) that will give an unused cursor name. My code is something like this:


curs_name = requestName("name_stem")
SQLEXEC(handle, sqlQuery, curs_name)

some_text_box.value = ????????????


There is my problem. How do the value from a column into the textbox.

I am also curious - what are the common techniques to keep an object from clobbering the cursor of another object of the same class? My solution was my first instinct, but I expect that there are other, better solutions.