StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » SF Parameters issue

SF Parameters issue

Ross L. Rooker, Sr. — Wed, 17 Dec 2008 09:13:21 GMT

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?

RE: SF Parameters issue

Trent L. Taylor — Wed, 17 Dec 2008 09:13:21 GMT

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.

RE: SF Parameters issue

Ivan George Borges — Wed, 17 Dec 2008 08:49:56 GMT

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