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
>
>
| Вернуться в корень Архива
|