Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: mk sharma
  Where is mk sharma?
 mumbai
 India
 mk sharma
 To: Anil Sharma
  Where is Anil Sharma?
 ludhiana
 India
 Anil Sharma
 Tags
Subject: RE: how to create log when change in data
Thread ID: 330803 Message ID: 330982 # Views: 30 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Sunday, December 25, 2011 11:13:34 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

i am involving the Parent and Child tables direct for data entry.

Some times i am facing a problem with index files.
records available in table but after SET ORDER not showing.
still i am looking the way how to found the Index file is not proper as no error displayed.

After Re Index every thing Perfect.



Warm Regards,
mk.

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