Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

SQL query and Field starting with "_"

Carsten
in MirrorSync by 360Works

Featured Replies

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

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

  • Newbies

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

  • Author

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

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

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

  • Author

 

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

Create an account or sign in to comment

https://fmforums.com/topic/103763-sql-query-and-field-starting-with-_/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.