Print Thread
Direct path loader / null dates
#1413 12/22/00 08:14 PM
Joined: Oct 2000
Posts: 15
Wilmington, DE, USA
D
dgsmith Offline OP
Member
OP Offline
Member
D
Joined: Oct 2000
Posts: 15
Wilmington, DE, USA
Is it possible to set date fields to null with the direct path loader?


David Smith
Re: Direct path loader / null dates
#1414 12/28/00 04:09 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
If you pass a nil pointer for the Data parameter of the SetData procedure, the column will be treated as a NULL. I noticed that this is not documented properly.


------------------
Marco Kalter
Allround Automations


Marco Kalter
Allround Automations
Re: Direct path loader / null dates
#1415 12/28/00 07:01 PM
Joined: Oct 2000
Posts: 15
Wilmington, DE, USA
D
dgsmith Offline OP
Member
OP Offline
Member
D
Joined: Oct 2000
Posts: 15
Wilmington, DE, USA
That worked fine. Thanks.

I also had a problem with TOracleDirectPathLoader.DateFormat. If I set it I got an access violation on Prepare. When I set it on the columns it works fine.


David Smith

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.079s Queries: 13 (0.030s) Memory: 2.5017 MB (Peak: 3.0426 MB) Data Comp: Off Server Time: 2024-05-18 11:26:33 UTC
Valid HTML 5 and Valid CSS