Re: [sqr-users] sql delete from table where 1 = 1

["Larry Roux" <LRoux@syr.edu>]

Are you sure it is 1 = 1 and not I = 1?  If it is as listed then 1 = 1 would 
always be true and all rows would be deleted (and so the where claude is 
unnecessary).




Larry Roux
Syracuse University
lroux@syr.edu


>>> bpreddy78@yahoo.com 01/23/06 11:31 AM >>>
Hi,

I'm testing a sqr, I found a procedure
delete-old-data.
I'm not sure how the Where statement is identifying
the old data, Where 1 = 1.

BEGIN-PROCEDURE DELETE-OLD-DATA
!**************************************************************************
BEGIN-SQL
DELETE FROM TABLE_NAME WHERE 1 = 1
END-SQL

END-PROCEDURE

Please can someone enlight me...

Thanks 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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


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