>Any ideas why the second SQL statement here works fine in development, but fails on error 1814 in my EXE?
>

SELECT STR(PROCESSID,6,0)+STR(usernumber,6,0) FROM accessfile INTO CURSOR Temp
>
>SELECT appfile.PROCESSID, userfile.usernumber 		;
>	FROM appfile,userfile 				;
>	WHERE NOT STR(PROCESSID,6,0)+STR(usernumber,6,0) IN 	;
>	(SELECT * FROM Temp) 				;
>	INTO CURSOR NewRecs READWRITE
>

>(I'm trying to find all combinations of ProcessID and UserNumber, both N(6), not already found in AccessFile.)
>
>Any suggested alternatives?
>
>Thanks

1. Check if SET ANSI ON fix it

2. TRY

SELECT appfile.PROCESSID, userfile.usernumber 		;
	FROM appfile,userfile 				;
	WHERE NOT BINTOC(PROCESSID)+BINTOC(usernumber) IN 	;
	(SELECT BINTOC(PROCESSID)+BINTOC(usernumber) FROM accessfile) 				;
	INTO CURSOR NewRecs READWRITE

2.TRY ( but it can to be slower ):

SELECT appfile.PROCESSID, userfile.usernumber 		;
   FROM appfile,userfile 				;
   LEFT JOIN accessfile acc ON ACC.PROCESSID=appfile.PROCESSID AND ACC.usernumber = userfile.usernumber;
   WHERE ACC.PROCESSID IS NULL;
   INTO CURSOR NewRecs READWRITE