> I have a stored procedure that requires no parameters:
>
> ALTER PROCEDURE UNQTEACHERCLASSES
> RETURNS ( TEACHERNAME VARCHAR( 50 )
> , LASTNAME VARCHAR( 30 )
> , FIRSTNAME VARCHAR( 30 )
> , TEACHERID VARCHAR( 32 )
> , CLASSID INTEGER
> , CLASSNAME VARCHAR( 30 )
> , HOMEROOM CHAR( 1 ) )
> AS
> BEGIN
> for select distinct
> p1.firstname || ' ' || p1.lastname as TeacherName,
> p1.Lastname, p1.Firstname,
> p1.personid as teacherid
> from
> people p1
> join Classes c1 on p1.personid = c1.teacherid
> where
> p1.persontype = 1
>
> Order by p1.lastname, p1.firstname
> into
> teachername, lastname, firstname, teacherid
>
> do
> begin
> select first 1 classid, classname, homeroom
> from classes
> where teacherid = :teacherid
> order by homeroom desc
> into :classid, :classname, :homeroom;
>
> SUSPEND;
> end
> END
>
>
> It works fine when called in IB_SQL.exe. I'm trying to call it from ASTA
> and it says table "" doesn't exist. I also tried to then make a
> view based
> on the SP using IB_Expert and it gives the same error:
>
> create view UNQClassesTeacher (
> TEACHERNAME
> , LASTNAME
> , FIRSTNAME
> , TEACHERID
> , CLASSID
> , CLASSNAME
> , HOMEROOM )
> as
>
> select TEACHERNAME, LASTNAME, FIRSTNAME,
> TEACHERID, CLASSID, CLASSNAME, HOMEROOM
> from UNQTeacherClasses ;
>
> How can I get this to work?
>
> Firebird 1.5, IBObjects 4.3, Delphi 6, ASTA 3.

there are 2 ways to call an SP
EXECUTE PROCEDURE....
and
SELECT ... FROM SPNAME
which are you using. Does ASTA know how to handle either?
Alan