I have a problem with ExecuteSQL() in a search script...
in a variable I put this :
"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...