need someone who can do SQL
Budget: $10 – $30 USD
We have users go through our work flow. When they reach an appropriate part of the workflow it should leave a letter of pertinent information in the Contract Package Page as shown in image one and two. Image two shows the workflow section titled “Initial” and it displays correctly.
The contract package runs in the Printable Document Designer (PDD) which is shown in image 3.
Yet for some reason when we are in modification and we try to get the PDD to run and create a new PDF file and put it in the Contract Package form it does not work. It only shows what we see in image 4.
I have attached the pertinent code. I think it hangs on the procedure entitled spwNJ_DCF_ExecSQL_Execution_Letter, which also calls the SP spvIGXDocumentFormValueSave, both of us which are attached, but it could be any of the attached SQL codes causing the problem. Please show me what fixes you would make and where, and let me know if there is any other information you need for completion of the project.
The contract package runs in the Printable Document Designer (PDD) which is shown in image 3.
Yet for some reason when we are in modification and we try to get the PDD to run and create a new PDF file and put it in the Contract Package form it does not work. It only shows what we see in image 4.
I have attached the pertinent code. I think it hangs on the procedure entitled spwNJ_DCF_ExecSQL_Execution_Letter, which also calls the SP spvIGXDocumentFormValueSave, both of us which are attached, but it could be any of the attached SQL codes causing the problem. Please show me what fixes you would make and where, and let me know if there is any other information you need for completion of the project.