ahem..

Ben, don't forget I'm an absolute beginner in .NET, so I don't know how to put this breakpoint in SF sourcecode in my project

Could you advise please, I'm lost now and here
Thanks

Michel

If you have the SF source code built in debug, then put a break point in the DataLayer.vb file (in the MicroFour StrataFrame Business project in the Data folder) somewhere around line 1120 on the HandleConcurrencyException method.  This method will be called when the server returns 0 for the number of records affected by the delete.  You can see what it's doing by stepping through it.

Ben,

I'm handling it in the ConcurrencyException event of the BO. Never raised...

Local line is deleted in BO, not on server (I can see it by loading another instance of the same MaintenanceForm).

How could I debug that? where should I put a breakpoint?

Hrm.  That is very odd.  The addition of the extra parts to the WHERE clause will prevent the line from being deleted (just like it should), however, it should be raising an concurrency exception.  Looking at the source code, if the local line is deleted, it will raise the ConcurrencyException just like normal. 

Just out of curiosity, are you expecting to wrap the Save() in a Try/Catch or are you handling the ConcurrencyException event of the business object?

Thanks Ben,

I begin to understand... here is the SQL command really sent by the BO (concurrency mode set on allfields, so all the additional WHERE clauses are correct):

@volumax_ORG was 10 on A client side when BO was filled, and User B upadated its related field to 100 before A asked for deletion.
So my SQL command would never raise an exception, since there was no line matching on the server!

I totally misunderstood the purpose of DeleteConcurrencyType, wich is only to add the additional where clauses, right?

How could I retrieve the result of the delete command (boolean or #line deleted) without writing a specific procedure?
Or is it a better practice to create a property "is_deletabled" on my BO class, and to check in beforedelete method to switch that property to True or False, so it could be retrieved by beforedelete methode on UI layer?

and the SetDebugOn is really a very nice tool

Is the event being raised and there is nothing in the event args, or is the collision not being detected?  If the collision is not being detected, you can always turn on Debugging for the data source (MicroFour.StrataFrame.Data.DataBasics.DataSources("").SetDebugOn()) and check the command that is being executed to make sure that it would be albe to find the collision.

Hi,

I'm now creating my own collision form, so I'm working with ConcurrencyException; seems quite easy to manage for collision on update, but I've not found how to do for delete.

say Table1 "cuves" with a cuve_pk autointeger, a field numcuve C(15) unique, and a field qtstock integer

user A is loading dataset from cuves using a BO in a "StrataFrame built" application, and navigates to line n
user B is updating numcuve or qtstock on the same line n from within an other application
user A calls delete on that line n

Delete is not committed on server, but there is no collision in concurrencyexception (DeleteConcurrencyType is set to OptimisticAllFields)

Why? how to do? where?

Sounds good.  We look forward to working with you

Don't worry, Trent!

I've bought StrataFrame as a framework, not as a wizard ; I'll create my own collision form, and come back soon with other questions.

At the moment, no.  But you are correct in that it should probably be localized.  We will take a look at this.  But for now, you can create your own to get around the issue.  Sorry.