Subject | TIB_Cursor & AutoFetchAll |
---|---|
Author | tickerboo2002 |
Post date | 2002-08-07T15:05:19Z |
I'm still getting to grips with IBO, so forgive me if this is a dumb
question.
I'm using a TIB_Cursor to get a list of customers names using the
code below (Is the code the correct usage?). Initially, I set
AutoFetchAll to true, but the 'curCustomerNames->Eof' line failed
first time through. When AutoFetchAll was set to false, I received
the expected rows. I would have thought that I would get the same
results regardless what AutoFetchAll was set to. Why is this not so?
TIA
David
-------------------------------------------
curCustomerNames->Prepare();
curCustomerNames->Execute();
curCustomerNames->Open();
curCustomerNames->First();
int nID;
String sName;
while( ! curCustomerNames->Eof )
{
nID = curCustomerNames->FieldByName("Customer_ID")->AsInteger;
sName =curCustomerNames->FieldByName("Name")->AsString;
// Do stuff
curCustomerNames->Next();
}
curCustomerNames->Unprepare();
curCustomerNames->Close();
tnMain->Commit();
question.
I'm using a TIB_Cursor to get a list of customers names using the
code below (Is the code the correct usage?). Initially, I set
AutoFetchAll to true, but the 'curCustomerNames->Eof' line failed
first time through. When AutoFetchAll was set to false, I received
the expected rows. I would have thought that I would get the same
results regardless what AutoFetchAll was set to. Why is this not so?
TIA
David
-------------------------------------------
curCustomerNames->Prepare();
curCustomerNames->Execute();
curCustomerNames->Open();
curCustomerNames->First();
int nID;
String sName;
while( ! curCustomerNames->Eof )
{
nID = curCustomerNames->FieldByName("Customer_ID")->AsInteger;
sName =curCustomerNames->FieldByName("Name")->AsString;
// Do stuff
curCustomerNames->Next();
}
curCustomerNames->Unprepare();
curCustomerNames->Close();
tnMain->Commit();