AnsweredAssumed Answered

ExecuteSQL() doubt

Question asked by carlos_m26 on Apr 28, 2017
Latest reply on Apr 29, 2017 by carlos_m26

Hi everyone,

I have a problem with ExecuteSQL() in a search script...

in a variable I put this :

 

ExecuteSQL (

"SELECT pais FROM permiso_paises WHERE cuenta_usuario = CURRENT_USER "

;"";""

)

 

is a simple SELECT to an other table (in the same file), this step works all the time when I (full access) perform the script...but when some other user (not full access) perform the search script....this step dosen't work all the time, somes does but other dosen't, and I dont know why... it is pretty frustrating

 

the executesql() run when filemaker is in  find mode... could be that my problem?? but I have not problem with my account... do you need special privilege to use it????

 

I'm using FMPA 14

 

I hope you can understand me and I apologize for my poor english...

Outcomes