Sorted Procs -- Need Help

[ArnaudAbadie]

I have create the current Procedure:
create procedure DupParam(out aram1 integer,in aram2 integer,in aram3 integer,in aram4 integer);
begin
declare :maxkey integer;
insert into param(iDB,iType,iOrder,iLien,sCod,sLib)
select iDB,iType,iOrder,iLien,'Copy'+ sCod,'Copy'+sLib from param where iKey = aram2 and iDB = aram3;
select max(iKey) into :maxkey from param;
set aram1=:maxkey;
end;
Error message retrieved we I try to run the stored procedure (from Borland C++5 program or PDAC):
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager][SPEng][Pervasive][ODBC Engine Erreur SQL general Interface] Non unique table reference: param

 

[Relloc]

Have you installed SP 3 for 2000?

Keep in mind even with SP 3 not all Stored procedures in pervasive are guaranteed to work

Isn’t P 2000 the best?

 

[Pervasivite]

You should update to SP which is also Pervasive.SQL 2000i and then test your stored procedure in the SQL Data Manager. After that test it from your application. There are several updates to PDAC that you can get if you contact Pervasive Support or make a post on the Developer's Forum on the Pervasive site called DevTalk. It also looks like there could be some problems with your DDFs or maybe there really isn't a unique table reference.

Pervasivite

 

[Guest_imported]

I'll try it as soon as possible and won't miss to know if updating my Pervasive version helps.