I'm pulling data from a table that is a date field. I want to test if the field has a date in it or not. It is a table with check information. One of the fields is "Cleared". If it is blank that means the check is still outstanding. However when I look at the field I see it has a date in it when it's blank. The date is 12/30/1899 12:00:00 AM. Can you tell how I test for this? It is the data in SQLCheck_4_1 in the engine log attached.
Hi I did use the 32-bit ODBC Data Source Administrator. However there isn't a test function option on the Visual FoxPro ODBC connection like on others. I'm not sure why. I've attached the vgEngine.txt file from a test I just did.
I'm trying to create a script where I can query a Visual Foxpro table with an ODBC Connection and the Query Database function. I emailed support and they suggested I post with a sample of the table zipped up.
This is the copy of the email I sent them.
I have a client that has a Visual Foxpro Database. I’ve created an odbc connection and am trying to run a “Query Database” on it to test retrieving data. I’m not sure what should go in the three fields. The odbc name is “Check”. It is a table that has 3 fields, they are check,amount,iussed. In other words check number, amount and issue date. I wanted to do a very basic Sql query and say the amount. So I’m guessing I could say “Select check, amount,issued from check where check=’1’. It fails every time. I’m guessing because I didn’t put anything in the two previous fields. I’m not sure what goes in the fields ADO.NET or Connection string. Any help would be greatly appreciated.