Prompts - '¦' and ','

[mksmks]

Hi all,

I read in the help pdf file( Step By Step Catalogs) ...that the characters '|' and ',' cannot be used in the prompts. I tried giving these characters in the type-in box. They work out well. Then what does it mean by telling that they cannot be used?

Thanks in advance

 

[griffindm]

This is a general caution that the pipe '|' and comma have special meaning in prompts under some circumstances. Generally, when used from within a macro call to open a report with a prompt, the use of these characters indicates that multiple values are being passed, which are parsed to be the values for multiple prompts. As in

Set ImpRep=ImpPApp.OpenReport(LocCopy,PString1)

Where PString1 might contain "2002,5,500-100"
which is parsed to fill three prompts in the report for Year, Month, and Account. This means that a prompt value passed with a 'extra' embedded comma will be treated as an indicator of a new prompt.

The pipe character is similar. There has been some discussion about the use of the pipe to delimite multiple values for a single prompt used with an "IN" clause, but I do not know for sure if this is working yet.

Regards,

Dave Griffin

 

[mksmks]

Thanks a lot for your reply.