Welcome, Guest
Username: Password: Remember me
Components and Libraries for Database Development, discussions, problems and suggestions
  • Page:
  • 1

TOPIC:

IndexFieldNames(multiuse query) 12 years 4 months ago #2207

  • ExDatis
  • ExDatis's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 110
  • Thank you received: 9
:(
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. :sick:
How to clear IndexFieldNames?
Thanks.
C.T.2.5 XUbuntu12.4(32), Firebird2.5

Please Log in or Create an account to join the conversation.

Last edit: by ExDatis.

IndexFieldNames(multiuse query) 12 years 4 months ago #2208

  • ExDatis
  • ExDatis's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 110
  • Thank you received: 9
Well, I suppose, I'll have to find an alternative solution.
Thank you anyway.
Regards.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1