3/16/2026 7:30:00 AM
|
| |
| 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!
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.
|
|
|
|
Custom Table Query causes locking
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. |
|
|
|
Re: Custom Table Query causes locking
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 
PP |
|
|
| |
|
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!
|
|
|
|
|
|
|
|