I am looking for UDFs that work with long strings. All the ones I can find have a limit of 256 characters.
The functions I want are POS and PARSE.
One of our developers said he could write the UDFs, but then he found that he would have to write multiple versions. This is because our clients have various versions of Interbase (7.1, 7.5, 2007, 2009) and he says that each version of Interbase has dealt with long strings differently.
Reason behind what I want:
- I am modifying a Crystal Report that calls a stored procedure.
- We have a BLOB field that the end user is putting in multiple values separated by a carriage return.
- I want to return each value in a separate record, so I wrote a stored procedure that converts the BLOB to a long string, then parses out the string (using POS and PARSE) according to the carriage return.
This works if the string is less than 256 characters, but they are often longer so they are getting truncated.
The developer has suggested that he can write a routine in Delphi (our product is in Delphi) that will do the parsing and save the data in a temporary table. I could then access the table from my stored procedure. This would work, but I'd rather keep all the logic in the stored procedure if I could.
Any assistance would be appreciated. Thanks in advance.
The functions I want are POS and PARSE.
One of our developers said he could write the UDFs, but then he found that he would have to write multiple versions. This is because our clients have various versions of Interbase (7.1, 7.5, 2007, 2009) and he says that each version of Interbase has dealt with long strings differently.
Reason behind what I want:
- I am modifying a Crystal Report that calls a stored procedure.
- We have a BLOB field that the end user is putting in multiple values separated by a carriage return.
- I want to return each value in a separate record, so I wrote a stored procedure that converts the BLOB to a long string, then parses out the string (using POS and PARSE) according to the carriage return.
This works if the string is less than 256 characters, but they are often longer so they are getting truncated.
The developer has suggested that he can write a routine in Delphi (our product is in Delphi) that will do the parsing and save the data in a temporary table. I could then access the table from my stored procedure. This would work, but I'd rather keep all the logic in the stored procedure if I could.
Any assistance would be appreciated. Thanks in advance.