Question:
"Translate error, value out of bounds" error with blank date
fields: What causes this error and how do I get around the problem?

Answer:
Fox Pro stores one of three things in a date field:

An actual date (ex 19970727 is 7/27/1997)
8 Spaces (ASCII 20)
8 Zeros (ASCII 30)

All of these are acceptable to Fox Pro. The Fox Pro driver for
the BDE only accepts 1 & 2 as valid dates and returns a
translate error for the 3rd (8 ASCII zeros) as it doesn't
consider this as a valid date. To fix the problem, restructure
the date field to a char field and then restructure the table
again changing the char filed back to a date field. This
translation writes back only valid values to the date field and
fixes the problem.

9 Responses so far.

  1. diana_ser says:

    thanks. do not hesitate trying various tools for mssql database restore tool, it is often the only choice to retrieve the data from corrupted documents

  2. jemmy says:

    Good one.. Its interesting about this Tricky Questions. Delphi Product Development

  3. Teela had no idea who or what jeezus was,but she knew a compliment when she heard one and this was doubly welcomebecause Teelas pussy was original equipment, inside and out. Allthe goodies were making him sick.
    forced lesbian stories
    sex stories post rape fantasies
    adult tickling stories
    free sex stories true
    free erotic wife sharing stories
    Teela had no idea who or what jeezus was,but she knew a compliment when she heard one and this was doubly welcomebecause Teelas pussy was original equipment, inside and out. Allthe goodies were making him sick.

  4. Anonymous says:

    Excellent post. I was checking constantly this weblog
    and I am impressed! Extremely helpful information particularly the ultimate part :) I take
    care of such info a lot. I was looking for this certain information for a long time.

    Thank you and good luck.

    Feel free to visit my web site ... discount code for sky

Post a Comment

Thank you for your comment.

Any request and idea are welcome.

CLICK TO REGISTER