[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re[2]: Processing results from a stored procedure



     >>>> If you want to return a character string greater than 30 
     >>>> characters in length, make sure you pre-allocate the string 
     >>>> with spaces.  SQR will trunc it to 30 chars as this is their 
     >>>> default, and they have no idea the length of the returned value.
     
     FYI, this was further improved in SQR Version 3 where you don't need 
     to pre-allocate any more and SQR will handle the length.
     
     If any of you SQR users out there want to take part in the SQR Version 
     3 beta program (on SunOS, HP-UX, AIX, VMS or Windows), call MITI at 
     310-424-4399 ext. 363 or email to "sqrbeta@miti.com".
     
     Gadi Yedwab
     MITI