Jump to content

ExecuteSQL : Problem with delete


This topic is 1980 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to post
Share on other sites
  • 1 month later...

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.

Link to post
Share on other sites

This topic is 1980 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.