Seems like I would have to subclass mmSecurityControlIDEditForm and change the following declaration:

///

/// Security business object
///

protected mmSecurity oSecurity = new mmSecurity();

to this:

///

/// Security business object
///

protected otsSecurity oSecurity = new otsSecurity();

recompile the automation project.


Is this possible?


>Kevin,
>
>I think I see what's happening. I subclassed the Security class as well as others User, Roles, etc in order to override any place in the class where a select statement is created. I had to do this in order to add the Oracle Schema name as prefix to the table name and eliminate the brackets in the select statement:
>
>Select * FROM OTS_APP.SECURITY ...
>
>Instead of:
> SELECT * FROM [SECURITY] ...
>
>
>Now at design time "mmSecurityControlIDEditForm" would know nothing about this and still use its standard version of the Security Class which has the brackets and no oracle schema name prefixing the table. Even if I could do without the Oracle Schema name, which might be possible, Oracle cannot tolerate the square brackets in the select statement.
>
>If I am correct on this, how can I resolve this issue with the framework?
>
>
>
>>Clay,
>>
>>>One of the errors I got was from the [Security Control Id setup] dialog at design time.
>>>
>>>***The error read: Unable to create record in security table
>>>
>>>I received this error when I clicked on the Generate Control Id button.
>>>
>>>Since this is at design time,how can I trace it?
>>>
>>>All my data is Oracle
>>>the security table was setup following the schema in the documentation.
>>
>>The code that's executing when you launch the builder can be found in the "Mere Mortals Framework Automation" project in "mmSecurityControlIDEditForm.cs". As you can see by looking through the code, the form has the following method that must be failing:
>>
>>

private void btnGenerateID_Click(object sender, System.EventArgs e)
>>{
>>	this.ControlID = Guid.NewGuid();
>>	try
>>	{
>>		this.oSecurity.NewRow();
>>	}
>>	catch (Exception ex)
>>	{
>>		MessageBox.Show("Unable to create a new security record.");
>>		return;
>>	}

>>
>>Although you CAN step through code in design-time builders within VS .NET, I find it often doesn't work properly (VS .NET "issues")! What I recommend as an easier first step is to instantiate an instance of the Security business object at run time and see if you can add a new row.
>>
>>Regards,