[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    Re: Can't use views in functions
From:       Alexey Gaidukov <gaid () dc ! baikal ! ru>
Date:       2005-06-30 7:30:17
Message-ID: 42C39F89.5060501 () dc ! baikal ! ru
[Download RAW message or body]

I miss that

drop FUNCTION GET1
//
CREATE FUNCTION GET1(p_resid varchar) returns varchar AS
VAR
r varchar(10);
f varchar(255);
begin
   SET r=p_resid;
   select max(researchtype) into :f from gis.t_restype where resid=:r 
and NOT_EXIST=false;
   return f;
END;


works well. MaxDB 7.6.00.10


Alexey Gaidukov пишет:

> CREATE TABLE "GIS"."T_RESTYPE"
> (
>    "RESID"    Varchar (10) UNICODE    NOT NULL,
>    "RESEARCHTYPE"    Varchar (255) UNICODE    NOT NULL,
>    NOT_EXIST boolean
> )
>
> //
>
> CREATE VIEW "GIS"."RESTYPE"  AS
> select "RESID","RESEARCHTYPE"
> from t_restype
> where NOT_EXIST=false
>
> //
>
> CREATE FUNCTION GET1(p_resid varchar) returns varchar AS
> VAR
> r varchar(10);
> f varchar(255);
> begin
>    SET r=p_resid;
>    select max(researchtype) into :f from gis.restype where resid=:r;
>    return f;
> END;
>
> //
>
> select get1(resid) dr from gis.t_restype
>
>
> ---- Error -------------------------------
> Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
> General error;-9205 POS(1) System error: AK Catalog information not 
> found:㐀㔀　　　　　
> select get1(resid) dr from gis.t_restype
>
>
>
>
>
>


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]