Invalid dates - 215 using Btrieve/Clipper DATE format
Invalid dates - 215 using Btrieve/Clipper DATE format
Author
Message
Jack #1 / 1
Invalid dates - 215 using Btrieve/Clipper DATE format
I am using Clarion 4.1a Professional - Application Generator with ABC Templates with the Clipper Database Driver and I keep getting inconsistent behavior with date fields coming from the Clipper database, defined as DATE
sometimes confronted with "An error (invalid date(-215)) was experienced in making changes to the file ...." This is not consistent and in some places in the program the dates are accepted from the form, while in others it doesn't matter in what format you try and input the date it is rejected with the above error. In some forms with two identically defined dates only the one date is rejected. Priming the dates with something like Today() produces the date in the correct format only to be rejected when trying to OK the form. Adding an Auto increment attribute to a key causes ALL dates, defined as DATE, in the record to be rejected. Unfortunately I cannot alter the date formats in the existing database as there are other (Non Clarion)
help. Please Somebody help me as this is proving to be quite a obstacle. TIA Jack.