Search results

Hi It could be several reasons. One of them is "a transaction is open" If you want to know what is the Reason you can modify your source to have the error . Patrice DISCONNECT abfhero NO-ERROR. DEF VAR v-c-error AS CHAR NO-UNDO. DEF VAR ixerr AS INT NO-UNDO. IF...

Hi , A little more explanation on the word "packet" , i am not using it for the packet send/recived in this case. When you are using a Break by / First-Of / Last-Of , your query know the "next" record to evaluate the "Last" , i am using the word "packet" for the records that your query "know"...

Hi Adding an index will solve the isuse in most of case . But if the record is in the "packet" received it will not work , You can try the code below there is only 3 record in the Temp-Table instead of 4 and the update is on record "3" . def temp-table tt-test field id as int field...

Hi It is a little bit difficult without the index But You should/could: - replace the CAN-DO by LOOKUP . - (int(substr(corpdata.AFI_FORM_UPDATER.ACTION_DATE,1,4)) = YEAR(mSYSDATE) By corpdata.AFI_FORM_UPDATER.ACTION_DATE Begins String(YEAR(mSYSDATE) , "9999" ) (and perhaps By...

Hi The "truncate area" will not decrease its size , If you want to decrease it , i Think You could use Something like that proutil [db] -C dump proutil [db] -C truncate area [table_area] proutil [db] -C truncate area [idx_area] proutil [db] -C idxbuild table …...