hey experts,
Im trying to populate the textboxes on a form, frm MySQl.. this is the code:

LPARAMETER twoid

thisform.wo_conn = SQLSTRINGCONNECT("driver={mysql odbc 3.51 driver};server="+alltrim(settings.server)+";uid="+ALLTRIM(settings.user)+";pwd="+ALLTRIM(settings.pass)+";database=mysqldb;option=3") && connect to Mysql DB

lcSelectCmd = 'select com, dat, r1,r2 ,wi from wo'+;
' where wi=twoid into cursor crstest' && wi is the primary key in wo table

SQLEXEC(thisform.wo_conn,lcSelectCmd)
select crstest

with this
.txtcom.controlsource = "crstest.com"
.txtdat.controlsource = "crstest.dat"
.txtr1.controlsource = "crstest.r1"
.txtr2.controlsource = "crstest.r2"
end with

I get the alias 'crstest' not found error..what gives

Thanx ,
sameer