[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] sql delete from table where 1 = 1
- Subject: Re: [sqr-users] sql delete from table where 1 = 1
- From: prashanth reddy <bpreddy78@yahoo.com>
- Date: Mon, 23 Jan 2006 08:39:54 -0800 (PST)
- Delivery-date: Mon, 23 Jan 2006 11:44:26 -0500
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;b=l4R8BfwdA1dOlOE09tXsoN4IFAtwr+/ugTUZSvrdhmF7+5szj0cy1qFJc7LQhYR+VreP70CfxTOGJfMotW6VM35MATg+TFoj5huprK5PYAYk+aVCp0pa0ipgEwYimWQ69/4E7hi8DKzR+JavzCUW/2VmRaC8+p5aiXpHlYjsD5A=;
- In-reply-to: <s3d4bf74.035@gwia201.syr.edu>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Thanks for the reply,
When do you use the condition where 1 = 1. What does
it actually mean.
--- Larry Roux <LRoux@syr.edu> wrote:
> 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
>
__________________________________________________
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