|
Hello, I am using the DBF driver with lockType=VFP, and trying to update fields to blank but I am running into problems. I am seeing .NULL. in some of the fields when I open the table in the Visual FoxPro editor. For character fields I can execute UPDATE table SET character_field = ' ' (update to a single space) and that fixes it, but how can I set a datetime column to blank? If i say UPDATE table SET date_field=null then I see .NULL.. If I say UPDATE table SET date_field=' ' (single space), then the value shows up as 01/01/70 12:00:00 AM in the Visual FoxPro editor. Using the OleDB driver I was able to say UPDATE table SET date_field = '//' but HXTT says that is an invalid date format.
|
Please download the latest package, which has supported it.
For character type, set '' or null will show blank or .NULL. for your VFP talbe.
For date type, you can use '' to set blank value.
|
Main
webmaster@hxtt.com