barand

executeSQL: counting text fields that contain id

Discussion created by barand on Nov 27, 2017
Latest reply on Nov 28, 2017 by coherentkris

Hello Filemaker users,

 

Is it possible with executeSQL to count the rows that have a certain id in it? In this case the ID field is a text field..

 

executeSQL count does work when I use number fields:

ExecuteSQL (" 

SELECT COUNT('_pkuniqueIDJoinChecklistVraag')

FROM SelfJoinChecklistsFormulier

WHERE vraagNummer = ? AND AntwoordNee = ?" ; "" ; ""; "9"; "1"

)

 

Does executeSQL work with ID fields that are configured as text field?

 

Kind regards,

 

Baran

Outcomes