create cursor SchnapsTmp ; ( a c(1), ; b c(1),; c c(1) ; ) insert into SchnapsTmp values ('', 'x', 'y') insert into SchnapsTmp values ('', 'x', 'y') insert into SchnapsTmp values ('a', 'x', 'y') insert into SchnapsTmp values ('b', 'x', 'y') insert into SchnapsTmp values ('c', 'x', 'y') select * ; from SchnapsTmp, ; ( select count(*) as NumberA from SchnapsTmp where ( a <> '') ) XX; into cursor Schnaps use in SchnapsTmp && report cursor = Schnaps