webadi customisation: i want to fill a column through a select command during upload regarding anoth
I'm working on customisation for upload through webadi. It's working fine except one thing. I've customised an interface col to force a column asset_id to be filled thanks another column asset_number entered in spreadsheet through a sql command. I use a sql in default_value to retrieve that value. But i get an error when i upload. Does someone know how to do this?
DEFAULT_TYPE = "SQL"
DEFAULT_VALUE =
"SELECT ASSET_ID FROM FA.FA_ADDITIONS_B WHERE ASSET_NUMBER = '$table$.TEST.ASSET_NUMBER' "
I get the following error : 4/1/11 2:18 PM ERROR BneBaseSQL.executeQuery: Exception while running query. Error Code: 1006, Message: ORA-01006: bind variable does not exist