Xtreme Visual Basic Talk

Xtreme Visual Basic Talk (http://www.xtremevbtalk.com/)
-   .NET Database and Reporting (http://www.xtremevbtalk.com/-net-database-and-reporting/)
-   -   Archive database (http://www.xtremevbtalk.com/-net-database-and-reporting/328007-archive-database.html)

mikibalboa 01-08-2016 07:28 AM

Archive database
Hello, i need to archive database entry every day. I'm making program for accounting, and I need to keep a list of entries every day. any ideas??

PlausiblyDamp 01-08-2016 08:48 AM

Why would you need to archive the database everyday in this situation? Could you not just keep adding new entries to the same database?

mikibalboa 01-09-2016 10:04 AM

Because i need at the end of day to have the list with daily profit. Every day is a different list. but if i wrong in fulfilling list, i should be able to go back and correct the list

PlausiblyDamp 01-09-2016 01:29 PM

A more typical approach would be to store all the transactions in a single table and have a date / time stamp against each entry.

That way you could get the figures for a given day, week, month, range of days etc.

All times are GMT -6. The time now is 06:49 PM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Search Engine Optimisation provided by DragonByte SEO v2.0.15 (Lite) - vBulletin Mods & Addons Copyright © 2018 DragonByte Technologies Ltd.
All site content is protected by the Digital Millenium Act of 1998. Copyright©2001-2011 MAS Media Inc. and Extreme Visual Basic Forum. All rights reserved.
You may not copy or reproduce any portion of this site without written consent.