On 16/01/2014 22:46, [email protected] wrote:
On 2014-01-16 07:33, AndyHC wrote:
Personally I always found it /convenient/ to get results in Fox
cursors (I even struggled with Oracle RefCursors to do it!) however:
I don't know mySQl but for SQL Server or Oracle some variation of the
following should work:
use
lConn = && insert your conn string or etc.
* we assume an sp that accepts 2 IN parms (char, int) and one [IN]OUT
parm (int)
lInParm1 = 'mykey'
lInParm2 = 123
lOut = 0
lCmd = "exec myDB.mysp(?lInParm1, ?lInParm2, ?@lOut" && pass by
reference.
? SQLEXEC(lnConn, lCmd)
?lOut
browse && is there an empty cursor?
Yeah, I know I could use output parameters like your example above. I
do not believe a cursor would be created in your example, either.
Thanks,
--Mike
So what /did/ you want to do? - AndyD
<snip>
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
