>Hi Again Mark, >I'll try your suggestion about CA , for SPT subject is not clear yet i need some sample >containing connectionstring,sqlexec() vs ...
The ConnectionString example you should already have.
lnHandle = SQLSTRINGCONNECT(lcConString) && from thread I referenced
lnRetVal = SQLEXEC(lnHandle, 'select ... from mytable where ... order by ...', 'crsResults')
if lnRetVal < 1 * failureelse * workedendif