From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.3 required=5.0 tests=BAYES_00,INVALID_MSGID autolearn=no autolearn_force=no version=3.4.4 X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 103376,ab77f5eae0f4ad62 X-Google-Attributes: gid103376,public From: mfb@mbunix.mitre.org (Michael F Brenner) Subject: Re: New ada user Date: 1997/05/13 Message-ID: <5l9r7q$eg0@top.mitre.org>#1/1 X-Deja-AN: 241275175 References: <335B7AE5.446B@univ-pau.fr> <1997May11.193035.3813@news.nbi.dk> Organization: The MITRE Corporation, Bedford Mass. Newsgroups: comp.lang.ada Date: 1997-05-13T00:00:00+00:00 List-Id: od (cnam05@univ-pau.fr) wrote: | HI!I am a new ada user. I would like to create a database with | customers adresses, etc... but i really don't know how to manage and | above all how to start : create records, use them, search for one | information, etc... Any help is welcome. Thanks One way to create records is with SQL statements from the ANSI Standard SQL (1987) or ISO SQL2 (1992) or the draft ISO X3H2-94-329 SQL-3 and by embedding the SQL statements in an Ada-95 program, perhaps using ANSI X3.168, or other methods of embedding, or interfacing (like an object request broker or SQL gateway. Then you manage records using the normal INSERT, UPDATE, DELETE, DEFINE TABLE, and SELECT technology used in ordinary commercial databases like Knowledgeman, Oracle, Sybase, DB2, XDB, Access, or any of the other commonly available database management systems. Another way to do it is to program an object which simulates a commercial database by providing methods like insert, update, delete, and a simple select. These simple databases should normally be replaced by SQL systems as soon as they are noticed, especially if the language in which they are implemented begins with the letter C, such as C, C++, and Cobol, because most of the y2k bugs and most of the software maintenance money we spend goes to mouse hangs and data errors in languages beginning with the letter C.