Consultor Eletrônico



Kbase 33679: RAW-TRANSFER not working when the source temp-table has no indexes
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   10/05/1998
Solution ID: P3679

FACT(s) (Environment):

Progress 9.x
Progress 8.x

SYMPTOM(s):

When trying a row transfer from temp-table with no indexes to another temp-table

If the raw-transfer is from a table with no indexes to another table (not a temp-table) or there is an index in the source temp-table then it works

SYSTEM ERROR: bffld: nxtfld: scan past last field. (16)

SYSTEM ERROR: Cannot read field from record, not enough fields. (450)

SYSTEM ERROR: Failed to extract field <field-num> from <file-name> record (table <table-num>) with recid <RECID>. (3191)

Inconsistent transport state. (5481)

CAUSE:

If the target of the RAW-TRANSFER statement is a temp-table with a default index and the source is either a database record or a temp-table record with an index defined the target record is corrupted.

There is also a problem when the source record is a temp-table with a default index. We are not considering the extra (pseudo) field in the default-index temp-table record when copying source data on top of target data.

FIX:

Make sure the source temp-table has at least one index defined