Jump to content

SQL query and Field starting with "_"


This topic is 1842 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

  • 2 months later...
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

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

 

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.