Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ammar Hadi
  Where is Ammar Hadi?
 Al-Samawah
 Iraq
 Ammar Hadi
 To: Tai Nguyen
  Where is Tai Nguyen?
 
 United States
 Tai Nguyen
 Tags
Subject: RE: code to mark for delete
Thread ID: 228441 Message ID: 228523 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, May 19, 2009 3:44:52 PM         
   


> Good morning from American Ammar, hahaha. How are you doing? I love foxite too. People contributed quite a lot to me in this forum. The way my tables designed without myID as some unique ids and so when I ran your code, it deleted all the records in the table. Here is the code I made it to work with my tables (your code refreshed my memory a little bit and I think your code would work with that design too.) Thanks for the help. By the way, yes the tables are identical (sorry, training is table1).
>
> This code worked:
>
> SET DELETED OFF
>
> SELECT Table1
> SCAN FOR DELETED("Table1")
> DELETE record RECNO("Table1")IN Table2
> ENDSCAN
>
> Tai Nguyen.

Hi Tai, Good evening from Iraq my friend . :-) am doing well struggling life here trying to do the best for me, my family and friends ;-)

Just take care not to allow the two tables to be ordered differently to be sure that recno() of the deleted rec in table1 is the same recno() that should be deleted in table2.

Greetings to the states. I love it.

Ammar Hadi ................IRAQ

My Foxite Weblog

---------------
I I I really love foxite
___________________________

ENTIRE THREAD

code to mark for delete Posted by Tai Nguyen @ 5/18/2009 11:48:01 PM
RE: code to mark for delete Posted by Ammar Hadi @ 5/19/2009 12:51:30 AM
RE: code to mark for delete Posted by Tai Nguyen @ 5/19/2009 3:30:02 PM
RE: code to mark for delete Posted by Ammar Hadi @ 5/19/2009 3:44:52 PM
RE: code to mark for delete Posted by Tai Nguyen @ 5/19/2009 7:26:48 PM
RE: code to mark for delete Posted by Ammar Hadi @ 5/20/2009 10:57:07 AM
RE: code to mark for delete Posted by Tai Nguyen @ 5/20/2009 5:02:37 PM
RE: code to mark for delete Posted by M. Akram Bhatti @ 5/19/2009 6:54:22 AM
RE: code to mark for delete Posted by Tai Nguyen @ 5/19/2009 3:34:09 PM
RE: code to mark for delete Posted by Ravi Taxali @ 5/21/2009 4:00:27 PM