Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET NO_BROWSETABLE causing problems
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 4.0
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01505760
Message ID:
01506079
Views:
58
Linda,

>I'm having trouble with people not being able to run reports or queries because of a record lock. When I tracked down the problem, it appears that MM is adding code to my stored procedures SET NO_BROWSETABLE ON before the query. That is causing reports and queries to hang up until the user saves or cancels changes. Do I need to have different procedures to pull data for viewing/reporting than I do for updating? If so, what do I need to do differently?

It looks like this code is only inserted when calling GetEmptyDataSetBySproc(). Is that the method that's being called in this case?

Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform