finding some rows from a table [message #111143] |
Mon, 14 March 2005 04:59 |
khabbab
Messages: 10 Registered: March 2005 Location: france
|
Junior Member |
|
|
Hi,
I'm new in developer forms how can i do this with forms:
select *
from name_table where column_name like '%var%';
i want receive all rows .
can i do this with Master/details???
Thanks for help.
|
|
|
Re: finding some rows from a table [message #111146 is a reply to message #111143] |
Mon, 14 March 2005 05:26 |
|
saadatahmad
Messages: 452 Registered: March 2005 Location: Germany/Paderborn
|
Senior Member |
|
|
Create a Form in Form Builder using the table emp.
Create a Tabular Form showing 10 rows.
Run the Form.
Click on Enter Query.
Write in the ename Field A%
Execute the Query.
This will show all the records with the enames startnig with A%.
You can restrict the Query at Run-Time by Form Builder using this method.
You can do the same with your master/detail blocks.
If you don't want to restrict the results, just click on Execute Query Button. It will show all the records.
[Updated on: Mon, 14 March 2005 05:27] Report message to a moderator
|
|
|