What is your native language? You may state the problem in Spanish, if it's easier for you.
>ok. i have Two table. Table X and Table Y
>when i press the button. i run an SQL so send the Data in question to Table X that works perfectly
>then i send the data from table X to Table Y thats where im kinda stumped.
>
>cause i search for Adition.name in a table if i find it program should say name found...if not found. its supposed 2 continue and allow the data to be sent to table Y. thing is table X only holds one record.
>
>So i open table X and i see the name Peter in table X
>then i open Table Y and i see the name Peter like 5 times(i executed 5 times)
>
>which tells me when the program ran the first time i seemed to work right and since the name wasnt there it sent it to table X then Y
>but when i ran it the second time it was supposed to give me the error message and it didnt instead it continued as if the name wasnt there
>but it did error and say that there was no index order
>
>
>
>USE ftab
>
>USE addition in 0
>SELECT addition
>SEEK addition.name
>SCAN
>IF FOUND()
>THISFORM.UpdateResultsWindow('error name already entered')
>ELSE
>THISFORM.continue
>ENDIF
>
>ENDSCAN
>
If it's not broken, fix it until it is.
My Blog