Hi!
I have SQLQuery component for simple queries which I use many times with different SQL, e.g.
DbModule.SQLAny.Close;
DbModule.SQLAny.SQL.Clear;
DbModule.SQLAny.SQL.Text:= SOME_SQL; //+ open
The problem occurs if I use(db_grid on TitleClick):
if not DbModule.SQLAny.IsEmpty then
DbModule.SQLAny.IndexFieldNames:= Column.FieldName;
After close/open new form(and use SQLAny), I've got error because IndexFiled exist.
I tried: DbModule.SQLAny.IndexFieldNames:= ''; without success.
How to clear IndexFieldNames?
Thanks.
C.T.2.5 XUbuntu12.4(32), Firebird2.5