AnsweredAssumed Answered

ExecuteSQL not working

Question asked by manuelruizga on Dec 15, 2018
Latest reply on Dec 15, 2018 by okramis


Hi,

 

I have a an ExecuteSQL function working just fine in one script. When trying to replicate the same function in other script it does not work ("?" as result).

 

This is the calculation:

 

Let ( [

 

selectField = Substitute ( GetFieldName ( PROCEDIMIENTO::a_encargo_fk ) ; "::" ; Quote ( "." ) )

;

fromField = GetValue ( Substitute ( GetFieldName ( PROCEDIMIENTO::a_encargo_fk ) ; "::" ; "¶" ); 1)

;

whereField1 = Substitute ( GetFieldName ( PROCEDIMIENTO::a__procedimiento_pk ) ; "::" ; Quote ( "." ) )

;

procedimiento = $procedimiento

 

] ;

 

ExecuteSQL ( "

 

SELECT selectField

FROM fromField

WHERE whereField1 = ?

 

" ;

""; "";

 

procedimiento

 

)

)

 

 

I have been testing with the calculation for a while trying to figure out what is going wrong but I don't seem to solve it.

 

Can anyone help me?

Outcomes