Error 42S02
SQ111: No table VAL.DBA.VAL_HOSTS.
while executing the following statement:
#line 3326 "/DAV/VAD/conductor/sec_pki_val.vspx-sql"
create method vc_user_post_vd_delete (inout control vspx_button, inout e vspx_event) for "DB"."dba".page_ee4f323b237322aafe5f9c92440d3c27AD_conductor_sec__pki__val_vspx
{
--no_c_escapes-
declare path, params, lines any;
path := e.ve_path;
params := e.ve_params;
lines := e.ve_lines;
if (udt_instance_of (control, fix_identifier_case ('vspx_field')) and
0 = control.vc_parent.vc_focus or not e.ve_is_post)
{
return;
}
{
declare form vspx_form;
form := null;
if(udt_instance_of (control, fix_identifier_case ('vspx_field'))
and not udt_instance_of (control, fix_identifier_case ('vspx_button'))) {
form := control.vc_find_parent_form (control);
}
if(control.vc_focus or (form is not null and form.vc_focus)) {
--no_c_escapes-
{
#line push
#line 130 "virt://WS.WS.SYS_DAV_RES.RES_FULL_PATH.RES_CONTENT:/DAV/VAD/conductor/sec_pki_val.vspx"
#line push
#line 131 "virt://WS.WS.SYS_DAV_RES.RES_FULL_PATH.RES_CONTENT:/DAV/VAD/conductor/sec_pki_val.vspx"
commit work;
declare exit handler for sqlstate '*'
{
self.vc_is_valid := 0;
self.vc_error_message := concat (__SQL_STATE,' ',__SQL_MESSAGE);
rollback work;
return;
};
delete from VAL.DBA.VAL_HOSTS
where
VH_HTTP_HOST = cast((control.vc_parent as vspx_row_template).te_rowset[0] as varchar) and
VH_HTTPS_HOST = cast((control.vc_parent as vspx_row_template).te_rowset[1] as varchar);
self.vc_redirect ('sec_pki_val.vspx');
#line pop
#line pop
}
}
}
}