Did you try trimming as_acct_id and appending '%" to it?
---------
Laxmikant Kesti wrote:
> Hi friends
>
> This is a non-PFC problem.
>
> I have used a datawindow "d_acct_history" which has two retrieval arguments
> 1)as_store_id of string datatype), 2) as_acct_id of string datatypes. I
> am using retrieval arguments in where clause as follows
>
> history.store_id = :as_store_id And
> history.history_id like :as_acct_id
>
> The SQL statement shows as below.
>
> SELECT history.store_id,
> history.history_id,
> history.month,
> history.amount,
> history.year
> FROM history
> WHERE ( history.store_id = :as_store_id ) AND
> ( history.history_id like :as_acct_id )
>
> I use two values for retrieval as �00017�(String) and �1%� (I need all records
> where store_id=�00017� and acct_id starts with �1�.)
>
> It returns zero records.
>
> When I Preview the datawindow in Powerbuilder environment and give the above
> retrieval arguments, still it returns zero rows.
>
> Instead of giving retrieval arguments, if I hard code it gives correct
> result.
> The SQL statement when I hard code is shows as below.
>
> SELECT history.store_id,
> history.history_id,
> history.month,
> history.amount,
> history.year
> FROM history
> WHERE ( history.store_id = '00017' ) AND
> ( history.history_id like '1%' )
>
>
> Can you help me to solve this problem.
>
> Regards
>
> Laxmikant
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
