Topic
  • 1 reply
  • Latest Post - ‏2007-11-28T18:01:44Z by Kevin_Foster
SystemAdmin
SystemAdmin
228 Posts

Pinned topic checking the count (*) in routine

‏2007-11-14T10:18:23Z |
Hi,
I am developing a Procedure using SPL,Informix Client SDK v3.0,In a single procedure I have a requirement more than one statements to be execute,in that,I need to check whether records available or not in the particular table,for this,I have tried in the routine as following way:
if (select count(*) from tablename >0)then
....
end if
or
select a=count(*) from tablename
if a>0 then
...
end if

but it is not working.can u people help me .
Updated on 2007-11-28T18:01:44Z at 2007-11-28T18:01:44Z by Kevin_Foster