Community

Has anyone enhanced the Stored Procedures template to handle "timestamp " datatypes?

I guess none of the users on the forums have.

What exactly do you need to know about this?  It shouldn't be that big of a deal to do.

Just wanted to find out if other people got creative out there and would share.

I did create my own scripts / customized the Stored Proc script to deal with Inserts and Updates when a timestamp column is present in a table structure. It all depends on the tasks you need to deal with...

Feel free to post anything you want to share on this forum.  There is a files section if you want to upload something.  In the meantime, we are currently developing a CodeBreeze Gallery so users can share project or code templates.  Won't be done for a couple of months though.

Also, you can now follow  CodeBreeze on Twitter.

I've been away from the forum for a while but yes, I've modified the Stored Procedure template extensively. Since we were using a timestamp field to manage concurrency this needed to be included in all modifying procedure calls (but could not be updated).

I needed to modify the stored procedures template as well as the helper class.

Since this is an old post, if you're still interested in timestamp handling I can post the template I created.

I haven't done it yet, but I think you would have to modify the GetType method in the provider and add the new data types there to be handled.  Is this what you did?