Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Christian Tabligan
  Where is Christian Tabligan?
 Bacolod City, Neg. Occ.
 Philippines
 Christian Tabligan
 To: Adam Walan
  Where is Adam Walan?
 Chicago
 Illinois - United States
 Adam Walan
 Tags
Subject: RE: order by deleted()
Thread ID: 268652 Message ID: 268708 # Views: 31 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: VFP and .NET
Date: Wednesday, July 14, 2010 7:12:26 AM         
   


> Hi,
> Is tehere a simple way to sort my cursor and display deleted records on the top ? I tried
> SELECT .... order by deleted()
>
> but this is giving me an eror.
>
> Thanks,

hope this help.

set safety off
create table temp (letter c(1))
insert into temp values ("A")
insert into temp values ("B")
insert into temp values ("C")
insert into temp values ("D")
insert into temp values ("E")
insert into temp values ("F")
delete from temp where inlist(letter, 'A', 'C', 'F')
set deleted off
select *, "INACTIVE" as cStatus from temp where deleted();
union all;
select *, "ACTIVE" from temp where !deleted()


If you are using My Sql, i suggest that you put another field to identify what record has been deleted or not.

Sample:
select * from YourTable where cStatus == "INACTIVE";
union all;
select * from YourTable where cStatus == "ACTIVE"


Best Regards,

CriZ (,")

"Happiness is real when shared."

ENTIRE THREAD

order by deleted() Posted by Adam Walan @ 7/13/2010 7:19:47 PM
RE: order by deleted() Posted by Yousfi Benameur @ 7/13/2010 7:40:57 PM
RE: order by deleted() Posted by Adam Walan @ 7/13/2010 7:55:29 PM
RE: order by deleted() Posted by Mike Yearwood @ 7/13/2010 10:21:48 PM
RE: order by deleted() Posted by Christian Tabligan @ 7/14/2010 7:12:26 AM
RE: order by deleted() Posted by Mike Yearwood @ 7/14/2010 7:40:53 PM
RE: order by deleted() Posted by Christian Tabligan @ 7/15/2010 2:01:50 AM
RE: order by deleted() Posted by Mike Yearwood @ 7/15/2010 7:05:59 AM
RE: order by deleted() Posted by Christian Tabligan @ 7/15/2010 7:48:55 AM
RE: order by deleted() Posted by Mike Yearwood @ 7/15/2010 6:50:28 PM