Skip to Main Content

Java SE (Java Platform, Standard Edition)

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!

FileDialog: option to select both files AND directories?

843807Sep 21 2010 — edited Sep 23 2010
Hi,

For the sake of Mac users I wish to use FileDialog for file/directory selection. I can use:

System.setProperty(apple.awt.fileDialogForDirectories, true)

in order to be able to select directories, but it only allows directory selection. Not setting it only allows file selection. I wish to be able to select either a file OR a directory, which I haven't found a way to do with FileDialog.

Anyone know how?

thanks, Allasso

Comments

Pete_Scott

You say Variable C is refreshed - have you tried setting it instead?  On the Set Variable option of the package you could enter the two variables to combine - you need qualify the variables with the project name

Also are both A and B of the same data type?

3551278

It doesn't seem to work by setting variable C either.

I still get the error  "Variable has no value: PROJECT.VARIABLE_A"

Both variables are text.

The whole process works when I am setting the variable A and launching my package manually.

It doesn't work when i'm passing the variable A value with the startscen command.

Pavan8u

While generating Scenario, have you selected VAR A as startup parameter?

Regards,

Pavan

3551278

I think so, VAR A is INTERFACES.PAIE_XINT_MOIS in the screenshot below.

pastedImage_0.png

Pierre-Yves

Pavan8u

I tried it in my pc and it is working fine.

In Var_c I wrote query like

SELECT '#PAVAN.var_a'||'#PAVAN.var_b' from dual.

Please check whether you are using # before variable name or not. Please check Project name as well.

Regards,

Pavan

3551278

Sorry i was no specific enough.

I am encapsulating a scenario in another scenario.

In scenario 1 I declare VAR A (INTERFACES.PAIE_XINT_MOIS) and set VAR B (INTERFACES.PAIE_XINT_SOC_LIB)

Then I call scen 2 and refresh VAR C (INTERFACES.PAIE_XINT_CHEMIN) using the following query :

pastedImage_0.png

If I try refreshing VAR C in the first scenario, it works fine.

It is not working when doing it in scenario 2

Pierre-Yves

Pavan8u

If I am not wrong, you have one main scenario SCN1 and from SCN1 you are calling SCN2. You have var1 and var2 in SCN1 and var3 in SCN2.

In order to refresh VAR3 in SCN2 you need to pass var1 and var2 as additional parameters to SCN2.

Refer this blog for some insight-

http://odiexperts.com/passing-values-to-odi-variables-in-packagesscenarios/

Regards,

Pavan

3551278

You are right.

VAR A and B are declared in SCN2 before refreshing VAR C.

pastedImage_0.png

Therefore they are passed as startup parameters.

The whole thing works when VAR A is set manually in SCN1

But it doesn't work anymore when VAR A is passed with starscn command.

I think the solution might be to write the value of VAR A in a temporary table and use this table for queries.

Pierre-Yves

Pavan8u
Answer

In Package1, click on SCN2 and click on ADDITIONAL PARAMETERS, there you need to add VAR-A and VAR-B as additional parameters. Refer blog which mentioned in above thread.

Regards,

Pavan

Marked as Answer by 3551278 · Sep 27 2020
3551278

Thanks a lot Pavan, it did the trick, indeed.

Have a nice day.

Pierre-Yves

1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 21 2010
Added on Sep 21 2010
5 comments
3,050 views