The following query fails with an exception
Code: Select all
UniQuery1->SQL->Clear();
UniQuery1->SQL->Text = "select count(*) as rowcount from sqlite_master"
UniQuery1->FieldDefs->Update();
TField *field;
for (int f = 0; f < UniQuery1->FieldDefs->Count; f++)
field = UniQuery1->FieldDefs->Items[f]->CreateField(UniQuery1);
TIntegerField *field2;
field2 = new TIntegerField(UniQuery1);
field2->FieldName = "id";
field2->FieldKind = fkCalculated;
field2->DataSet = UniQuery1;
UniQuery1->Open();
while(!UniQuery1->Eof)
{
for(int i=0; i<UniQuery1->FieldCount; i++)
{
f = UniQuery1->Fields->FieldByNumber(i+1); <-- results in exception "Error Field is not BLOB"
}
}
Code: Select all
UniQuery1->SQL->Clear();
UniQuery1->SQL->Text = "select count(*) as rowcount from sqlite_master"
UniQuery1->Execute();
TField *f;
for(int i=0; i<UniQuery1->FieldCount; i++)
{
f = UniQuery1->Fields->FieldByNumber(i+1);
}