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?
 Tariq Mehmood
 To: Rashid Mehmood
  Where is Rashid Mehmood?
 Rashid Mehmood
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")


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

select table1
locate for sno=1
if found()

	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")

select table1

select history_table

Impossible is not a fact. Its an opinion.


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