Devart Forums

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);
	}