December 10, 2012 at 8:50 am
Hi all,
I have a query more than 4000 characters limit .I am setting with variables to the query.while i used the string expression i am getting error like string expression is limited to 4000 characters limit.Is any one have idea about how to eliminate the length limit in expression.
December 10, 2012 at 9:23 am
Replace the string expression with either a code object or a stored proceduring, depending on what you are trying to do with it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 11, 2012 at 7:07 am
Fortunately the 4000 character limit is an expression limitation, not a limitation of the number of characters in the string.
I have not done this personally but you might be able to break your expression down into parts and set a variable to each section. For example Var1, Var2, Var3, SQLVar. Then
Var1 = SELECT........
Var2 = FROM.....
Var3 = WHERE....
SQLVar = Var1 + Var2 + Var3
If that doesn't work the other way is to pull the query as suggested above from SQL built as a stored procedure, or from a column in a table that stores the entire query, and then set your variable value to the string returned.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply