Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
BIG script parameters |
Sun, Mar 2 2008 8:39 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
VARCHAR's are limited to 512 characters so I guess if I need a larger parameter than that I'd need to use a CLOB and from my quick experiment it seems that all I need to do is alter the parameter type. Is it really that simple? Roy Lambert |
Mon, Mar 3 2008 7:22 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< VARCHAR's are limited to 512 characters so I guess if I need a larger parameter than that I'd need to use a CLOB and from my quick experiment it seems that all I need to do is alter the parameter type. Is it really that simple? >> Actually it's simpler than that - VARCHARs really don't have a limit for parameters and variables in SQL/PSM. The limit only applies to columns. Also, in case you didn't know, you can just declare a VARCHAR parameter or variable as simply VARCHAR with no length specifier, and it will behave just like a String declaration in Delphi. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Mar 3 2008 7:46 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
<<and it will behave just >like a String declaration in Delphi.>> THAT BIT I didn't know - thanks. Roy Lambert |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |