Solved

"SET CENTURY ON"

Posted on 1998-09-04
4
591 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 10 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SCCM 2012 - Backup and Recovery Best Practice 2 61
Sharepoint 2013 error 4 48
SCCM2012 sp2 CU3 cant see boot images missing tabs 3 57
dbcc checkdb datawarehouse 2 41
APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

930 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now