Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tariq Mehmood
  Where is Tariq Mehmood?
 BAHAWALPUR
 Pakistan
 Tariq Mehmood
 To: Rashid Mehmood
  Where is Rashid Mehmood?
 Sialkot
 Pakistan
 Rashid Mehmood
 Tags
Subject: RE: Generate Log File
Thread ID: 365813 Message ID: 365815 # Views: 82 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Monday, December 31, 2012 4:36:23 PM         
   


> Hi Experts
>
> I want to create a log file where store every modified record from my table name employe. which way i create that modified record.
>
>
> Thanks in advance

Welcome back to Visual Foxpro


create cursor table1 (sno n(3),name c(15),city c(15))
insert into table1 values(1,"Rashid","Sialkot")
insert into table1 values(2,"Tariq","Bahawalpr")
insert into table1 values(3,"Zahid","Lahore")

browse

create cursor history_table (sno n(3),name c(15),city c(15))

select table1
locate for sno=1
if found()

	old_data="crs"+sys(2015)
	select * from table1 where sno=1 into cursor old_data

	select table1
	replace name with [Ahmad]
	replace city with [Multan]

	select history_table
	append from dbf("old_data")
endif


select table1
browse

select history_table
brow




_______________________________
Impossible is not a fact. Its an opinion.

ENTIRE THREAD

Generate Log File Posted by Rashid Mehmood @ 12/31/2012 4:11:42 PM
RE: Generate Log File Posted by Tariq Mehmood @ 12/31/2012 4:36:23 PM
RE: Generate Log File Posted by Anders Altberg @ 1/2/2013 3:53:44 PM
RE: Generate Log File Posted by Rashid Mehmood @ 1/3/2013 8:40:40 AM