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.

ExecuteSQL Issues

  •
CKonash
in Calculation Engine (Define Fields)

Featured Replies

Hi all.  

I am having a horrible time trying to fumble my way though what should be a simple ExecuteSQL calculation.   I'm trying to count the number of records in the ACCOUNT table that have the value of "Bergen" in the field called CountyName.   

Am I doing something wrong, the calc isn't working.  i've tried single and double quotes around the field value of Bergen and it doesn't change anything.  

Thank you in advance for looking and trying to help me.  

Chris

 

 

ExecuteSQL ( "

SELECT Count (id)

FROM Account

WHERE CountyName = Bergen "

;"";"")

Screen Shot 2022-12-23 at 12.34.41 PM.png

Hi,

It may be best like that :

ExecuterSQL ("SELECT COUNT (Id) FROM Account Where CountyName = ?" ; "" ; ¶; "Bergen") ?

Happy Christmass

G

 

1 hour ago, CKonash said:

i've tried single and double quotes around the field value of Bergen and it doesn't change anything.  

String literals need to be enclosed in single quotes - e .g.  

WHERE CountyName = 'Bergen'

If that doesn't change anything then there is something else you've left out. At the very least it should change the error message.

 

Edited by comment

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

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.