PFW 4.5 Using 2 field values in locate 
Author Message
 PFW 4.5 Using 2 field values in locate
Hi...I've been using Paradox for Windows 4.5 for approximately 2 months.  I
previously used the 1.0 for Windows for 8 months or so.  I am an intermediate
ObjectPAL coder.  

Here is what I'm trying to do.  I would like to create a push button that will
prompt me to input a person's name (first and last) and then have that record
appear on my screen.  The first and last names are located in separate fields.
I have tried several combinations and I can't seem to get it to work.

Anyone else with some ideas?  Thanks.



Sat, 05 Oct 1996 03:42:48 GMT
 PFW 4.5 Using 2 field values in locate

Quote:
>Here is what I'm trying to do.  I would like to create a push button that will
>prompt me to input a person's name (first and last) and then have that record
>appear on my screen.  The first and last names are located in separate fields.
>I have tried several combinations and I can't seem to get it to work.

this isnt too difficult, just separate evrything with comma's:

the statement with one field is something to the effect of:

        locate(field_name,"field value")      right?

well, just do this:

        locate(field_name1,"field1 value",field_name2,"field2 value")

That will/should do it!  good luck

- Marc



Sun, 06 Oct 1996 11:33:03 GMT
 PFW 4.5 Using 2 field values in locate

Quote:

>Hi...I've been using Paradox for Windows 4.5 for approximately 2 months.  I
>previously used the 1.0 for Windows for 8 months or so.  I am an intermediate
>ObjectPAL coder.  

>Here is what I'm trying to do.  I would like to create a push button that will
>prompt me to input a person's name (first and last) and then have that record
>appear on my screen.  The first and last names are located in separate fields.
>I have tried several combinations and I can't seem to get it to work.

>Anyone else with some ideas?  Thanks.

I do this by creating another form with the fields I want to prompt for.  I then
open the form from a button on the main form.  Issue a wait so the user has to
respond to my locate dialog box.  If the user presses the ok button I pass back
the values as a string (separated by the bar character "|").  On the main form
side I break apart the string using the BREAKAPART string method.  I then do the
locate using a tcursor (faster than doing it by using a uiObject) and RESYNC a
uiObject to the tcursor if the locate is successful.


Tue, 08 Oct 1996 12:04:34 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Access attach to PfW 5.0 tables or Counter field in PfW 4.5

2. Manually incremented fields, PFW 4.5

3. Running PfW 5.0 apps using 4.5 Runtime

4. Installing PfW 7 over 4.5

5. PfW 4.5 Report windows missing methods

6. Mail labels with PfW 4.5

7. PFW 4.5

8. (PFW 4.5) Text attributes from OPAL

9. Help with date calcs in PfW 4.5

10. PFW 4.5 minimize/maximize question...

11. PfW 4.5 Default locking with data models?

12. Trouble connecting PfW 4.5 (sql) to database server


 
Powered by phpBB® Forum Software