One Star

What is "Use NB_LINE_" drop down for on TOracleRow

This option is missing from the TOracleRow documentation (up to 5.1). What it appears to do is allow the global map variable for the component?
If it's useful why isn't it on other TdatabaseRow components?
1 REPLY
Moderator

Re: What is "Use NB_LINE_" drop down for on TOracleRow

Hi, g.e.davies
Sorry, this option is not documented yet, well, I think it will be done soon in next releases
1. toracleRow is used to execute a query, for exmaple: "delete from person"
2. Use Nb_LINE is used to count the total number of records have been proceed.
3. When this option is set to NONE, there is no a global variable for counting the total number of records have been inserted, updated, or deleted.
4, when inserted item is choosen, there will be a global variale such as ((Integer)globalMap.get("tOracleRow_1_NB_LINE_INSERTED")) will be avaible, which counts the total number of records have been inserted into database.
5. the same to updated, deleted items
let me explain it more detaily, if you are execute a query "delete from person", and this option is set to deleted, a global variable ((Integer)globalMap.get("tOracleRow_1_NB_LINE_DELETED")), will counts the total number of records have been deleted.
Many components have global variable, such as tFilelist, tFileOutputDelimited, tMysqlOutput
Best Regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.