Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TruxMan

    Opening tables with invalid dates results in blank date fields.

    By the way I don't think we can use the fopen(). I'm a little affraid of destroying any of the structure of these tables. This is going to be customer data, not our data. So there isn't any room for error seeing as how its impossible to get people to back up their data. Anyway, Please let me...
  2. TruxMan

    Opening tables with invalid dates results in blank date fields.

    Hey Guys, Thanks for the suggestions. Creeder, Its funny that you mention the REPLACE command because that is what I use to correct the dates that are invalid. It will go through and leave the invalid fields with fields that have a .null. value, However my boss wants to see a report of what...
  3. TruxMan

    Opening tables with invalid dates results in blank date fields.

    Hey FoxDev, The problem is that FoxPro seems to be interpreting the dates while it is opening the tables therefore FoxPro sees the date fields as empty. It is not just a matter of how its displayed it just seems that FoxPro see it as invalid and counts it as blank. Using Empty() will return...
  4. TruxMan

    Opening tables with invalid dates results in blank date fields.

    Hello Everyone, I need some help. I'm writting a utility to validate the dates in our tables and when I open the tables in FoxPro I will not see dates that are invalid, I will only see blank date fields. For example, I have some dates that have /-1/ in them and I can see this with Quick View...

Part and Inventory Search

Back
Top