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 syntax question

  •
doughemi
in Calculation Engine (Define Fields)

Featured Replies

I am trying to use ExecuteSQL() for the first time, and have run into the dreaded "?" for a very simple query.

 

I want to count all the records in the Games table where the field Won_Lost contains "WON".

 

My calc is

 

 

ExecuteSQL (
 "SELECT count(*)
FROM Games
WHERE Won_Lost = "WON" ";
 "" ; "" )
 
What have I done wrong?

Solved by Brooks

Go to solution
  • Solution

Where Won_Lost = ? " ; "" ; "" ; "WON" )

  • Author

Thanks, Brooks

The string WON should have single quotes, not double quotes (and hence no escaping either).

  • Author

Thanks, David.  I'm glad to be getting another arrow in the quiver.

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.