Zoltan_Gyimesi
Legendary Poster
ER Design issue, XE SP 13
Removing leading and trailing blanks from a string variable I have used ltrim and rtrim string functions in ealier releases than XE. I marked the space char bordered by single or double quotes:
VA evt_VC10A_TmpString = ltrim([VA evt_VC10A_YearPart]," ")
Under XE SP 13, after I close the expression and re-open it in the ER Designer, the quotes has been removed and I can't save the expression with OK because I get "missing parameter" error message.
My questions:
1.) How do I have to mark the SPACE in RTRIM and LTRIM?
2.) Has this problem been corrected in a higher SP? If yes, then in which?
PS.:
1.) I know that I can workarround this problem storing space char in a work variable and use it in the expression.
2.) This problem doesn't occur for space parameters in INDENT, LPAD, RPAD strin functions.
This time: XE SP 13
Zoltán
B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
Removing leading and trailing blanks from a string variable I have used ltrim and rtrim string functions in ealier releases than XE. I marked the space char bordered by single or double quotes:
VA evt_VC10A_TmpString = ltrim([VA evt_VC10A_YearPart]," ")
Under XE SP 13, after I close the expression and re-open it in the ER Designer, the quotes has been removed and I can't save the expression with OK because I get "missing parameter" error message.
My questions:
1.) How do I have to mark the SPACE in RTRIM and LTRIM?
2.) Has this problem been corrected in a higher SP? If yes, then in which?
PS.:
1.) I know that I can workarround this problem storing space char in a work variable and use it in the expression.
2.) This problem doesn't occur for space parameters in INDENT, LPAD, RPAD strin functions.
This time: XE SP 13
Zoltán
B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)