hi all,
I have the code below. it used to work fine but it no longer does. i had not changed the code, at least i am 99% sure that i did not. i have now added in some wait windows to find out whats happening. it is taking a car registration number and making sure that it was not used already. If i try this in a vfp command window it works, in code on the form it does not. i have checked the values that i pass in and they are all correct, ie a duplicate should be found. any help much appreciated.
lclregno = UPPER(ALLTRIM(thisform.pgfpageframe1.page4.txtCma_regno.Value))
SELECT 0
SELECT NWC
WAIT WINDOW "reg is_" + lclregno + "_"
IF lclregno <> ""
WAIT WINDOW "regno variable is not blank"
SELECT NWC
SEEK lclregno ORDER CMA_regno
IF EOF()
WAIT WINDOW "try a locate first"
SELECT NWC
LOCATE FOR lclregno = UPPER(ALLTRIM(CMA_regno))
IF FOUND()
WAIT WINDOW "locate found it"
ELSE
WAIT WINDOW "not found"
ENDIF
...
...
Go raibh maith agat
~M