RE: HANDLING NULL DATE VALUE

From: Tanmoy Mukerji


	Allahabad India
	Tanmoy Mukerji

To: christ


	jakarta Indonesia
	christ

Subject:	RE: Handling Null Date Value
Thread ID:	180864	Message ID:	180890	# Views:	2	# Ratings:	0
Version:	Visual FoxPro 9		Category:	Databases, Tables and SQL Server
Date:	Monday, June 30, 2008 8:21:42 AM

> HOw can i handle a nulldate value ?
> for eg:
> INSERT INTO tagihan( ID, BILL, PAYMENT, BILLDATE, BILLPAY ) VALUES (?this._field.ID, ?this._field.BILL, ?this._field.PAYMENT, ?this._field.BILLDATE, ?this._field.BILLPAY)
>
>
> when this._field.BILLDATE is empty date , it will raise an error
>
> How solve it
>
> Thx

Give a try to this ...
in your VALUES (val1,val2...) replace this._field.BILLDATE with NVL(this._field.BILLDATE,{//})
in my SELECT queries and INSERT INTO this works fine

Regards,
Tanmoy

ENTIRE THREAD

Handling Null Date Value Posted by christ @ 6/29/2008 8:34:31 PM

RE: Handling Null Date Value Posted by Borislav Borissov @ 6/29/2008 8:53:35 PM

RE: Handling Null Date Value Posted by Anders Altberg @ 6/30/2008 12:07:25 AM

RE: Handling Null Date Value Posted by christ @ 6/30/2008 5:31:20 AM

RE: Handling Null Date Value Posted by tushar @ 6/30/2008 6:32:02 AM

RE: Handling Null Date Value Posted by Anders Altberg @ 6/30/2008 8:36:05 AM

RE: Handling Null Date Value Posted by tushar @ 6/30/2008 1:58:57 PM

RE: Handling Null Date Value Posted by Anders Altberg @ 6/30/2008 2:28:45 PM

RE: Handling Null Date Value Posted by Anders Altberg @ 6/30/2008 2:35:07 PM

RE: Handling Null Date Value Posted by Anders Altberg @ 6/30/2008 2:41:03 PM

RE: Handling Null Date Value Posted by Bernard Bout @ 6/30/2008 5:37:13 AM

RE: Handling Null Date Value Posted by Tom Saddul @ 6/30/2008 1:07:13 PM

RE: Handling Null Date Value Posted by Tanmoy Mukerji @ 6/30/2008 8:21:42 AM