Field mapping failed due to a missing field

HCL Domino Domino Forum
1

Hello everybody

i’m trying to insert data into a postgesql db using odbc2 & lclsx…

i have 2 tables and a single fieldlist with 25 fields(fields 0 to 15 for the first table, 16-24 for the second table)

i have applied the next algorithm

  1. set the flag to 2 for 0-15 fileds

  2. set the flag to LCFIELDF_NO_INSERT for 16-24 fields

  3. set the metadata to first table

  4. perform the insert

  5. set the flag LCFIELDF_NO_INSERT for 0-15 fields

  6. set the flag to 2 for 16-24 fields

  7. set the metadata to second table

  8. perform the insert

when it tries to perform the insert on the second table, i get the following error “field mapping failed due to a missing field”. this error appears when using odbc2…

i ran the some code on an oracle db, using oracle8 connector, and it worked just fine!!!- no problems

so…what can i do to solve this problem?

please help me!!!