Home » Developer & Programmer » Forms » finding some rows from a table
icon7.gif  finding some rows from a table [message #111143] Mon, 14 March 2005 04:59 Go to next message
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 Go to previous message
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

Previous Topic: FRM-40735
Next Topic: changing the value of text programmatically!!!@@##
Goto Forum:
  


Current Time: Thu Sep 19 16:16:01 CDT 2024