Thanks Edward for the response.. I tried it and a couple other things also...
STORE SQLCONNECT('server', 'id', 'passwrd') TO gnConnHandle
?gnConnHandle && this returns a 1
I have tried
1) lcSQL='acct_unmatched_rpt_sp 0,"detail"'
2) lcSQL="acct_unmatched_rpt_sp 0,'detail'"
3) paramdetail="detail"
lcSQL="acct_unmatched_rpt_sp 0,"+paramdetail
test= SQLEXEC(gnConnHandle,lcSQL)
but nothing seems to work. Yet in Excel and in Access the sql pass-through command acct_unmatched_rpt_sp 0,detail works without a hitch!
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