I want to update a column in myTable. The value this column is set to depends
on a
nested select statement which sometimes returns 0 rows instead of 1. This is a
problem since the column I'm trying to update is set to refuse nulls. Here's a
sample:
update myTable set myColumn = (Select altColum
On Mon, 09 May 2005 12:57:41 -0400, Mark Fenbers wrote
> I want to update a column in myTable. The value this column is set
> todepends on a nested select statement which sometimes returns 0
> rowsinstead of 1. This is a problem since the column I'm trying to
> updateis set to refuse nulls. Here
On 5/9/05, Mark Fenbers <[EMAIL PROTECTED]> wrote:
> I want to update a column in myTable. The value this column is set to
> depends on a nested select statement which sometimes returns 0 rows instead
> of 1. This is a problem since the column I'm trying to update is set to
> refuse nulls. Here
I want to update a column in myTable. The value this column is set to
depends on a nested select statement which sometimes returns 0 rows
instead of 1. This is a problem since the column I'm trying to update
is set to refuse nulls. Here's a sample:
update myTable set myColumn = (Select altC
it is about null problem
declare
res numeric(15,2);
_pida integer[4]; < Problem is here must be ---> pida
integer[4]='{}';
_pid integer;
_rec record;
..
"ALÝ ÇELÝK" <[EMAIL PROTECTED]>, haber iletisinde þunlarý
yazdý:[EMAIL PROTECTED]
>
> I have a