Is there a lenght limitation in SP name (OpenInsight 32-bit Specific)
At 04 JUN 2004 09:21:29PM Ray Chan wrote:
To all,
I'm using OI4.13. Is there a lenght limitation for the name of a Stored Procedure? According to the help, it should be 50 characters, but when I tried to save a procedure with a name greater than 33 or 34 char, I'm not able.
Does the documentation needs to be updated? Or is there a trick or switch that you have to use.
I'm running on XP Pro.
Thanks,
Ray Chan
At 05 JUN 2004 10:02AM support@sprezzatura.com wrote:
What's your app name? (MYSTOREDPROCEDURENAME*APPNAME)
support@sprezzatura.com
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
At 05 JUN 2004 05:37PM Ray Chan wrote:
AppName=Symmetry
The Stored Procedure Name was going to be (I think)
DBW_EDI_TRANSACTION_SET_PROPERTIES_EVENTS (41 CHAR), but was too long so I had to truncate it to about 30 something ;-(
If you can try it, could you tell me if you can enter a SP with a name longer than the width of the listbox. I even tried to fool it by copying a program with that name (e.g., copy_row), but I kept getting an invalid character message.
Thanks,
Ray
At 07 JUN 2004 08:10AM Sean FitzSimons wrote:
Ray,
I was able to name the stored procedure DBW_EDI_TRANSACTION_SET_PROPERTIES_EVENTS_123456, however the Open and Save Dialogs within the System Editor only allowed for the entry of 31 characters. The only way I was able to save was by doing a Save and Compile when building the procedure from scratch.
The new Editor in OpenInsight 7 has no such limitation.
Sean