|
|
| Re: Finding a Particular Record in a form [message #138326 is a reply to message #138268] |
Wed, 21 September 2005 06:11   |
sirish604
Messages: 4
Registered: June 2005
|
Junior Member |
|
|
Hii
I think it can be done like this.
Take a text box which is not attached to any canvas.
Now put ur condition in this text box and try to run the query by appending the earlier condition.
I will try to send the source code for this very soon.
Thanks,
Sirish.
|
|
|
|
| Re: Finding a Particular Record in a form [message #138327 is a reply to message #138326] |
Wed, 21 September 2005 06:22 |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
@sirish604:  Why build something that already exists?
Option 1:
Go to enter-query mode. Now you can enter values in any database item (you can even use wildcards and < or >) to compare that item with. Normally Forms will take your criteria in it's where clause when you execute the query.
Option 2:
Go to enter-query mode and Put a '&' in any database item. When you execute, a query-where box will pop up and you can enter criteria.
MHE
[Updated on: Wed, 21 September 2005 06:23] Report message to a moderator |
|
|
|
|
|
| Re: Finding a Particular Record in a form [message #156876 is a reply to message #138457] |
Sun, 29 January 2006 04:13 |
awan
Messages: 9
Registered: September 2005
Location: Riyadh
|
Junior Member |
|
|
hi ,
Well it has many solutions....one of through LOV's..I really like it and i'm using it on my different modules..
1)create one control block. add three text items.e.g,txt_p1,txt_p2 and var
2)create a LOV ...e.g, u wanna search the record through ...select id in query.....and retrun it in var text item..which is in u'r control block.
3)create one push button ..it might be in u'r block or in control block...
source code in button DECLARE
dummy BOOLEAN;
BEGIN
dummy := Show_LOV('LOV_name');
:TXT_P1 := 'ID';
:TXT_P2 := :Control_block_name.VAR;
GO_BLOCK('your_block_name'); /*write the name of u'r block where u want search */
SET_BLOCK_PROPERTY('your_block_name', DEFAULT_WHERE, :TXT_P1||' = :TXT_P2');
EXECUTE_QUERY;
END;
It will work really nice
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
