We need to see the contents of your Stored Procedure.... ----- Original Message ----- From: "ELOEN" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, January 03, 2003 1:41 AM Subject: [RBASE-L] - Stored Procedure in Where Clause
> Hello brotherhood of R! > > could someone confirm this? > > If I use a stored procedure in a WHERE clause, it returns all the rows in > the table. > For example: > > SELE ... WHERE (CALL stp_name(stp_prmtrs)) IS NOT NULL > > returns all the rows, where as > > SELE (CALL stp_name(stp_prmtrs)) FROM ... > > returns null and not null values. > > OS: win2k > Rbase Vers:1.862 x RT03 Win > > TIA > Polychronis T. Kontos > Athens, Greece > >
