Hello Dr. Belhareth ,

@XLookup() returns a string.
You are assigning the value that @XLookup() returns to vVorhanden which is declared as an Int
You will want to change vVorhanden to be a string.

Then if vVorhanden matches vRecordNo then the record already exists in Clock.

-Ray

Hello,

vVorhanden is never going to equal 1. If the XLookup is successful, and the record exists, then it will equal the value in vRecordNo

Try the following code. Be sure you reconcile before you test it and do not test it in preview mode as X commands do not work in preview mode. Let me know what the WriteLn() window says.

var vTree as INT
var vId as String
var vRecordNo as String
var vVorhanden as String

	vId = @UserID

	vRecordNo = @Replace(@Date, "/", "") + @UserID
	vVorhanden = @XLU(@FN, vRecordNo, "CLOCK!RecordNo", "RecordNo")
	writeln(@Error)
	writeln("RecordNo : " + vRecordNo + " Ergebnis: " + vVorhanden)

	If vVorhanden = vRecordNo Then
	{
		//The record already exists in clock
	}
 

-Ray

Hello,

There is a problem in the @XLookup().

Things to check:
Is "CLOCK" the name of a form in this DB file?
Does the "CLOCK" form have an element on it that is named "RecordNo"?
Are you in Preview Mode? X commands will not work in Preview mode.

-Ray

What is the type of the RecordNo LE?

When you look at your CLOCK form at some data, what does the RecordNo LE look like?

If at all possible, hardcode the key argument in your XLookup instead of building the key in code. Use a string that you absolutely know matches perfectly. At the very least, do a writeln on the code that calcs the key argument, and make sure that it is formatted exactly like the RecordNo LE for the intended record. Remember that the key argument is formatted like a search spec, and uses the same special search characters that a search spec uses. Try using your key value in the RecordNo LE in search spec for CLOCK and see what record it returns.