[Andrew Sheldon]

Hi Warren, good news is I have got it working today in v10.9.3 and Oracle 11.2.0.3. It was a combination of many incorrectly set up packages, file permissions, ewallet settings and authentication passwords to their servers, but it is possible in 11.2.0.3. Happy to offer any guidance to help if I can. CC were no help at all to be honest and told me countless times to upgrade, as this is often the easiest option when they don’t have the internal technical capabilities

[Andrew Sheldon]

I think they are clutching at straws at the moment and digging around in Quantum to try and work it out. Seems like QC_SC_PKG4 won’t compile, so they want to fix that next. Not sure if this is the issue or not

[Andrew Sheldon]

Try this Tony. It will add a label and Edit box to the part summary form Part tab. Let me know if you have any issues.

[Andrew Sheldon]

Yes you will need to add it using Ctrl F8 under the FormShow procedure. I can send you a script to add the field as a label or a text box if you want?

[Andrew Sheldon]

If i remember correctly the CFL_AUTO_KEY isnt in the dataset behind the summary form. You will need to bring this in using a SQL query in scripter for the PNM_AUTO_KEY.

SELECT CFL.CLASS_FLAG,CFL.DESCRIPTION

FROM PARTS_MASTER PNM

LEFT JOIN CLASS_FLAGS CFL ON PNM.CFL_AUTO_KEY = CFL.CFL_AUTO_KEY

WHERE PNM.PNM_AUTO_KEY =

[Andrew Sheldon]

Thank you Nate. Im guessing by looking at this i will need to generate the full query manually rather that applying a WHERE clause to filter the current dataset? Is that how his works?

[Andrew Sheldon]

Yes they have just confirmed this. How are others licensing this for multiple processors? We were advised at the time of licensing by Oracle that we would only require CAL’s so this could get very expensive…

[Andrew Sheldon]

Thanks all. John you mention authorized partners, are there any on this forum you know about?

[Andrew Sheldon]

Thiago, i thought they weren’t selling the Screen Designer module anymore? I know they discussed it as potentially returning as an available module again about 2 years ago but i haven’t seen any confirmation that this is now able to purchase. Are you able to shed anymore light on this?

[Andrew Sheldon]

Hi, which version of quantum are you running? I’ve seen issues with some forms in older versions in the past.

Regards,

Andrew

[Andrew Sheldon]

No problem Mike. Glad I can help.

[Andrew Sheldon]

Hi Mike, please see below code to add a new tab to a form on show.

procedure FormShow(Sender: TObject);

var

NewTabSheet : TTabSheet;

TestLbl : TLabel;

begin

NewTabSheet := TTabSheet.Create(Form);

NewTabSheet.Caption := ‘New Tab Sheet’;

NewTabSheet.PageControl := Form.PageControl1;

NewTabSheet.Name := ‘NewTabSheet’;

//Add Test Label. Make sure you set parent to newly add tab

TestLbl :=TLabel.Create(Form);

TestLbl.Parent := NewTabSheet;

TestLbl.caption := ‘Test Label’;

TestLbl.Top := 10;

TestLbl.Left := 10;

TestLbl.width :=50;

TestLbl.height :=21;

end;

Regards,

Andrew

[Andrew Sheldon]

Hi Mike, yes I’ve done this before. I’ll dig out the script and upload.

[Andrew Sheldon]

Hello, I’ve been scripting for 8 years and I’ve not been able to achieve this unfortunately. You can only use the FormShow and BtnOkClick procedures within an existing form. You can however develop your own procedures and functions within oracle to carry out a task to send an email if a checkbox is ticked on a form when the ok button is clicked. It’s not exactly what you are looking for but it maybe a workaround to achieve what you need. I’d be very interested to see and hear from anyone who has done this.

[Andrew Sheldon]

Hi all. Its taking shape nicely. The first part uses a query to read the email domain from the email and verify the company in Quantum. If it comes from ILS,PartsBase or StockMarket it reads the domain from the body. If its a direct contact then it uses the senders address. If the company doesnt exist then i will add it as a quote only customer in Quantum and add the quote header and details. This part is nearly done.

The only way this can be done is either by having the ability to develop this yourselves or by asking CC to build an outlook plugin to allow you to add this in. Most CRM systems have this capability. Im taking this stage away and reading directly from the exchange server mailbox.

Will keep you updated.

Andrew

[Andrew Sheldon]

I am looking at this at the moment as i’m seeing a lot of quotes coming in via email that don’t get entered into the system. I’m currently developing a c# application to read the sales mailbox and auto populate Quantum. Will post its progress soon.

[Andrew Sheldon]

Is this Oracle 11g? We are on 11.2.0.3 and have been told today we need to upgrade to 19c, which I find strange, as other customers are running 11g