Skip to Content
0
Former Member
Jan 12, 2006 at 05:28 PM

FileSender Adapter - Recordset Structure Problem

16 Views

Hi,

I would like to know if it is possible to create a recordset structure in the FileSender Adapter for a flatfile where certain Record Types might reoccur.

The source structure is as follows:

3222:003:051201:093056:7596:001:F:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:H:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:S:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:T:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:N:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:T:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:F:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:H:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:N:100:0011: :0000000000000000

3222:003:051201:093056:7596:001:F:100:0011: :0000000000000000

The Key Field is the “F”, “H” etc. A new record should be created for every “F” value. I specified the following Recordset Structure on the adapter: HRecord,,SRecord,,TRecord,,NRecord,,FRecord,1

I am getting the following error message: “missing structure(s) before type 'TRecord'” on the Adapter. It works fine if the “T” record does not repeat after the “N” record. Any help would be appreciated.

Thanks

Rudi