AnsweredAssumed Answered

ExecuteSQL

Question asked by GeertThijs on Oct 28, 2017
Latest reply on Oct 28, 2017 by philmodjunk

Hi,

 

I have a basic problem with the function ExecuteSQL.

It doesn't work to get data from one table :

 

ExecuteSQL (

"SELECT DISTINCT title

FROM objects"

; "" ; "" )

 

Whereas in any other table it works fine:

 

ExecuteSQL (

"SELECT DISTINCT surname

FROM lineitems_contacts"

; "" ; "" )

 

Any other field from the table OBJECTS gives the same result: ?

Could the the table have a corrupt record?

 

What am I doing wrong?

 

Thanks for giving a suggestion...

Geert Thijs

Outcomes