executesql Problem with fieldname characters

[El_Pablo]

Hi,

I'm having problem trying to get this query work.

Let ( [
  q = "SELECT i.c_nomComplet 
       FROM personnesiPad as i 
       LEFT OUTER JOIN personnesServer as s 
       ON i.uuid = s.uuid
       WHERE i.__modification_ts <> s.__modification_ts";
    
  r = ExecuteSQL (q; ";"; "¶")
];

 r
)

 

The problem seems to be my fieldnames in the WHERE clause. I've tried to quote them with the quote function, but I still have a validation error.

How do I managed to use fieldnames with special characters?

BTW, I'm trying to do a synchronisation file between an ipad and a server.

Thanks for helping!

[eos]

Try

WHERE i.\"__modification_ts\" <> s.\"__modification_ts\"

[El_Pablo]

Thanks for the quick reply! It works!

[Wim Decorte]

You may want to encapsulate your field names and use field references instead so that your queries will remain intact if you ever change a TO name or a field name...

[eos]

encapsulate your field names and use field references

Shouldn't we make that warning into a sticky?​

btw: cool pic, but the old one was more … geekish