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

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: http://forum.strataframe.net/FindPost21300.aspx



Also check the CRUD section in the help file.

Edhy Rijo

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

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

Hi Les



I will review the zip file and then report the results



Thanks for the support



Greetings