Visual Basic 3.0 ODBC Update in Passthru

From: <D1CAMERO_at_bcsc02.gov.bc.ca>
Date: Wed, 14 Jul 93 08:09:43 PDT
Message-ID: <16C0B72C7.D1CAMERO_at_bcsc02.gov.bc.ca>


We are using Visual BASIC 3.0 with ODBC to access an Oracle database on a unix server. We tested queries with passthru and the response is .3 seconds. Without passthru the same query is 35 seconds. Our problem is we cannot update the result set using passthru.  

So we don't want a slow application. Is there another way to get the records FAST and be able to UPDATE?                            

Don Cameron
Data Management Branch, BC Ministry of Health 2nd Floor Rotherham, Victoria, B.C., V8W 3C8 (604)356-1425 D1CAMERO_at_bcsc02.gov.bc.ca Received on Wed Jul 14 1993 - 17:09:43 CEST

Original text of this message