Re: interface between Visual Basic and Oracle
Date: Sun, 21 Jun 1992 04:56:22 GMT
Message-ID: <1992Jun21.045622.1462_at_oracle.us.oracle.com>
In article <27130_at_rnd.GBA.NYU.EDU> atuzhili_at_rnd.GBA.NYU.EDU (Alexander Tuzhilin) writes:
>I'm trying to develop an application using a full-fledged relational
>database on a PC under MS-Windows. The application must therefore have
>a nice Graphical User Interface (GUI). I was thinking of using Oracle
>as the database and Visual Basic as the programming language since it
>has a nice GUI. Does anyone have any experience using the two
>together?
>
Yes. You can write in Visual Basic and use Oracle for Windows. OFW has a DDE Manager component. The DDE Manager is a DDE server that runs in its own window. It allows you to send SQL to Oracle using the DDE protocol and receive data back into the program. Works very well for small amounts of data. I haven't got any experience trying it on large amounts of data, however.
I have a library of VB calls in there
that isolates all of the DDE nastyness from your code. If you like I
can email you the source (it's not long) to these calls. If there
is sufficient interest I can post it here, as well.
Mark D. Richter, Architect
Oracle Desktop Products
Box 659409
500 Oracle Parkway
Redwood Shores CA 94065
CIS: 70400,3514
Mark D. Richter 1.415.506.4852 Oracle Corporation, Desktop Products Division mrichter_at_us.oracle.com500 Oracle Parkway, Box 659409, Redwood Shores, CA 94065
------------ "Unlike leadership, golf builds character."------------------Received on Sun Jun 21 1992 - 06:56:22 CEST