Hi all.

I have a table with 140 fieds.
Named c1, c2.. c 140.

c1..c140 are type integer

Now I have to count some values into them.

this is a code snippet:
-- ******************************************
cnt = 1; s0 = 0;
while ( :cnt < 101 ) do begin
if ( 'new.c' || :cnt = 0 ) then s0 = :s0 + 1;
cnt = :cnt + 1;
end
-- ******************************************

Firebird refuse this : 'new.c' || :cnt.

So don't works.

Anyone could help??

Thanks

Arn