Hi,

At December 20, 2005, 8:52 AM, mailgroupza wrote:

> Is there any reason why IB_Query should not return a complete result set

> I have IB_Query (SQL: Select * from OSTrip) connected to an IB_Grid.

> This is the second time in the last six months that users call to say
> that a record is not found in the grid. However runnung the same SQL
> in IBConsole for example shows the missing record.

> There are no filters in IB_Query, the query is simple and should not
> cause any problems. OSTrip is a view.

What is the transaction isolation in your application? If the
application is restarted, is that record visible or not? If it's
visible after restarting, I would suggest that you look at how you
manage the transactions within the application.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)