SQL query and Field starting with "_"

[Carsten]

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

[joshua-rivers-digital]

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

[waso]

Hi Joshua, I am glad to see you alive and well. Is Zulu a dead product?

[Carsten]

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\" = ? ....

[Carsten]

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 ?

[joshua-rivers-digital]

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

[Carsten]

 

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