> Laxmikant: > > Try it this way: > > 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 + '%') > > NOTE: Watch that the new values for the retireval arguments would be: > :as_store_id = '000017' > :as_acct_id = '1' > > Hope This helps. > > Marcos Calle Gamarra > Sistemas YURA S.A. > > -----Mensaje original----- > De: Laxmikant Kesti [SMTP:[EMAIL PROTECTED]] > Enviado el: Lunes 30 de Agosto de 1999 11:42 PM > Para: [EMAIL PROTECTED] > Asunto: PFCSIG Datawindow problem > > 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]
