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!

Try

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

Thanks for the quick reply! It works!

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...

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