Preparing query:
CREATE PROCEDURE FIELD_FROM_SUBSTR (
TABLENAME Char(31),
FIELDNAME Char(31),
STRSUBSTR Varchar(255) )
RETURNS (
NOM Varchar(255) )
AS
DECLARE VARIABLE S VARCHAR(32);
DECLARE VARIABLE STMT VARCHAR(1024);
BEGIN
S=lower(:StrSubStr COLLATE UTF-8);
STMT='SELECT '||FieldName||' FROM '||TableName||' WHERE lower('||FieldName||') LIKE ''%'||S||'%''';
FOR EXECUTE STATEMENT STMT INTO :NOM
DO SUSPEND;
END
Error: *** IBPP::SQLException ***
Context: Statement:
repare(
CREATE PROCEDURE FIELD_FROM_SUBSTR (
TABLENAME Char(31),
FIELDNAME Char(31),
STRSUBSTR Varchar(255) )
RETURNS (
NOM Varchar(255) )
AS
DECLARE VARIABLE S VARCHAR(32);
DECLARE VARIABLE STMT VARCHAR(1024);
BEGIN
S=lower(:StrSubStr COLLATE UTF-8);
STMT='SELECT '||FieldName||' FROM '||TableName||' WHERE lower('||FieldName||') LIKE ''%'||S||'%''';
FOR EXECUTE STATEMENT STMT INTO :NOM
DO SUSPEND;
END )
Message: isc_dsql_prepare failed
SQL Message : -204
Undefined name
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -204
Data type unknown
COLLATION UTF is not defined
Partager