Re: Compiling GNATColl on Windows

["Björn Lundin" <b.f.lundin@gmail.com>]

On 2014-12-15 17:10, Michael Hardeman wrote:
> On Monday, December 15, 2014 10:50:01 AM UTC-5, David Botton wrote:
>>> It is not looking for libpq.dll but rather libpq.a for your gcc environment. 
>>>
>>> http://www.mingw.org/wiki/createimportlibraries
>>
>> If you are doing a windows centric project consider using ADO, there are database bindings in GWindows - https://sourceforge.net/projects/gnavi/
>>
>> If doing something cross platform ODBC also an option see http://www.dmitry-kazakov.de/ada/components.htm
>>
>> David Botton
> 
> I'll look into dmitry's ODBC bindings. They may be sufficient for my needs.
> 


If it is just postgres you want,
I use this
https://dl.dropboxusercontent.com/u/26175828/sql-pg.zip

It's based on an old binding from Samuel Tardieu,
on which I put another layer on a somewhat higher
abstraction layer.


For just reading...

    Stm : Sql.Statement_Type;
    T : Sql.Transaction_Type;
    Sql.Connect(Db_Name => "My_Db" => user ...);
    Stm.Prepare("select COL1,COL2 from MY_TABLE where a = :A and b = :B");
    T.Start;
    Stm.Set("A",Some_Value);
    Stm.Set("B",another_value);
    --Open a cursor at the backend - This executes the query
    Stm.Open_Cursor;
    Stm.Fetch(End_Of_Set);
    If not End_of_set then
      Stm.Get("COL1",Some_Variable);
      Stm.Get("COL2",Some_Other_Variable);
    end if;
    Stm.close_cursor();
    T.Commit();
    Sql.Close_Session;

    use Some_Variable and Some_Other_Variable

--
Björn