StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Stored procs

Stored procs

Daniel Essin — Mon, 10 Jul 2006 10:08:13 GMT

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

RE: Stored procs

Daniel Essin — Mon, 10 Jul 2006 10:08:13 GMT

thank you

RE: Stored procs

StrataFrame Team — Mon, 10 Jul 2006 08:35:40 GMT

Sorry, forgot to post it. It's out in the downloads section, now.

RE: Stored procs

Daniel Essin — Sun, 09 Jul 2006 13:49:58 GMT

I don't see any version of the DDT help dated in July. What am I misssing?

RE: Stored procs

Daniel Essin — Thu, 06 Jul 2006 13:21:15 GMT

Thanks

RE: Stored procs

StrataFrame Team — Thu, 06 Jul 2006 11:10:44 GMT

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

Yes, the current pre-release version of 1.4.1 can generate separete sprocs for INSERTs, UPDATEs, and DELETEs.

[quote]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?[/quote]

Yes, you can use your own stored procedures for the business objects by entering the stored procedure names in the properties on the business objects. The parameters the business object is expecting are described within the newest version of the DDT help, which I am posting in the MyAccount are of the website today.

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

No, the DDT will not allow you to edit the code, but you can use the viewable code as a template to create your own stored procedures.