BorlandTalk.com

Rodrigo Zabotto · Guest

Dear Friends,

I have a routine that imports data from excell to bold.

The routine verifies if ID exists on database.

I use a EvaluateinPS listhandle to verify it -
'Myclass.allintances->select(ID = ''' + currentID + ''')' when currentID
has the actual register I am importing to.

But, if the excell sheet has a repeated register ID, the evalinps
doesn´t find the register saved before.
To solve it, I put an UpdateDatabase for each register I import.
It works, but I´m having a lot of deadlock problems with it (i don´t
know why) for exemple, on table Bold_id when it increase bold_id.

If I set evalinPS = false and use one updatedatabase in the routine´s
end it works fine (but my performance doesn´t).

Any clue to fix it?

Thanks for help.