Lyle wrote: > psykx.out wrote: > >> I'm not I understand perfectly, you can use 'replace into' instead of >> 'insert into' if you want to overwrite (edit) existing data. replace >> acts like insert if the is no existing record >> > > Thing is I don't want to replace, I want to merge... > > > Lyle > _______________________________________________ > BristolBathPM mailing list > [email protected] > http://mailman.bristolbath.org/mailman/listinfo/bristolbathpm > Ah the beauty of replace, if you don't set all the fields in the table and it replaces another row it just leaves the old data there.
Max _______________________________________________ BristolBathPM mailing list [email protected] http://mailman.bristolbath.org/mailman/listinfo/bristolbathpm
