Skip to Content
0
Former Member
Apr 18, 2009 at 02:08 PM

how to get the substring from the Prompt() function?

153 Views

Hi expert,

I have a such requirement. A report select condition, need display client code and client name(just use client code, user can't remember client's code,on the other hand,just display client name, maybe 重名)。 I created index on client code. I want to use client code to retrieve data, but list client code:client name to let user select.

my syntax is :

@Select(Project\Client Code) IN left(@prompt('Client','A','Project\Client Code:Client Name',Multi,Free,Persistent,,User:4),4) -- to get the fist 4 char

but always syntax error.

if change to

@Select(Project\Client Code) = left(@prompt('Client','A','Project\Client Code:Client Name',Mono,Free,Persistent,,User:4),4) -- to get the fist 4 char

then can pass syntax check.

But user need to select multi value, please tell me the solution, thank you very much!

Regards,

Tony