Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [VBP] Third Party Tools (https://www.kinook.com/Forum/forumdisplay.php?f=3)
-   -   Macro in Password field of Run Oracle action (https://www.kinook.com/Forum/showthread.php?t=5255)

Shiamak 03-13-2014 03:40 PM

Macro in Password field of Run Oracle action
 
Hi,

Is it possible to use a %MACROVALUE% in the Password field of "Step Properties - Run Oracle Script"?

I am trying to run a oracle script that pull out a max value from one of the fields in the database and using it during the deployment.
Regards

kinook 03-13-2014 04:56 PM

Yes, just enter a macro reference like %MACROVALUE% as you would in any other field.

Shiamak 03-13-2014 06:11 PM

Quote:

Originally Posted by kinook (Post 20705)
Yes, just enter a macro reference like %MACROVALUE% as you would in any other field.

When I do enter %PASSWORD%, all it displays in the txt box is **** (astrix)...

is that correct behavior?

Shiamak 03-13-2014 07:10 PM

Quote:

Originally Posted by Shiamak (Post 20706)
When I do enter %PASSWORD%, all it displays in the txt box is **** (astrix)...

is that correct behavior?

and How do I store a value in a MACRO..

for instance if I am doing

Select max(Field1) from table1.

I would like to store the output in a Macro .

kinook 03-13-2014 09:06 PM

Quote:

Originally Posted by Shiamak (Post 20706)
When I do enter %PASSWORD%, all it displays in the txt box is **** (astrix)...

is that correct behavior?

Yes, by design, password fields are displayed with asterisks or circle to hide the value, like any Windows password field.

kinook 03-13-2014 09:08 PM

Quote:

Originally Posted by Shiamak (Post 20707)
and How do I store a value in a MACRO..

for instance if I am doing

Select max(Field1) from table1.

I would like to store the output in a Macro .

With the Run Oracle action, you would need to parse the value out of the LASTSTEP_OUTPUT macro into another macro, either in the next step (for instance, with the Read File action) or in the vbld_StepDone script event.
http://www.kinook.com/VisBuildPro/Ma...fileaction.htm
http://www.kinook.com/VisBuildPro/Ma...riptevents.htm


All times are GMT -5. The time now is 12:30 PM.


Copyright © 1999-2023 Kinook Software, Inc.