>>We are storing a sql statement and passing it between to prg files. It is bombing out and we think that we might be trying to pass a string that is too large...or it could be something else altogether. Has anyone else run into such a limit?
>
>Ed, what's the error message? On what line of code?

I working with my partner on this...just got the code. getting a syntax error..right now he is reversing the quotes and double quotes in case that might be the culprit...any ideas?

Here is the code.

mSQLFldList = 'Select lastname, firstname, ssn, classcode, adrep, farep, '
mSQLFldList2 = 'sttrans, sddate, sdamount, sdledate, sdleamt '
mSQLFrom = 'From students, studtran, studdisb '
mSQLJoin = 'Where stssn = ssn and sdtrannum = stnum '
mSQLWhere = 'and status = "A" and sdstatus = "P" and between(sddate,msdate,medate) '
mSQLOrder = 'Order By sttrans, lastname, firstname'
MySQLComm = '&mSQLFldList &mSQLFldList2 &mSQLFrom &mSQLJoin &mSQLWhere &mSQLOrder'
if MyCommProc.ExecuteRemoteSQL('SELECT', MyFinanceConn, @MySQLComm, 'SQLResults')
*************************

It works if you try to run the string MySQLComm from the command line, but if you pass it as a parameter in the
MyCommProc.ExecuteRemoteSQL - it doesn't.


Ed