| Subject | Re: [ib-support] Substring? |
|---|---|
| Author | Helen Borrie |
| Post date | 2001-08-18T08:55:27Z |
At 12:20 AM 18-08-01 -0700, you wrote:
Declaration:
DECLARE EXTERNAL FUNCTION substr
CSTRING(80), SMALLINT, SMALLINT
RETURNS CSTRING(80) FREE_IT
ENTRY_POINT "IB_UDF_substr" MODULE_NAME "ib_udf"
The syntax is unconventional - the first smallint argument is the startpos of the substring, the second is the endpos. You'll get an error if either number is outside the range of the stringlength.
Similar UDFs in other libraries are more conventional, I think.
Helen
]
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>So, are you saying that NONE of the three examples that you gave will work for IB 5.6, and that there is no way to do what I want?You can use the substr() UDF in Borland's ib_udf.dll.
Declaration:
DECLARE EXTERNAL FUNCTION substr
CSTRING(80), SMALLINT, SMALLINT
RETURNS CSTRING(80) FREE_IT
ENTRY_POINT "IB_UDF_substr" MODULE_NAME "ib_udf"
The syntax is unconventional - the first smallint argument is the startpos of the substring, the second is the endpos. You'll get an error if either number is outside the range of the stringlength.
Similar UDFs in other libraries are more conventional, I think.
Helen
]
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________