El_Pablo Posted May 15, 2015 Posted May 15, 2015 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 Posted May 15, 2015 Posted May 15, 2015 Try WHERE i.\"__modification_ts\" <> s.\"__modification_ts\" 1
Wim Decorte Posted May 15, 2015 Posted May 15, 2015 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 Posted May 15, 2015 Posted May 15, 2015 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
Recommended Posts
This topic is 3732 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 accountSign in
Already have an account? Sign in here.
Sign In Now