I assume this is Oracle. What type are the columns are store_id
and history_id on the db table.
To be safe, double check the obvious:
1) make sure the dw has no filter
2) make sure you are connected to the same db in all test cases
I have never used a LIKE directly in the dw SQL. (I have only
adjusted it dynamically). But it should work. Debug the app
and check the exact SQL in the sqlpreview event to make sure
it looks the way you think it should.
>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]
