Subject | Bof and Eof Problem |
---|---|
Author | Chris Hulsey |
Post date | 2001-03-26T20:43:56Z |
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]
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]