DirectPathLoader...

[DavidH]

Two questions about the TDirectPathLoader:

1) Is it possible to insert nulls in some of the columns (which columns are null depends on which row it is, so I can't exclude the column in the column list), and if it is possible, how do I do it?

2) When can I free the memory I put as a parameter to SetData?
a) Right after SetData
b) After Load
c) Not until after Finish?

 

[somis]

1.disable foreignKey and constriant
2.until all finished,
so this is my max problem using the doa. I thinking loading
400000 record in the database,but because
need put them into the memory, tip virtual
memory is small, lucky, yet finish my work.

 

[DavidH]

somis, I have disabled constraints and such. To set a value in the DirectPathLoader you have to use the column procedure "SetData".

I tried not to call SetData for the row/column I wanted to set to null, but that gave me an error upon load ("Invalid date format", as it was a date field).

 

[Marco Kalter]

1. Assign a nil pointer to the data (documentation omission).
2. After Load. This loads the data from memory into the database.

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