Locks and removal thereof

[jeanfrancois]

Hi

What affect will it have if I delete t_seclocks through my own sql queries (which I currently do), is it a bad thing? I assume so since they don't allow these modification queries through the normal SQLQuery(), only select statements?

How is deleting these locks manually through sql different than removing them from in EA through Project -> Security -> Manage Locks.

The trouble is, the model needs to be unused during a process, and currently I check if locks exists in the database belonging to another user, and if so throw an exception. But how safe it is to kick that user out?

Regards.
Jean

[Geert Bellekens]

Jean,

I don't think you are going to get into trouble by deleting locks from the database directly.

SQLQuery will indeed not allow you to edit the database, but Repository.Execute(sqlString) will.

Geert

[jeanfrancois]

Thanks Geert I cant't find that function in my documentation in EA, but I see it is there in code.

Your help has always been most appreciated!

Jean

[Geert Bellekens]

Thanks Geert I cant't find that function in my documentation in EA, but I see it is there in code.

That would be expected as it is an undocumented method

Geert