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

["the dragon" <ceprn@hotmail.com>]

I guess my question woiuld be, what does it matter?  It's a matter of 
microseconds between begin-setup and begin-program...

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

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

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


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