>Thanks for that Cetin.
>Regarding your last point, do you mean to send all (3-8) SQLs in a single SQLExec? I understand that something like that can be done and that results sets for each are returned. IF that's close to correct < s >, and I really only need the last one, is that possible?
>
>cheers
>
>>Cetin

Hi Jim Nelson

I dunno whether this may help ...

mstring = 'select * from customer where cusid = ?mcusid '+;
'select * from supplier where supid = ?msupid '+;
'select * from invoice where cusid = ?mcusid '

inhandle = sqlexec(myconnect,mstring,'mytable')
if inhandle = 3 && 3 cursor...depand on no# table calling
=sqldisconnect(myconnect)
select mytable
browse
select mytable1
browse
select mytable2
browse
else
=sqldisconnect(myconnect)
=messagebox("Connection failed",0,"Warning")
endif