Re: Prepared_Statement :(

["Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>]

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