ExecuteSQL : Problem with delete

[Gomme]

Hello,

 

When I run this query:

 

ExecuteSQL ( "select * from Emplacement where NoTerrain = '3' "; ""; ""; "" )

It works.   The recording are displayed.

 

However, when I run this query:

ExecuteSQL ( "delete from Emplacement where NoTerrain = '3' "; ""; ""; "" )

Error... I get ? as a result, and the query does not work.

 

Could someone explain me the problem ?

 

Thank you for your time.

[Wim Decorte]

you can't.  ExecuteSQL() can only do SELECT

 

http://www.filemaker.com/help/13/fmp/en/html/func_ref3.33.6.html#1062707

[beverly]

Wim is correct - you can only SELECT with ExecuteSQL(). However if you've "found" the records based on the query, then you certainly can DELETE those found records by script.