Scrpit to find record

[Alpana]

hi

i have 2 columns in database (department and status) and i want to know how to write a scrpit department="department1" where status ="Delay".here is one problem department and status are in dropdownlist and "delay","completed" etc is given by user in edit box.

plz help me

thanks

[Techphan]

Your script should look something like this (5 steps):

 

Go to layout [your table layout containing the two fields]

Enter find mode [pause - or you can choose no pause]

Set field [Your table::department;"Department1"]

Set field [Your table::status;"Delay"]

Perform find

 

You can also add other sommands such as sort after the perform find. If no records are found an error message will pop-up telling you there are no records.

[Alpana]

but delay ,completed is given by user at program is run

[Techphan]

Hi Alpana-

 

Let me see if I understand....

 

You want to run a search, but let the user CHOOSE what values to enter into the search fields?

 

And then let the script finish the rest?

 

A. Make two global fields (I use a table called global unless I want the global field mixed into my data tables).

B. Put the global fields on your table layout in the header.

c. Use the SAME drop-down or pop-up list attributes as you do for the data fields you will be lookig through.

D. Make a "Show All Records" button.

E. Make a "Custom Search" button and set it equal to the following script:

 

 

Go to layout [your table layout containing the two fields]

Enter find mode [no pause]

Set field [Your table::department; Global::department]

Set field [Your table::status;Global:status]

Perform find

[Alpana]

hi thanks for help

 

but my query is :- i have 3 field in my database one is departmentname , status,name.then i have dropdown list that contain value list status, name. user selct department name and after that select status or name from dropdownlist now according to the selected field from dropdownlist user type value in editbox for searching. now i want to know how i write script for find in such situation.

hope u understand

thanks