Improve company productivity with a Business Account.Sign Up

x
?
Solved

"SET CENTURY ON"

Posted on 1998-09-04
4
Medium Priority
?
648 Views
Last Modified: 2013-11-24
When you "set century on" at the DBASE IV dos prompt, how do you make it stay on when you exit out of DBASE?
0
Comment
Question by:Rodack
  • 2
4 Comments
 

Author Comment

by:Rodack
ID: 1025636
Edited text of question
0
 
LVL 1

Accepted Solution

by:
bsimser earned 20 total points
ID: 1025637
In a nutshell, you don't. It only exists inside the DBASE environment and affects databases used during that session.
0
 

Author Comment

by:Rodack
ID: 1025638
If this is the case, would you have to write this command into any source code that uses Date references in running reports out of Databases so that it turns on each time you try to run a report that initializes by date? ex:  A sales report over a certain period.  "12/01/1997" to "01/01/1998", but the database that holds this data does not have century on because it turns off every time you shut down.  Currently our source code variable only has 6 digits for dates, but we will soon be changing it to 8. Our problem is that we need the databases to maintain the 8 digit date span. "FOR Y2K"(year 2000):-)

0
 

Expert Comment

by:jacs
ID: 1025639
You must change the config.db using the General/Set Century option of the DBSETUP.EXE
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question