Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anil Sharma
  Where is Anil Sharma?
 ludhiana
 India
 Anil Sharma
 To: mk sharma
  Where is mk sharma?
 mumbai
 India
 mk sharma
 Tags
Subject: RE: how to create log when change in data
Thread ID: 330803 Message ID: 330980 # Views: 32 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Sunday, December 25, 2011 10:23:20 AM         
   


> i want to create a log dbf to store data changes.
> i am using buffering .
> suppose a invoice have 10 products and user changed a record from this 10 records (Productname,quantity,rate,tax).
> how to know that which record is changed ?
> how i can do this ?
>
> Warm Regards,
> mk.

MK i m not sure if you direct involving the item detail table in data entry. If you are doing this this will slow down the performance and having higer chance of corruption of table. Instead of direct using item detail table you can use temp cursor
to display/edit invoice items and compare cursor vs original item detail table for changes.


Anil


Accounting Software

Web Development

Accounting, Inventory, Hotel Management, Restaurant Kot Billing, MLM, Excise Accounting and much much more!.
My Blog

ENTIRE THREAD

how to create log when change in data Posted by mk sharma @ 12/23/2011 7:00:32 AM
RE: how to create log when change in data Posted by tushar @ 12/23/2011 7:28:39 AM
RE: how to create log when change in data Posted by mk sharma @ 12/23/2011 8:19:34 AM
RE: how to create log when change in data Posted by tushar @ 12/23/2011 9:46:59 AM
RE: how to create log when change in data Posted by mk sharma @ 12/23/2011 10:09:18 AM
RE: how to create log when change in data Posted by mk sharma @ 12/23/2011 7:45:51 PM
RE: how to create log when change in data Posted by mk sharma @ 12/24/2011 7:48:13 AM
RE: how to create log when change in data Posted by mk sharma @ 12/24/2011 8:08:51 AM
RE: how to create log when change in data Posted by tushar @ 12/24/2011 6:58:16 PM
RE: how to create log when change in data Posted by mk sharma @ 12/24/2011 7:47:03 PM
RE: how to create log when change in data Posted by Anil Sharma @ 12/25/2011 10:23:20 AM
RE: how to create log when change in data Posted by mk sharma @ 12/25/2011 11:13:34 AM
RE: how to create log when change in data Posted by Anders Altberg @ 12/25/2011 1:20:23 PM