Topic: SQLExecute
I have the following script: Form1.Label2.Caption:=sqlexecute ('select count(ID) from deelnemer') and is works good.
I want to change the script with a "Where"clause, so I thought it was easy and changed it to : Form1.Label2.Caption:=sqlexecute ('select count(ID) from deelnemer where country ='Nederland'')
That don't work. Can somebody help me with the correct syntax?