Hope you have noticed that in the retrieval with the retrieval arguments,
you donot have the % symbol there. Whereas the other statement has the %
symbol. Like clause must have the % symbol, which is the wild character.
HTH
Surya
----Original Message Follows----
From: Laxmikant Kesti <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: PFCSIG Datawindow problem
Date: 30 Aug 99 22:42:17 MDT
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]
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
> [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]
