I am trying to use Command_SYS.Mail to Attach file created on the Database Server.I figured out how to attach a file from the Application Server, but my Package will run on the Database server and create a file on the database server.Is there anyway to tell Command_SYS.Mail to Attach a file from the Database Server rather than the Application Server?Version: IFS App 8.Thanks for any help.
I am using IFS 8 and no matter what I have put in as an Expression, I get the error that the expression must return a date. I tried the solutions in other Topics, but none work for me.I even tried something really simple: SYSDATE + 1/3600; which comes directly from IFS Online Documentation and get the same error.Is there something weird about IFS 8?Any help is appreciated.
I am trying to create a Custom Event in IFS 8 - “CRO Receive Part” to Display an Alert if a user tries to save when the Serial No on the Receive does not match the one on the “Component Repair Order”.I am able to use Error_Sys.Record_General to display a message and force the user to go back, however, sometimes it is OK that the Serial No is different. I would like the user to be able to Click ‘Cancel’ to go back and ‘Continue’ if it is OK. I have tried to use Client_Sys.Add_Info and Client_SYS.Add_Warning, but they do nothing.What am I missing? DECLARE CURSOR cro_line_cursor IS SELECT clt.cro_no, clt.line_number, clc.cf$_reported_serial_no serial_no FROM cro_line_tab clt ,cro_line_cft clc WHERE clt.rowkey = clc.rowkey AND clt.cro_no = '&NEW:CRO_NO' AND line_number = '&NEW:LINE_NUMBER' AND contract = '&NEW:CONTRACT';BEGIN FOR cro_line_rec IN cro_line_cursor LOOP IF '&NEW:SERIAL_NO' != cro_line_rec.serial_no THEN Error_Sys.Record_Gene
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.