BATCH

[lode]

Hi,

I'm running a program that has to insert several records in the same database at one time, but only when the user confirms.
I know there is something like a batchprocess or something like that but i don't know how to do it ?

Any suggestions ??

Thanks
Lode.

 

[zemp]

If you are using an ADO recordset object then use the 'updateBatch' method. This can be used to update several records at once. However I am not so sure about adding new records. I believe that you will need to loop through the records and add them one at a time. Thanks and Good Luck!

zemp

 

[Abaka]

Create an array to hold the values of recors and if the user agreed then use rs!batchupdate or else use rs!cancelupdate