Help problems with cs_exec_sql

Applications Forms
#1

I do not recognize the code

$cadena = {Estudios};

$sql = “SELECT INSTR(’$cadena’,’,’)”;

$prueba = sc_exec_sql ($sql);

appreciate your help

#2

$sql = “SELECT INSTR(’”.$cadena."’,’,’)";

#3

You do not get a result from the sc_exec_sql() macro, instead use either sc_lookup() or sc_select().

http://www.scriptcase.net/docs/en_us/v8/scriptcase-macros/scriptcase-macros#sc_lookup
http://www.scriptcase.net/docs/en_us/v8/scriptcase-macros/scriptcase-macros#sc_select

$cadena = {Estudios};

$sql = “SELECT INSTR(’$cadena’,’,’)”;
sc_lookup(rs,$sql);
//check for errors
$prueba = {rs[0][0]};

jsb