200) { _maxres := '200'; } _stmt := get_keyword ('stmt', params); } ?> Virtuoso Interactive SQL using VSP
Max. no of results (200 max.)
SQL Statement

Execute in DSN :

>
'') _stmt := sprintf ('DB.DBA.RSTMTEXEC (''%S'', ''%S'')', _exec_dsn, rtrim(trim(_stmt), ';')); exec (rtrim(trim(_stmt), ';'), err_sqlstate, err_msg, vector(), atoi (_maxres), m_dta, result); { declare exit handler for sqlstate '*' { rollback work; err_sqlstate1 := __SQL_STATE; err_msg1 := __SQL_MESSAGE; }; exec ('commit work'); } if ('00000' <> err_sqlstate) { http (''); http (''); http (sprintf ('', err_sqlstate)); http (sprintf ('', err_msg)); if ('00000' <> err_sqlstate1) { http (sprintf ('', err_sqlstate1)); http (sprintf ('', err_msg1)); } http('
Execution Error
SQL State%V
Error Message%V
Txn SQL State%V
Txn Error Message%V
'); } else { declare sqlc any; adm_result_to_table(result, m_dta); sqlc := sql_parse (rtrim(trim(_stmt), ';')); if (0 and isarray(sqlc) and sqlc[0] = 100) { ?>
Save Query in a XML template