>so here it is,
>
>

>cfields=tno+riskno+agytype+agycode+provcode+alltrim(lastnme)+alltrim(firstnme)+alltrim(midnme)+alltrim(desig)+alltrim(station)+dtoc(efecdate)+dtoc(matdate)+paid+dtoc(dpaid)+canceld+dtoc(dcanceld)+str(bondamt,16,2)+str(premamt,16,2)+dtoc(dprep)
>
>select * from tbond where cfields not in (select cfields from bond)
>

>
>now i get another error: SQL: Queries of this type are not supported.
>
>what should i do?

1) Use semicolons.

2) You have created a static value in m.cFields. That is probably not what you wanted.

cfields="tno+riskno+agytype+agycode+provcode+alltrim(lastnme)" ;
+"+alltrim(firstnme)+alltrim(midnme)+alltrim(desig)+alltrim(station)" ;
+"+dtoc(efecdate)+dtoc(matdate)+paid+dtoc(dpaid)+canceld" ;
+"+dtoc(dcanceld)+str(bondamt,16,2)+str(premamt,16,2)+dtoc(dprep)"

select * from tbond where &cfields. not in (select &cfields. from bond)

3) Calling something lastnme instead of lastname is just asking for trouble. I'd bet most people would have trouble remembering to drop the "a" from name.

4) Check out my snippet factory object article. You may never have to type that huge formula ever again.

http://msvfp.advisorguide.com/doc/17440