Question Re: Number of rows in the result of a sql fixed query in Product Lifecycle Management Q&A https://community.sap.com/t5/product-lifecycle-management-q-a/number-of-rows-in-the-result-of-a-sql-fixed-query/qaa-p/5075432#M23296 <HTML><HEAD></HEAD><BODY><P>Hey Matthias,</P><P></P><P>Yes you can. You can do the following in the LinkEditor under Expression:</P><P></P><PRE><CODE>SQLActionblock.Results{count(/Rowsets/Rowset/Row)}</CODE></PRE><P></P><P>Regards</P><P></P><P>Pedro</P></BODY></HTML> Thu, 29 Jan 2009 09:36:08 GMT Former Member 2009-01-29T09:36:08Z Number of rows in the result of a sql fixed query https://community.sap.com/t5/product-lifecycle-management-q-a/number-of-rows-in-the-result-of-a-sql-fixed-query/qaq-p/5075431 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>just a little question: How can I find out in a transaction if a result of a fixed query is empty or not? Do I realy have to take a "repeater" action block and look for the itemcount or is there an easier way?</P><P></P><P>thank you</P><P></P><P>Matthias.</P></BODY></HTML> Thu, 29 Jan 2009 08:52:31 GMT https://community.sap.com/t5/product-lifecycle-management-q-a/number-of-rows-in-the-result-of-a-sql-fixed-query/qaq-p/5075431 matthias_prller 2009-01-29T08:52:31Z Re: Number of rows in the result of a sql fixed query https://community.sap.com/t5/product-lifecycle-management-q-a/number-of-rows-in-the-result-of-a-sql-fixed-query/qaa-p/5075432#M23296 <HTML><HEAD></HEAD><BODY><P>Hey Matthias,</P><P></P><P>Yes you can. You can do the following in the LinkEditor under Expression:</P><P></P><PRE><CODE>SQLActionblock.Results{count(/Rowsets/Rowset/Row)}</CODE></PRE><P></P><P>Regards</P><P></P><P>Pedro</P></BODY></HTML> Thu, 29 Jan 2009 09:36:08 GMT https://community.sap.com/t5/product-lifecycle-management-q-a/number-of-rows-in-the-result-of-a-sql-fixed-query/qaa-p/5075432#M23296 Former Member 2009-01-29T09:36:08Z Re: Number of rows in the result of a sql fixed query https://community.sap.com/t5/product-lifecycle-management-q-a/number-of-rows-in-the-result-of-a-sql-fixed-query/qaa-p/5075433#M23297 <HTML><HEAD></HEAD><BODY><P>Or</P><PRE><CODE>SQLActionblock.Results{boolean(/Rowsets/Rowset/Row)}</CODE></PRE><P></P><P>Mike</P></BODY></HTML> Thu, 29 Jan 2009 12:38:20 GMT https://community.sap.com/t5/product-lifecycle-management-q-a/number-of-rows-in-the-result-of-a-sql-fixed-query/qaa-p/5075433#M23297 agentry_src 2009-01-29T12:38:20Z