Subject Bof and Eof Problem
Author Chris Hulsey
Hello All,

I am in the process of converting over to IBO from the BDE. I replaced a TTable with the TIB_Query. I load the TIB_Query with a SQL string like "SELECT * FROM TICKET_INFORMATION ORDER BY ACTIVE_DATE DESCENDING". It fetches the records but the Bof and Eof don't seem to work properly. The don't seem to realize that I am on the first or last record until I go past them.


void __fastcall TForm_TripleWindow::Button_ScrollPreviousClick(
TObject *Sender)
{
if (!Query_TicketInformation->Bof)
{
Query_TicketInformation->Prior();
PopulateTicketCaption();
PopulateTicketDetail();
}
}

void __fastcall TForm_TripleWindow::Button_ScrollNextClick(TObject *Sender)
{
if (!Query_TicketInformation->Eof)
{
Query_TicketInformation->Next();
PopulateTicketCaption();
PopulateTicketDetail();
}
}

Chris Hulsey
chulsey@...



[Non-text portions of this message have been removed]