Problems storing NULL-date with RFX_DATE-function in vc++4.1

seibmpdq@ibmmail.com
Wednesday, October 30, 1996

Environment: VC++4.1, Win 95
Problems storing NULL-date with RFX_DATE-function in vc++4.1

I've been using RFX_DATE(taking TIMESTAMP_STRUCT as argument) in an  vc++1.52
- application.
The function uses AFX_RFX_TIMESTAMP_PSEUDO_NULL (99)  to communicate
NULL-values.
The application uses ODBC to access the database.
This works just fine !!

Problems, however, appeared when I converted the application to vc++4.1. Now
it's impossible to store  a NULL-date without getting errormesseges like
"Illegal Time" (SQLServer) or "Date/Time-field overflow" (MSAccess).

Anyone had the same experience? And have a solution?

I'm greatful for any ideas!

Regards

Lars Loman
Responsor AB
Hallsta
S-631 84 Eskilstuna
Sweden
seibmpdq@ibmmail.com

---

Luke Stephens -- luker@tfs.net
Friday, November 01, 1996

I am also using SQL Server/MS Access and storing NULL in date/time fields.

I'm using the CTime class within a CRecordset derived class. I simply set
the variable = 0;

Ex. m_StartDateTime = 0;

This seems to work fine for me.

Luke Stephens
luker@tfs.net

----------
> From: seibmpdq@ibmmail.com
> To: mfc-l@netcom.com
> Subject: Problems storing NULL-date with RFX_DATE-function in vc++4.1
> Date: Wednesday, October 30, 1996 1:40 AM
> 
> Environment: VC++4.1, Win 95
> Problems storing NULL-date with RFX_DATE-function in vc++4.1
> 
> I've been using RFX_DATE(taking TIMESTAMP_STRUCT as argument) in an 
vc++1.52
> - application.
> The function uses AFX_RFX_TIMESTAMP_PSEUDO_NULL (99)  to communicate
> NULL-values.
> The application uses ODBC to access the database.
> This works just fine !!
> 
> Problems, however, appeared when I converted the application to vc++4.1.
Now
> it's impossible to store  a NULL-date without getting errormesseges like
> "Illegal Time" (SQLServer) or "Date/Time-field overflow" (MSAccess).
> 
> Anyone had the same experience? And have a solution?
> 
> I'm greatful for any ideas!
> 
> Regards
> 
> Lars Loman
> Responsor AB
> Hallsta
> S-631 84 Eskilstuna
> Sweden
> seibmpdq@ibmmail.com
> 
> 

---

| Вернуться в корень Архива |