Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Strange issue with Global Variables - Forms 12c

Darsh_Aug 4 2020 — edited Aug 4 2020

Hello,

I have recently taken up a project where forms written in 10g needs to be converted into 12c.   When looking at  these forms,  there is extensive use of these global variables.

One odd thing I see with these global variables is that they are not declared anywhere in these forms.  Usually, we declare and assign a value to a global variable in WHEN-NEW-FORM-INSTANCE trigger.

Whereas this trigger (WNFI), shows no reference whatsoever for these Global variables.

Now , I am at a loss here,  these Global variables are used every where in these forms, but they simply do not exist in WNFI where they should have been declared and assigned a value in the first place.

Where else these Global variables could be getting it's value or would have been declared? Any idea?

Thank you,

Darsh

Comments

User_CXJFI

This would be incredibly helpful. Being able to pick a delimiter would solve the problem for me - it's a pain to process the CSV files right now as the data I'm querying seems to always strings with commas. Since I can't get the preview window to display all rows nor the size of the result set by default, I end up exporting every result set but have to do further processing in order to use it due to the comma limitations.

User_WRSVZ

+1 Being able to change the delimiter would be VERY helpful. Also being able to define the text identifier for the CSV would also be helpful.

Thanks all for the feedback about CSV delimiters. This is on our list of future features.

Hi,
We just released version 19.3.4 which adds 2 settings for CSV delimiters and string encapsulation. Could you please try it out and let me know what you think?

Bjego
Answer

Looks good thank you!

Marked as Answer by Bjego · Mar 24 2021
1 - 5

Post Details

Added on Aug 4 2020
5 comments
1,029 views