>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement