| Error update column to popup with Postgresql [message #4258] |
Sat, 14 June 2014 09:05  |
kong
Messages: 90
Registered: December 2011
|
Member |
|
|
Column->Update and set as popup field with task id results in an update SQL statement that produces fatal error:
Fatal Error: PostgreSQL: ERROR: 42703: column "list1" does not exist LINE 1: ...ntrol='popup', optionlist=NULL,task_id=h_supplier(list1), fo... ^ LOCATION: errorMissingColumn, src\backend\parser\parse_relation.c:2655 (# 42703)
SQL query: UPDATE dict_column SET control='popup', optionlist=NULL,task_id=h_supplier(list1), foreign_field='supplier_id', revised_date='2014-06-14 07:52:10', revised_user='EKL' WHERE database_id='hotel' AND table_id='expense' AND column_id='supplier_id'
It appears that ...task_id=h_supplier(list1)... is missing the single quotes. For full error details, please see attached pdf file.
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
