TSQLQuery.Params[0].Value assignment or changing TSQLQuery.Params[0].Value.Type does not work
Original Reporter info from Mantis: ertank
-
Reporter name:
Original Reporter info from Mantis: ertank
- Reporter name:
Description:
Both on Windows 10 64bit and Lazarus 64bit, or Raspberry Pi 3 and Lazarus doesn't work.
Database server is PostgreSQL 9.4.10 on Raspberry Pi 3
Steps to reproduce:
I have following text in my SQLQuery1.SQL
Code: [Select]
select * from test where abc = :param
All below is at design time. I am using object inspector;
-Click Params (new windows pops: Editing SQLQuery1.Params[0])
-Click 0 - param to set parameter "param" (Object Inspector changes into TParam properties)
-Click Value and type something.
1- When I hit Enter Value reverts back to "(Null)"
2- When I try to set a Parameter Value Type it simply reverts back to "Null"
Additional information:
It is not just Object Inspector that cannot assign a parameter value, parameters are not assigned using code, too.
For attached project, I have log_statement = 'all' in my postgresql.conf to understand better what's going on.