Subject | quick question |
---|---|
Author | martinknappe |
Post date | 2006-07-17T19:39Z |
hi
can any of you tell me why i get an 'invalid escape sequence' error
when trying to execute this procedure:
CREATE PROCEDURE GET_NEXT_20_LI_ASTERM (
"TERM" varchar(240) character set unicode_fss,
idin bigint)
returns (
id integer)
as
begin
for select first 20 id from dicentries where asterm like '\\\' ||
:term || '\\\' escape '\\\'
and id > :idin order by id ascending into :id do
suspend;
end
thanx,
martin
can any of you tell me why i get an 'invalid escape sequence' error
when trying to execute this procedure:
CREATE PROCEDURE GET_NEXT_20_LI_ASTERM (
"TERM" varchar(240) character set unicode_fss,
idin bigint)
returns (
id integer)
as
begin
for select first 20 id from dicentries where asterm like '\\\' ||
:term || '\\\' escape '\\\'
and id > :idin order by id ascending into :id do
suspend;
end
thanx,
martin