AnsweredAssumed Answered

Filemaker internal SQL debug help

Question asked by firebase on Mar 11, 2014
Latest reply on Mar 14, 2014 by philmodjunk


Filemaker internal SQL debug help


     i am simply getting crazy on this one:


     ExecuteSQL ("SELECT \"field1\" FROM \"table1\" WHERE \"field1\" = \"current_table::field2" " ;"";"")

     Which means i want to see if there is a record in another db which is same as in the open layout database i am using this knob/function in.


     everything works if i use '1' (records in field1 = 1) instead of current_table. But as soon i want to use current_table i get a "?".

     I also tried a variable but absolutly nothing works there...


     Please help, i amk allreaddy hitting the wall... :)