thiago
Forum Replies Created
-
I see you have a template selected and you are using the custom sql template event instead of modifying one of the std quote events. That template probably does not have an xml and that is why you have the error. First question is do you need to show the body of the email or are you just interested in the csv extract? In that case load a simple template like the std_0052_project_audit_log to get passed the error. Otherwise you will need to build the xml and xsl files to match your custom query for your new custom template.
-
If you need to change it programatically the code controlling the font is usually under “Report” in the Calc Tab.
-
The error is not related to your sql. Do you have an xml file on the template being used by this event?
-
If you look for that error in the sys_error_log table it should have the full error with line number opening the clob field.
-
If you open that error meg does it say which line on the code is giving the error?
Another way to go about it would be to run the emgr procedure from a pl/sql block in a sql window in sql developer so that it will point you to the correct error line. You would have to pass parameters like p_eme (eme_auto_key)…etc.
Declare
Begin
Procedure;
End:
-
My deepest apologies for not being there at the presentation for Forms Designer. I would like to attempt to turn this unfortunate situation into something positive by offering a free one hour of consulting to everyone who attended so that we can look at any challenges you may be having with your projects in Forms Designer on a one-to-one basis. Please send me an E-mail to talvares@datastudiodev.com to schedule. Thank you
-
Ian, you could export grid data from Lot into .csv file and create a custom import script using the ocdia tool in your Quantum folder to add all the stocklines to RO.
-
Nice, i am glad it helped.
Sure please add for everyone.
-
Hi Abigail,
Hope you are doing well.
I have some screen scripter tricks on a file I put together and just saw your post, so i am going to share here for anyone that may need it. See attached.
About your issue, if you click on “Data” button(in ctrl+F8 screen) you will see that your crq_auto_key is probably se to 2, but the look up text box text is not set yet as the assignment has not been posted yet to the database at this point. This is one way to go about it below, hope this works for you:
procedure FormShow(Sender: TObject);
var
q: TOracleDataset;
begin
if Form.Dataset.State = dsInsert then
begin
{set auto key}
Form.Dataset.FieldByName(‘cqr_auto_key’).AsInteger := 2;
{set control text}
q := TOracleDataset.Create(nil);
q.SetSession := Form.OCSession;
q.Sql.text :=’ select source_code from cq_source where cqr_Auto_key = 2′;
q.Open;
form.lkpCQSource.text:= q.FieldByName(‘source_code’).asString;
q.Free;
End;
end;
procedure BtnOKClick(Sender: TObject);
begin
end;
-
Hi Anne,
The form will accept only one data pipeline. Even if you save the subreport to file from STD WO Task and load it in the STD Work Order Sheet, it will bring all design feature but when you go to Report – Data to assign a Data pipeline it will only give you the options to pick one of the “branches” from the existing Data Pipeline in that form.
What I have done over the years to overcome this issue is to create a “subreport” using a combination of Memo fields that stretch and select from same rows of data, so that you can add a subreport in any Form with any data you wish.
1) Add a memo field in design mode
2) go to Calc Tab and add the code below for memo, but create a sql to display the data you need.
3)
var
q : TOracleDataset;
begin
MemoQtyIssued.lines.clear;
q := TOracleDataset.Create(nil);
q.SetSession;
q.Sql.text :=’ select wob.qty_issued from wo_bom wob, parts_master pnm, uom_codes uom ‘+
‘ where pnm.pnm_auto_key = wob.pnm_auto_key ‘+
‘ and uom.uom_auto_key (+)= pnm.uom_auto_key ‘+
‘ and wob.woo_Auto_key = ‘+WO_OPERATION[‘WOO_AUTO_KEY’] ;
q.Open;
while not q.eof do
begin
MemoQtyIssued.lines.add(q.FieldByName[‘qty_issued’].AsString);
Q.next;
end;
q.Free;
end;
4) then you add a memo like this for all the other fields you need (PN, description, etc… and make sure that the text doesnt wrap any lines(right click-char wrap). Remember to fix the memo name on code above for each different memo field.
I have a subreport like this ready that should be close to what you need. Shoot me an email at talvares@datastudiodev.com and I will send it to you.
Hope this helps. If any one else needs help with this i will be happy to go over in more detail, just shoot me an email. I will also be showing this and more at a workshop during QUEGroup this year.
Thiago
-
Kelly, aside from adding the field to the template. You will need to modify the xml file and the sql for the event so that the data can be passed to the stylesheet of the template.
Let me know if you need help 😉
-
Tim, I would be happy to advise you and help you with getting accurate data out of Quantum for this project.
It’s not a simple project as Paul is mentioning. You need to understand pl/sql and which procedures to use in Quantum DB to get the correct data. I am the only ex Developer of Quantum available for hire and have a lot of experience with reporting on accounting data.
Please feel free to contact the QueGroup board for my references or any customer on my website http://www.datastudiodev.com.
Kind Regards,
-
Hey Kristen,
Send me your form (.rtm file) and I will be happy to send you the sql for it.