Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's up with Concurrency and MM .NET (GetConflictData?
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
01317518
Message ID:
01321988
Views:
30
Jeff,

>Here's some more data on this issue. I'm using VS2008, SQL Server 2000, and MM .NET 3.5.
>
>Here's the trace from the SQL Profiler when I call GetConflictData():
>
>exec sp_reset_connection
>go
>SET TRANSACTION ISOLATION LEVEL READ COMMITTED;BEGIN TRANSACTION
>go
>exec dbo.employeeUpdate @emp_id = 'PSA89086M', @fname = 'Ferd', @hire_date = 'Nov 11 2008 12:00:00:000AM', @job_id = 14, @job_lvl = 89, @lname = 'Afonso', @minit = 'S', @pub_id = '1389'
>go
>COMMIT TRANSACTION
>go
>exec sp_reset_connection
>go
> SET FMTONLY OFF; SET NO_BROWSETABLE ON;
>go
>exec dbo.employeeSelectByPK @emp_id = 'PSA89086M'
>go
> SET NO_BROWSETABLE OFF;
>go

I'm not able to duplicate this...is it possible the value of the ConcurrencySelectStatement property has been set in this business object? If it's not readily apparent, I recommend setting a breakpoint in mmBusinessObject.GetConflictData(string tableName, string physicalDbcObjectName, object[] pks, string[] pkFields) to see how it's building the SELECT statement that retrieves conflict data.

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