[SOLVED] Problem Quick Search (No Result Found) In Postgres and Firebird

Applications Grid / Reports
#1

Hello…

Actually i’m new as postgre and Firebird user, previously i’m using Mysql and MariaDB for my project for 3 years.

In Postgres :
when i create grid apps this “quick serach” menu can not function properly, like when i search there alaways no result found.
(I Had checked “Contain” Option).

I also try to use search option, but No result also.

I try to add query into grid apps sql with syntax “where posttext @@‘text’” ==> I’m Using Gist Index to improve performance on Full Text Search but no result

I try to make query with add syntax where “column table” like ‘text%’==> no result .

I can not search value from lookup query (using text/number autocomplete field) from any value too

In Firebird :
Quick Search also no result in firebird RDBMS.

I can not search value from lookup query (using text/number autocomplete field) from any value too

Please any help will appreciated.

SC 6.0028
Postgres 9.1
Firebird 2.15 and firebird 2.5.1
Thanks
Suyono

#2

Re: Problem Quick Search (No Result Found) In Postgres and Firebird

It works, I’m using CAPSLOCK to get value from quicksearch.

#3

Re: Problem Quick Search (No Result Found) In Postgres and Firebird

Hello,

Were you able to solve the issue?

regards,
Bernhard Bernsmann

#4

Re: Problem Quick Search (No Result Found) In Postgres and Firebird

Yes, i’m using collate UTF 8 in postgre 8.4 and firebird 2.1 then in scriptcase’s apps i’m going to Apps–>SQL–> choose Case Sensitive to No.

Problem Solved.

Thanks for your reply.

Suyono