Macro in Password field of Run Oracle action

[kinook]

Originally Posted by Shiamak

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