StrataFrame Forum

Stored Procedures

http://forum.strataframe.net/Topic1697.aspx

By Daniel Essin - 6/29/2006

I am not clear about this topic and the help isn't.



Say I have existing stored procedures GetX, PutX, DeleteX.



1 - The mapper only lists tables and views so there is no way to configure a BO to match the output of the GetX proc.



2 - There are properties of the BO like InsertStoredProcedureName, UpdateStoredProcedureName and DeleteStoreProcedureName but no documentation on how to use them. There is no property like SelectStoredProcedureName.



3 - The DDT says it will "auto generate" some stored procs but the details of what will be generated are not documented, and this generation presumably does not happen until you deploy, so it's difficult to see how one could develop towards it.



4 - There are probably other questions that I should ask but I don't have enough info to even do that.



Please clarify this topic for me.
By StrataFrame Team - 6/30/2006

Hi Daniel,

The mapper only lists tables and views so there is no way to configure a BO to match the output of the GetX proc.

Right now that is the case, though before 1.4.1 becomes a complete version, we should be able to map a business object to a stored procedure.

There are properties of the BO like InsertStoredProcedureName, UpdateStoredProcedureName and DeleteStoreProcedureName but no documentation on how to use them. There is no property like SelectStoredProcedureName.

The Insert-, Update-, and DeleteStoredProcedureName properties are used to map the business object to the stored procedures generated by the DDT for INSERTs, UPDATEs, and DELETEs.  If you want to fill a business off of a stored procedure, then you'll need to call the FillByStoredProcedure method.  If we added a SelectStoredProcedure, it would be unnecessary with the FillByStoredProcedure() method, and would be limited because you often use more than one stored procedure to fill a business object.

The DDT says it will "auto generate" some stored procs but the details of what will be generated are not documented, and this generation presumably does not happen until you deploy, so it's difficult to see how one could develop towards it.

It has been slated to allow you to "view" the code generated by a DDT stored procedure within the DDT itself.  That should also happen before 1.4.1 goes official.

There are probably other questions that I should ask but I don't have enough info to even do that.

Well, when you come up with those questions, let me know Smile

By Daniel Essin - 6/30/2006

1 - Does that mean that the DDT will generate insert, update and delete procs?



2 - If I have existing insert, update and delete procs, can I put their names into the corresponding properties of the BO? If so, what do the signatures of the stored procs need to be to be compatible with the code that you generate?



3 - When the DDT provides viewing, will it be possible to edit the code?



Thank you