slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: A warning to others: 'Tools / Execute SQL and the single quote'

Phil Parkin
Posts: 819

A warning to others: 'Tools / Execute SQL and the single quote' Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Jun 08 11:16 PM

OK, while not being quite as interesting as 'Sex and the Single Woman', I'm posting this in the hope that it saves someone a lot of time. If if does, please feel free to send me a donation

I recently had a client who needed some SQL: I wrote the SQL and sent instructions about how to run it using Tools / Execute SQL.

The exact SQL does not matter, but try this in the eval database:

update account set status = 'Active' where status = 'Active'

OK so far.

Now try this one:

update account set status = ‘Active’ where status = ‘Active’

I tried it on 7.2.1 - not sure on other versions - but you will find that when you try to execute this SQL, it will freeze your system and you will have to kill Administrator via Task Manager. So what's wrong?

The second version was typed into Outlook and sent to the client. Outlook helpfully changed the single quote for me because I have the 'Auto-format' feature turned on. Here is a quote from the Outlook help:

1. Replace as you type
"Straight quotes" with “smart quotes” Replaces straight quotation marks ( " " ) and straight apostrophes ( ' ) with curved, open- and closed-quotation marks ( ) and curved apostrophes ( ).

I'm happy that Outlook does this. I'm not happy that it took hours to diagnose though

[Reply][Quote]

Carla Tillman
Posts: 290

Re: A warning to others: 'Tools / Execute SQL and the single quote' Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Jun 08 12:50 PM

Good catch!

c

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/10/2025 10:23:04 PM