The following lines inserts a row into table pending_file
+1757 /* Add a row to pending_file */
+1758 EXEC SQL INSERT INTO pending_file
+1759 (submission_no, orc, terminal_id, initials, user_id, output_to_file, output_path, item_id)
+1760 VALUES (:sSubNo, :sORC, :sTermID, :sInit, :sUserID, "1", :sOutPath, :sItemID);
The table definition in postgres is:
Column | Type | Modifiers
-----------------+------------------------+-----------
submission_no | character(11) | not null
item_id | character(9) | not null
terminal_id | character(3) |
initials | character(2) |
user_id | character(20) |
orc | character(1) |
output_to_file | character(1) |
output_path | character varying(200) |
gui_calling | character(1) |
date | date |
calling_process | integer |
The error being recorded by sqlca.sqlerrm.sqlerrmc is:
column "1" does not exist on line 1758.
I'm totally baffled, can anyone kindly explain what the error is referring to?
Thanks
Atif