Impossible to define query parameter for postgresql #102
Comments
|
Hello! And create parameter next. The full example: |
|
Unfortunately doesnt worked. throws "input string was not in a correct format" Here is my xml : |
|
Using integer or bigint parameter datatype causes this problem. In my case the id field is mapped to a long property. If i select text as parameter datatype exception says id is bigint. If i select bigint throws "input string was not in a correct format" |
|
Same issue here |
|
Try to set up default value of the query parameter and add reference to a report parameter.
|
Try the same solution, please |
Yes it works. |
I want to create a datasource using postgresql connection in FastReport Desinger Community Edition. I write sql as;
select * from myusers where id=$1
and in the next screen create a parameter and didnt change the name as the docs stated, But i got an error saying "no parameters".
Then i named parameter as paramid then modified the sql as;
select * from myusers where id=@paramid
select * from myusers where id=@{paramid}
select * from myusers where id=$paramid
select * from myusers where id=${paramid}
select * from myusers where id=:paramid
select * from myusers where id=:{paramid}
all of sqls raised errors.
Is it really possible to do that?
The text was updated successfully, but these errors were encountered: