SQLEXEC

[risslsu]

Help Please!

What am I missing?

Do I need to open the table or create a cursor before my SQLEXEC? Am I allowed to name the cursor the same as my remote table?

SQLEXEC(chandle, 'SELECT TOP 1 * FROM testtable ;
WHERE ALLTRIM(test1) == m.xyz','testable')

Any help or extra information would be great.

Thank you,
Marissa

 

[SQLBill]

That looks more like Oracle format than it does MS SQL Server format. SQL Server doesn't use the semi-colon ( or the double equal to sign (==). Those will most likely cause a syntax error.

If this is for Oracle, please post it in the proper forum. If it is SQL Server then you are in the correct forum.

-SQLBill