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!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Custom Table Query causes locking

Jeff Parker
Posts: 32

Custom Table Query causes locking Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Nov 07 12:02 PM

We have Custom table, 1-to-1 extension table on Account Table. It's called C_ITS_Account table. The Account Detail Form has fields on it from both the Account and the C_ITS_Account tables. When I perform this query in Enterprise manager
SELECT * FROM C_ITS_ACCOUNT ORDER BY CREATEDATE DESC
it locks the table and SalesLogix for the most part when you try to update info on the Account Details form. Any ideas why that query would lock the table? The same query on the Parent ACCOUNT table doesn't create a lock.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Custom Table Query causes locking Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Nov 07 12:05 AM

Hmm - as far as SQL Server is concerned, there is no relationship between the two tables (so querying one will not directly affect the other).

So the locks are being caused by the nature of INSERT/UPDATE statements coming from SLX, in combination with the read lock that SELECT asserts.

Suggest you use

exec sp_lock

to verify the locking behaviour - and why it varies between the two tables. You may also have to use SQL Profiler to find out which SQL commands are being issued and what is causing the locks. Not a whole load of fun

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Custom Table Query causes locking Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Nov 07 12:08 AM

Or you could use the WITH NOLOCK hint on your EM query.

[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): 6/20/2025 11:11:10 PM