Carsten Posted December 8, 2018 Share Posted December 8, 2018 Hi everybody, I started to use sql in mirrorsync but I have problems with one field name that starts with "_" Example Where '_user_created' = '{MIRRORSYNC_USERNAME}' There are no more error message when using a apostrophe ' but I get no values then ... I think this is a very basic problem and hope somebody has a tip Kind regards Carsten Link to comment Share on other sites More sharing options...
joshua-rivers-digital Posted December 11, 2018 Share Posted December 11, 2018 Hello Carsten, I was able to reproduce this and it is not the expected result. I have created a 360Works internal issue about this and we are currently working on it. I will keep you updated. Thank you for pointing this out! Joshua 360Works Link to comment Share on other sites More sharing options...
Newbies waso Posted December 12, 2018 Newbies Share Posted December 12, 2018 Hi Joshua, I am glad to see you alive and well. Is Zulu a dead product? Link to comment Share on other sites More sharing options...
Carsten Posted December 14, 2018 Author Share Posted December 14, 2018 Hi Joshua, just as an additional information from me ... In Filemaker with executeSQL I know it works like this "SELECT a.\"_kp_field-a\" FROM \"Table\" a WHERE a.\"_field-b\" = ? AND a.\"field-c\" = ? .... Link to comment Share on other sites More sharing options...
Carsten Posted March 8, 2019 Author Share Posted March 8, 2019 On 12/11/2018 at 9:36 PM, Joshua Rivers said: Hello Carsten, I was able to reproduce this and it is not the expected result. I have created a 360Works internal issue about this and we are currently working on it. I will keep you updated. Thank you for pointing this out! Joshua 360Works Hi Joshua, do you have any good news for me about the leading underline "_" in a sql query ? Link to comment Share on other sites More sharing options...
joshua-rivers-digital Posted March 13, 2019 Share Posted March 13, 2019 On 3/7/2019 at 11:48 PM, Carsten said: Hi Joshua, do you have any good news for me about the leading underline "_" in a sql query ? Hey Carsten, So I just spoke with the developer and this will not be addressed. He recommends you change the field names and remove the "_" from the field names. Please let me know if you have any other questions. Thank you! Joshua Rivers 360Works Support Link to comment Share on other sites More sharing options...
Carsten Posted March 14, 2019 Author Share Posted March 14, 2019 8 hours ago, Joshua Rivers said: Hey Carsten, So I just spoke with the developer and this will not be addressed. He recommends you change the field names and remove the "_" from the field names. Please let me know if you have any other questions. Thank you! Joshua Rivers 360Works Support Hi Joshua, I am using sometimes the script step „Set Field by name“ to use one script for all tables, so just renaming the fields is possible but not a „nobrainer“. In all other scripts with sql queries the leading underline is not a problem so I will just stop using SQL in Mirrorsync. Carsten Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 1842 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