Re: Interfacing Oracle and Visual Basic
From: Charles Newman <newmanc_at_hotmail.com>
Date: Tue, 28 Nov 2000 05:38:10 GMT
Message-ID: <8vvgc2$29j$1_at_nnrp1.deja.com>
Date: Tue, 28 Nov 2000 05:38:10 GMT
Message-ID: <8vvgc2$29j$1_at_nnrp1.deja.com>
In article <8vd8os$ten$1_at_news10.roka.net>,
"Jochen Pege" <pege_at_kespretlang.de> wrote:
> Try to use an ADO Conncetion. After you established the connection you
can
> use the normal methods (.addnew,....) or, and this would be the faster
way
> you can you simple SQL Statements.
I am afriad there is NO WAY you can use SQL statements to UPDATE a dabase, on Visual Basic.
When I do the following.
adoc1.RecordSource = "insert into orders .... {data to be inserted} adoc1.Refresh
I get the message "Missing SELECT Keyword" from Visual Basic. You can ONLY update, using the Update property.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Nov 28 2000 - 06:38:10 CET