> >USE m.lcTableName > >SELECT cmpid, ts, IsUpdated FROM m.lcTableName WHERE IsUpdated > 0 INTO CURSOR; >local_cursor > >**! Form retrieve from server list >SQLEXEC(this.connhandle,"select cmpid, ts, IdDeleted from companies where; "+TTOC(settings.lastupdate,1)+" > ts", "remote_cursor") > > >**! Compare the two tables & elminiate depreciate matches > >SELECT x.cmpid, x.ts AS ts_local y.ts AS ts_remote FROM local_cursor x LEFT JOIN; remote_cursor y ON x.cmpid = y.cmpid INTO CURSOR matches_cursor > >**! The SELECT command above is the line that nukes :^). >>After reading through the on-line help for SELECT and comparing syntax,