updating multiple rows with ODBC

From: Albert <no_spam_contactemt_at_bigfoot.com>
Date: Thu, 3 Oct 2002 13:36:37 +0100
Message-ID: <anhdij$9p6$1@newsg4.svr.pol.co.uk>

Hi,

Can I implement array updating in C++ and ODBC ? I haven't found any examples of how to do so, can you help ?

I'm doing SQLExtendedFetch() bringing back 100 rows at a time. I amend some fields, then update 1 row at a time.

This is *very* slow (1 row 1/2 sec).
My database will have ~250,000 rows so this is not nice!

I'm working with personal oracle, so I don't need to worry abount contention, but a *well behaved* example would be appreciated.

Many thanks. Received on Thu Oct 03 2002 - 07:36:37 CDT