Re: Prepared_Statement :(

[eduardsapotski@gmail.com]

суббота, 24 ноября 2018 г., 14:05:02 UTC+3 пользователь Dmitry A. Kazakov написал:
> On 2018-11-24 11:45, eduardsapotski@gmail.com wrote:
> > Trying insert data into PostgreSql:
> > 
> >     function Insert_Trade(Trade : Trade_Type) return Boolean is
> >        
> >        Conn   : Database_Connection := Build_Database_Connection;
> >        PS     : Prepared_Statement  := Prepare(Query => "INSERT INTO exmo.trades(trade_id, pair, type, price, quantity, amount, date) VALUES (?, ?, ?, ?, ?, ?, ?)");
> >        Params : SQL_Parameters(1..7);
> >        FC     : Forward_Cursor;
> >        
> >        Result : Boolean := False;
> >           
> >     begin
> > 
> >        Params(1) := "+"(Trade.Trade_ID);
> >        Params(2) := "+"(Trade.Pair);
> >        Params(3) := "+"(Trade.Direction);
> >        Params(4) := "+"(Trade.Price'Img);
> >        Params(5) := "+"(Trade.Quantity'Img);
> >        Params(6) := "+"(Trade.Amount'Img);
> >        Params(7) := "+"(Trade.Date);
> >      
> >        Execute (Conn, PS, Params);
> >          
> >        Commit_Or_Rollback(Conn);
> >        
> >        Put_Line(Conn.Last_Error_Message);
> >        
> >        return Result;
> >        
> >     end;
> > 
> > Result:
> > 
> > ERROR:  syntax error at or near ","
> > LINE 1: ...ir, type, price, quantity, amount, date) VALUES (?, ?, ?, ?,...
> >                                                               ^
> > What's wrong? :(
> 
> First. You don't say what library/binging/RDBMS client you are using, 
> which version, what platform. That is certainly wrong.
> 
> Then, "date" is a reserved keyword in SQL, which has tons of. You could 
> start with qualifying all column names in the statement.
> 
> -- 
> Regards,
> Dmitry A. Kazakov
> http://www.dmitry-kazakov.de

with GNATCOLL.SQL_Impl;       use GNATCOLL.SQL_Impl;
with GNATCOLL.SQL.Exec;       use GNATCOLL.SQL.Exec;
with GNATCOLL.SQL.Postgres;   use GNATCOLL.SQL;

If I just write:

Execute(Conn, "INSERT INTO exmo.trades(trade_id, pair, type, price, quantity, amount, date) VALUES (100500, 'pair', 'type', 1.0, 1.0, 1.0, 100500)");

Everything is working!
I think the problem is in the parameters.