Re: OO4O and No FindFirst
Date: 1995/05/04
Message-ID: <odysscci.347.00154B58_at_teleport.com>#1/1
In article <3o8gvd$c65_at_redstone.interpath.net> Lou Ingalls <ingalls_at_raleng.mtc.com> writes:
>Path: news.teleport.com!news.teleport.com!news.structured.net!sun.cais.com!ringer.cs.utsa.edu!swrinde!howland.reston.ans.net!news.sprintlink.net!redstone.interpath.net!usenet
>From: Lou Ingalls <ingalls_at_raleng.mtc.com>
>Newsgroups: comp.databases.oracle
>Subject: Re: OO4O and No FindFirst
>Date: 3 May 1995 18:10:52 GMT
>Organization: Interpath -- Providing Internet access to North Carolina
>Lines: 10
>Message-ID: <3o8gvd$c65_at_redstone.interpath.net>
>References: <sarek.10.005CEF52_at_cais.com>
>NNTP-Posting-Host: ingalls.mtc.com
>Mime-Version: 1.0
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>X-Mailer: Mozilla 1.1N (Windows; I; 16bit)
>sarek_at_cais.com (Scott T. Johnson) wrote:
>>I have been converting a VB application from Access to Oracle and using
>>OO4O to simplify the amount of code that must be re-written. I found deleted...
>Oracle does not support scrollable cursors... Check out Watcom SQL.
>Currently work with Oracle and love it compared to Sybase, etc but
>Watcom SQL has excellent features not supported by major vendors.
>Unfortunately Sybase had to buy Powersoft and most likely will ruin
>a good product. You should really look at Watcom if you are interested
>in "Personal Oracle".
While it is true that the Oracle ODBC driver does not support scrollable cursors, the above refers to OO4O which does. The OLE 2 implimentation is very nice, with a simple but robust API and much faster than the ODBC implimentation. I have used Watcom on a PC and it is a very nice product. I have crashed my pc and never lost any data or corrupted any indexes. I have found that if you have very large databases that watcom, while still good, slows down vs a server based (even if the server is less powerful than the pc) solution. The Personal Oracle database seems to be geared more to developers who are going to run their app against a server.
Jim Kennedy Received on Thu May 04 1995 - 00:00:00 CEST