StrataFrame Forum

SF Parameters issue

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

By Ross L. Rooker, Sr. - 12/16/2008

The SF Framework when generating a SQL command to update Oracle takes the column name and append a 4 character "_ORG" to the name to form the parameter. The max length in Oracle is 30 characters. Is there a work around or do we need to shorten the column names in Oracle tables to 26 characters?
By Ivan George Borges - 12/17/2008

Hi Ross.

I don't think the _ORG has anything to do with Oracle specificaly, but with the concurrency type you choose. Have a look at this post:

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

By Trent L. Taylor - 12/17/2008

Ivan is right on the money.  If you use a Row Version or a TimeStamp column for concurrency, then this will not be an issue.  Also, you are FAR better off using row versions (or timestamp columns) than the all fields optimistic concurrency.  It will be significantly faster and actually make what you are trying to do less complicated.