Welcome to Dream.In.Code
Getting Help is Easy!

Join 136,521 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,828 people online right now. Registration is fast and FREE... Join Now!




Basic table error

 
Reply to this topicStart new topic

Basic table error

Ukmale65000
11 Aug, 2008 - 03:24 PM
Post #1

New D.I.C Head
*

Joined: 11 Aug, 2008
Posts: 1

I have developed a database which has a list of tasks to be performed weekly, all works fine, however my problem is that the table contains the information for weeks 1 - 52 only as the system was only to last one year. Because of constraints, the IT department will not now be taking on the database, and i need to extend it to run into 2009 and beyond.
Is there an easy way of extending the database, or will I have to delete all the information collected in the current table as of the 1st of January and start again?

User is offlineProfile CardPM
+Quote Post

jjsaw5
RE: Basic Table Error
11 Aug, 2008 - 08:30 PM
Post #2

I must break you
Group Icon

Joined: 4 Jan, 2008
Posts: 1,404



Thanked: 6 times
Dream Kudos: 125
Expert In: HTML, CSS, Database,

My Contributions
what if you just started a new table for next year and kept the existing table?
User is offlineProfile CardPM
+Quote Post

Trogdor
RE: Basic Table Error
12 Aug, 2008 - 10:37 AM
Post #3

D.I.C Addict
Group Icon

Joined: 6 Oct, 2006
Posts: 523



Thanked: 3 times
Dream Kudos: 125
My Contributions
or add '2008-' to all the values and continue with year+weeknumber.
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/2/08 09:33PM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month