Zeoslib Portal

Use Zeos 7.2

select now()::date -->syntax error

but

select now()::::date -->Run

This is as expected. The default param char is the ':'. One possibility is to change the ParamChar property to something different, '#' maye.

Another possibility is to use a standard SQL cast. Cloudflare currently keeps me from posting an Example here...

with qrySQL do begin
ParamChar:='#'; //--> Ok
Close;
SQL.Clear;
SQL.Add('select now()::date');
Open;
end;

Ok Jan Thanks
Now error syntax no show