| developper 2000 forms [message #79494] |
Mon, 17 June 2002 09:12  |
Roshan D'Souza
Messages: 8
Registered: March 2000
|
Junior Member |
|
|
Dear friends
I want to create a search form(query) for the below mentioned table named MESS using EXecute_querry. I want to querry the table for the field Date _of_p item but put a condition from 10-may-01 to 04-july-01. also the user should put the name for the field SPENDER. SO that user presses a query push button can get the details for the particular spender from so and so date . Using Execute_query I tried but its not possible to put a condition BETWEEN X and Y Date_of_purcahse in prequery. Please help.
DATE_OF_P ITEM AMOUNT Spender
--------- -------------------- --------- -------------------
10-MAY-01 RICE, 250 Roshan
27-MAY-01 BEEF 5330 SAm
15-MAY-01 RICE 250 VEEN
20-MAY-01 RICE,TOMATO,VEG, 300 ROSHAN
25-MAY-01 MISC 1000 Peter
21-JAN-01 RICE 2500 NAVEEN
25-MAY-01 TOMATO 450 SAM
29-MAY-01 JUICE 2.5 SAM
21-JUN-01 BEEF,TOMATO 350 SAM
01-JUL-01 tomato,onion 9.5 ROSHAN
04-JUL-01 VEG 2.5 ROSHAN
|
|
|
|
| Re: developper 2000 forms [message #79498 is a reply to message #79494] |
Tue, 18 June 2002 00:19  |
Remash
Messages: 52
Registered: November 2000
|
Member |
|
|
Hi
Assume you have text items SPENDER (Char), DATEFROM (Date) and DATETO (Date). The query you have requested for is as follows;
SET_BLOCK_PROPERTY('MESS',DEFAULE_WHERE,'SPENDER = '||''''||:SPENDER||''''||' AND DATE_OF_PURCHASE BETWEEN TO_DATE('||''''||TO_CHAR(:DATEFROM,'DD-MON-RRRR')||''''||') AND TO_DATE('||''''||TO_CHAR(:DATETO,'DD-MON-RRRR')||''''||')')
Hope this will help you.
Regards
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
