Jim brought this issue up due to a conversation we were having, based on the
recent 3000-L thread. There is a portion of an application (a client-server
application) which must update a sort item. I've been debating the use of
CIUPDATE to gain the efficiencies (this is running over a 56K line from
Texas to Ohio)) of an UPDATE action query, or doing DELETEs and INSERTs -
which I know will maintain the sort order of the sort key.
Since there are legacy apps rely on the sort item - I can get around this by
resorting the recordset (with ORDER BY) when doing inserts - but I'd rather
use and UPDATE action query.
So - we'll put this one to bed - I have both pieces of code written - I will
test both and let you all know. I also want to test this in Texas though,
over that 56K Line - it's a big difference over a 10/100 LAN here.
Joe