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@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 Mon Nov 27 2000 - 23:38:10 CST