Hi guys,

sorry for the trivial question, but I'm getting an error that I haven't figured out yet.

This is my script, to get some mySQL data:

string ls_mySQLDataDir, ls_sql = 'SELECT @@datadir'

DECLARE dynCursor DYNAMIC CURSOR FOR SQLSA;
PREPARE SQLSA FROM :ls_sql;
OPEN DYNAMIC dynCursor;
Fetch dynCursor Into :ls_mySQLDataDir;
CLOSE dynCursor;

When it reaches the "open dynamic", I get this error message:

PowerBuilder application execution error (R0020)
Application terminated.
Error: Database command not successfully prepared at line 31 in function of_get_os_info of object nvo_os_info.

I have tried a different command, like "select @@version", but it yields the same result.

Any ideas?

Thanks!!!