OK Thanks.
I understand taht I cannot do UI.
that's OK.
WHat's more important is that I need to return a cursor
to the calling program.
How can I do this.
When I create the cursor via a SQLEXEC it works OK. (No errors)
I tried it from a form and the command window but
both don't know about the cursor. I can't select it.
How can I return a cursor?
PS I also tried.
DEFINE class cursor AS cursor OLEPUBLIC
PROCEDURE init
LPARAMETERS lnConnectionHandle,dest
temp="mainkey='Womens Wear*23809-1'"
LSQL='PDMSELECTWO measure,"'+ temp +'"'
nerror=SQLEXEC(lnConnectionHandle,LSQL,this.alias)
select &dest
IF nerror!=1
AERROR(aErrorArray)
lcerrorstring="SQL Server Error : "+STR(aErrorArray(1,1))
lcerrorstring=lcerrorstring+aErrorArray(1,2)+CHR(13)
lcerrorstring=lcerrorstring+aErrorArray(1,3)+CHR(13)
RETURN lcerrorstring
ENDIF
RETURN
ENDDEFINE
SO I can do a craeteobject() and get my cursor.
But I guess I just don't know what I'm doing.
Thanks for the help!
Précédent
Suivant
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