Hi Guys and Dolls,

New to this forum (and new to PC-based platform programming) and it seems that this forum is quite helpful for queries and problems (even stupid ones) so I'd like to pose a few now.

Object Rexx (ooRexx)
ADODB.Connection to Access

/* rexx program */
blah, blah

varname=''
sql ="Select name into :varname from myTable where code = 'AAA' "
conn~execute(sql)

.
Works ok but I was expecting my rexx variable varname to contain the fetched data but instead found that access had created a new table called :varname with the result inserted there.

Does this mean that host-variables are not allowed in Access?

Thanks for any help....

Regards from Sydney,
Ven Ilagan