Solved

problems with appending text file to dbase

Posted on 1998-12-13
2
190 Views
Last Modified: 2010-04-04
What if you have a dBASE file with a date field and
when you do append date to that file from a text file that
contains a date value of zero?  

I am using Topaz for my database engine so i guess this
differs.  I use the statement AppendFromSDF and i get
an error message saying 00/00/00 is an invalid date.
I can append using dbase III using the same files.
Don't know what to do.
can anybody help?
thanks
0
Comment
Question by:waipahu
2 Comments
 

Accepted Solution

by:
yfhe earned 10 total points
ID: 1350827
Maybe the date format is wrong.The date format is based on what your computer system is set.For example, the date format of  my computer system is "yy-M-d",so when I input "97-11-12" and "97/11/12",that is Nov 12,1997,they are both correct.Please try it.
0
 
LVL 1

Expert Comment

by:BlackDeath
ID: 1350828
or try to use a

try
  append_gnagnagna
except
  // do nothing
end;

block around the posting proc, that should prevent the occurence of the error-message (at least, in my paradox-apps it worx with adding a zero-date and zero-time to a date/time-field).

Black Death.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

828 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