Jun 20, 2007 #1 Mighty Programmer Joined Feb 22, 2001 Messages 1,682 Location US Is there any way for me to run a query to find invalid dates in a table so that I can correct them? Mighty
Is there any way for me to run a query to find invalid dates in a table so that I can correct them? Mighty
Jun 20, 2007 #2 mirtheil Programmer Joined Jun 20, 2001 Messages 1,556 Location US No. If the date is invalid, ODBC won't be able to work with it. THere are a couple of utilities for fixing bad dates on the Pervasive Component ZOne (http://www.pervasive.com/componentzone). You could also write (or have written) an application that uses the Btrieve API to target your data files specifically and fix the bad dates. Fixing the dates is only part of the solution. You need to make sure that no more invalid dates get into the data file. Mirtheil Certified Pervasive Developer Certified Pervasive Technician http://www.mirtheil.com Upvote 0 Downvote
No. If the date is invalid, ODBC won't be able to work with it. THere are a couple of utilities for fixing bad dates on the Pervasive Component ZOne (http://www.pervasive.com/componentzone). You could also write (or have written) an application that uses the Btrieve API to target your data files specifically and fix the bad dates. Fixing the dates is only part of the solution. You need to make sure that no more invalid dates get into the data file. Mirtheil Certified Pervasive Developer Certified Pervasive Technician http://www.mirtheil.com