Home
|
Forums
|
Contact
|
Search
|
Syndication
[login]
[create account]
Thursday, July 10, 2025
slxdeveloper.com
Home
Search
Contact us
About slxdeveloper
Syndication
Community
Forums
(NEW!)
Newsletter Archive
Members
Your Profile
Submit Article
General
Administration
(6)
OLE DB Provider
Miscellaneous
(2)
Architect
VBScript
(9)
ActiveX Controls
(6)
How To's
(14)
.NET Extensions
(3)
External
OLE DB Provider
(12)
SLAPI (SlgxApi.dll)
SalesLogix COM
(1)
Web
ASP/ASP.NET
(2)
Web Services
Web Client
Downloads
Samples
(17)
Documentation
(7)
Utilities
(18)
Resources
SalesLogix
(3)
Programming
(1)
7/10/2025 8:32:29 PM
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:
Dynamic
Flat
Tree
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'
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'
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 8:39:10 PM