Subject Re: [firebird-support] Very Strange: Query giving different results
Author Ann Harrison

On Mon, Oct 5, 2015 at 12:59 PM, 'Alexis (PROINTER)' alexis@... [firebird-support] <> wrote:
Hi, we have found a very strange problem with our firebird database, a
record on a table of firebird databes is not always beeing returned:

1 - Using flamerobin we are never fetching record 1648 of our datble.

2 - Using an application we are developing (with on vs2010) the
record is fetched:

3 - If we query from the application with condition IDESTADO = 3 wich the
desired record has that value that record is also not fetched:

Yahoo ate your table structure, so this is just a guess.  You may have an index that's missing an entry - that shouldn't happen, of course.  Using isql, try fetching the record by primary key value, primary key concatenated with an empty string (if it's a string) or plus zero (if it's a number).  They try the same thing on any secondary indexes.

Good luck,