Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!indetech!lrs From: lrs@indetech.com (Lynn Slater x2048) Newsgroups: comp.databases Subject: Re: C++ Interface to SQL Summary: ITI has a fix-pcx program and makefiles to match Keywords: oracle, c++, pro-c, interfaces Message-ID: <1991Feb7.175042.25168@indetech.com> Date: 7 Feb 91 17:50:42 GMT References: <5171@tellab5.tellabs.com> Reply-To: lrs@indetech.COM (Lynn Slater x2048) Organization: Independence Technologies, Inc. Fremont, CA Lines: 41 Kermit> Has anybody come up with either a C++ base object for manipulating Kermit> Oracle tables or a good C data/method hiding module source set. One of Kermit> the problems with dealing with Pro*C and C++ is that each set thinks Kermit> that it's the only preprocessor to Old C. Has anyone come up with a Kermit> good set of makefile rules for dealing with this combination? ITI has a program, fix-pcx, that takes Oracle Pro-C output and makes it acceptable to C++, either gnu or a Cfront port. We also have makefiles and otehr program development technques to support this and even to support symbolic debugging despite the fact that Pro-C messes up the #lines offsets. We have not sold this package as a separate item because it is not all that big a deal, but I am sure I could persuade the folks here to make it available for some nominal fee. If you want a big deal, ask about iDBio (or DBIOGen), which writes a C++ object that corresponds to a DB entity with some number of access techniques (queries) and provides programmer protection while hiding the use or Pro-C. This package provides select (single or multiple), insert, update, and delete on an entity based on one of its access techniques (where clauses) while insuring that all attributes referenced by the where clause have been set, that no changed attributes will be overwritten by a select, that no update really goes to the db if no attribute changed (changing "Joe" to "Joe" is not a change), that no insert happens if any attribute is not set or has not been set since the last change in the key attributes, etc. The generated classes also give you C++ COMPILE TIME check on the correctness of your types and their correspondence to the entity definition. For example, with iDBIO, it is trivial to insure that no one, no matter how unfamilar with the base schema or its design, adds an area code to a credit balance and stores it as an employee number. Special support is present for Oracle date and soundex capabilities. -- =============================================================== Lynn Slater -- lrs@indetech.com or {sun, ames, pacbell}!indetech!lrs 42075 Lawrence Place, Fremont Ca 94538 Office (415) 438-2048; Home (415) 793-1864; Fax (415) 438-2034