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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Updating Date Field to Null or empty string
Mirtheil, I figured it out. After trying everything I decided to try setting the field to a time stamp. So I set the field to 12:00:00 and believe it or nut it worked! I looked at the data and it shows up as empty in the database and my app. I am not understanding why but hey it works...- chum908
- Post #3
- Forum: Pervasive: Pervasive.SQL
-
Updating Date Field to Null or empty string
I am using VB.NET and trying to update a field in a Pervasive database using ODBC (Timberline Data Source to be exact) and am using ADO. All of my updates work until I try to Null out a date as in the following example with Rehire_Date it errors. Here is the line in question: strSQL = "UPDATE...- chum908
- Thread
- Replies: 2
- Forum: Pervasive: Pervasive.SQL
-
Reports won't open
Sean, Well it seems that for some unknown reason even though I was able to print a test page to the default printer on that machine Access did not see that printer even though it was set as the default. I changed it to another network printer and "bada bing" Access sees it and then is able to...- chum908
- Post #11
- Forum: Microsoft: Access Other topics
-
Reports won't open
Sean, I have the same problem on two of my workstations. If you open the database and hover the mouse cursor over the printer icon it will show the message "No Printer". I have looked everywhere to figure out how to have Access "see" the default printer. I have also done what you and the...- chum908
- Post #10
- Forum: Microsoft: Access Other topics
