FIND or GET

gulamdastagir · 2008-01-16

I have table with three fields Entry No,Contact No,User

Entry Number is the Primary key

Contact No,User is the Secondary key

recProspect.RESET;
recProspect.SETCURRENTKEY(recProspect."Contact No",recProspect."User");
recProspect.SETFILTER(recProspect."Contact No","Contact No.");
recProspect.SETFILTER(recProspect."User","USER ID");
IF recProspect.FIND('-')  THEN MESSAGE('You have to Send the Details');

The message box doesnt display even when there is a record with the company and User.

ara3n · 2008-01-17

Debug it and see what the filters are on recProspect
when the findfirst is called.

Alex_Chow · 2008-01-17

Check your User field to see if it's CODE or TEXT. Text is case sensitive.

garak · 2008-01-17

Do you mean the UserID of curr. logon user :?:
This ist the global vaiable USERID.
You use recProspect.SETFILTER(recProspect."User","USER ID");
What is "User ID"?
Is this an field in your table or an other variable and whats the value ?

Regards

Stardust77 · 2008-01-17

garak wrote:

Do you mean the UserID of curr. logon user :?:
This ist the global vaiable USERID.
You use recProspect.SETFILTER(recProspect."User","USER ID");
What is "User ID"?
Is this an field in your table or an other variable and whats the value ?

Regards

Perhaps it should be:
recProspect.SETFILTER(recProspect."User",USERID);

Waldo · 2008-01-20

Please send the contents of the table ... and try to answer the question about the "USER ID"/USERID

. Also, where does the value of "Contact No." come from?

I suggest to use SETRANGE instead of SETFILTER .. and using the ISEMPTY statement, like:

recProspect.RESET; 
recProspect.SETCURRENTKEY("Contact No","User"); 
recProspect.SETRANGE("Contact No","Contact No."); 
recProspect.SETRANGE("User",USERID); 
IF NOT recProspect.ISEMPTY THEN 
  MESSAGE('You have to Send the Details');

FIND or GET

Comments

Categories