Closed paulfisher53 closed 6 years ago
I have added a new field to the Table Designer called "Options" (similar to the Page Designer). This field will allow us to add options to the table definition.
If you add the option 'nolock' (without the quotes), it will add the WITH (NOLOCK) hint to the FINDSET function for that table. (See screen shot below)
Please load these binaries to your website to get this functionality: bin.zip
I have added the nolock option to the Xpress Change Log Table. Please load this object file: TABL Xpress Change Log.zip
I am getting above error when i am importing the change log table object.
Looks like your missing CU8 code again just like in issue #22. Please apply the same fix
After applying CU8 code i was able to import change log object but when i run the Change log report i dont see with (nolock) syntax in the query executed.Used sql profiler to verify
Did you apply the DLL's from my first comment? When I run the Xpress Change Log table I get this:
Yes i applied the dll from bin.zip.I confirmed by viewing design table page where i can see the option field for table object.
This is an issue with your local environment. If you fix it and are still having issues with this mod, please re-open this issue
Since some tables are transactional based (Only insert not an update) it’s safe to use “with (nolock)” option after the table to eliminate the locking of tables. This will improve the performance of FINDSET drastically without locking.
Need provision to add no locks for tables while querying using FINDSET or lookups.