[sqr-users] if not exists (select * from sysobjects where name='<>') = processing should stop

[Jay Sagadraca <knight7883@yahoo.ca>]

Hello Gurus,
   
      Thank you for your help.  But 1 more question please.  How about in the 
begin-setup area?  Can we stop the whole process if the table is not created? 
   
    begin-setup 
begin-sql on-error=stop 
if not exists (select 1 from sysobjects where name = 'Transaction_Table') 
begin 
  raiserror 20004 "Table: Transaction_Table do not exist " 
end 
end-sql 
begin-sql 
if exists ( select 1 from sysobjects where name = 'Clients') 
   begin
       print "Found the table ..."
      end
  end-sql 
end-setup 
   
  Thanks,
   




Jay V. Sagadraca

Markham, Ontario, Canada

email : knight7883@yahoo.ca

                
---------------------------------
Make Yahoo! Canada your Homepage Yahoo! Canada Homepage  

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users