StrataFrame Forum » Updates and Information » StrataFrame Users Contributed Samples » Problem Delete rows using stored procedure

Problem Delete rows using stored procedure

Douglas Hernandez — Mon, 07 Dec 2009 14:02:30 GMT

Hi

I created a stored procedure called Tablebo1_Delete for my business object
I set my business object on the following properties:
DeleteUsingStoreProcedure = true,
DeleteConcurrencyType = OptimisticTimestamp,
RowVersionOrTimestampColumn = version (timestamp column on database table)

My business object Tablebo1.DeleteCurrentRow () delete the row of the grid but not in the database

I hope for any advice

RE: Problem Delete rows using stored procedure

Douglas Hernandez — Mon, 07 Dec 2009 14:02:30 GMT

Hi Les

I will review the zip file and then report the results

Thanks for the support

Greetings

RE: Problem Delete rows using stored procedure

Les Pinter — Mon, 07 Dec 2009 08:23:25 GMT

Dear Douglas,

I created a SQL database called Pinter (my favorite name for testing) with a Contacts table and stored procedures to add, edit and delete records. The script file called "CreatePinterDatabaseTablesAndProcs.sql" in the attached ZIP that will create the database, table and procedures and insert four records for testing.

I then wrote the little application included in the ZIP file. It uses stored procedures to add, edit and delete records, and all three functions work as advertised. Took about three minutes to write.

If you'll zip up your application and send it to me, I'll take a look at it. Please include generated scripts for the stored procedures for your table.

Les

RE: Problem Delete rows using stored procedure

Peter Jones — Sun, 06 Dec 2009 16:39:49 GMT

Hi Douglas,

FWIW: When we first started using StrataFrame I was very interested in the pros and cons of using stored procedures from an efficiency point of voew. We have an industrial application that is adding new transactions at about 30 per minutes, 12 hours a day and our main transaction table contains around 11 million rows. While we use stored procedures for all work to do with populating BO's we just leave the CRUD to StrataFrame (i.e. we don't use procs for deleting, inserting etc). We came to this decision after extensive testing that showed there was no performance advantage in using procs.

We found it was very much easier to leave SF to do the heavy lifting in this area.

Cheers, Peter

RE: Problem Delete rows using stored procedure

Douglas Hernandez — Sun, 06 Dec 2009 11:44:09 GMT

I have tried in various ways, such single stored procedure to delete by primary key and not my business to use the stored procedure

RE: Problem Delete rows using stored procedure

Edhy Rijo — Sun, 06 Dec 2009 11:22:58 GMT

Hi Pedro,

Do a search in the forum using the word "Concurrency" and you will find plenty information about this.

Here is one link I found: [url=]http://forum.strataframe.net/FindPost21300.aspx[/url]

Also check the CRUD section in the help file.