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!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only