>Hi all,
>
>normally I would do a seek on a table that has a 2 field index, if I find the entry I update a field, if not I create a new record.
>I was thinking about changing this to an update command, but wondering if there are any issues, speed mainly, with this.
>
>update table1 set field3 = "some data" where field1 = "ABC" and field2 = "DEF"
>if _tally = 0
> insert into table1 (...) values(...)
>endif
>
>it doesn't seem to slow things down as against a seek but I'm wondering if this is the dont thing.
>the reason I would like to move to an update command is to modify code to be more like .net and sql which we're migrating to.
>
>~M
You must be sure that the UPDATE query is optrimizable.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.