Jun 20, 2007 #1 Mighty Programmer Feb 22, 2001 1,682 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 Jun 20, 2001 1,556 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