Re: ada and database

["bubble" <bubble@bubble.d2g.com>]

copy it from
http://en.wikibooks.org/wiki/Programming:Ada:Libraries:Database:GWindowswith
Ada.Text_Io;
use Ada.Text_Io;
with Gnatcom.Initialize;
with Gwindows.Databases;
use Gwindows.Databases;
with Gnatcom.Types;
with Gnatcom.Variant;
with Ada.Strings;
with Ada.Strings.Fixed;
with Ada.Exceptions;
with System;
procedure test is
     Connection : Database_Type;
     Recordset : Recordset_Type;
     customer     : Gnatcom.Types.Variant;
begin
     Gnatcom.Initialize.Initialize_Com;
     --make connection
     Open (Connection,
        "DSN=Northwind","your ID","your password");
     --make Recordset(ResultSet)
     Open (Recordset,
        Connection,
        "SELECT * from Orders",
        Dynamic,
        Optimistic);
     --start to process your bussiness solution
     while not Eof (Recordset) loop
        customer:=Gwindows.Databases.Field_Value(Recordset,"customerId");
        process(customer);--your customer procedure
        Move_Next (Recordset);
     end loop;
     ---release database resource
     Gwindows.Databases.Close(Recordset);
end test;