TIBQuery1.Active := True;

eibclienterror 'xsqlda index out of range'

I was using a data module that inherits several components from another data module. In this case, the query object on the parent data module had TIBQuery.Params set to some value. On the child data module, TIBQuery.ParamCheck was set to False and the Params property was cleared via the IDE. The error was generated because, in this situation, the Params.Count property is not cleared (set to zero) even though the actual number of parameters is zero.

There are several possible solutions

• The Params property can be cleared on the parent data module via the IDE
• The Params property can be cleared via code

  TIBQuery1.Params.Clear;
  

• Set TIBQuery.ParamCheck to true on the child data module before setting the SQL property

This problem was harder to find than normal because

• I was inheriting from a data module
• I deleted the Params property via the IDE on the child data module
• The Params.Count property was not automatically cleared (set to zero)
  (I consider this to be a Delphi design problem)
• Google only returned 3 hits - all related to stored procedures

BTW, ParamCheck cause the parameters property to be automatically generated when the SQL property is modified - it does NOT control using the parameters (which is why I disabled it - it is true by default).

If you try to write to the table, the you get a "file not found" error message from the Microsoft ODBC driver - because the driver generates the error, I believe that this is a Microsoft design problem ... not a Delphi problem.

It does not matter if the directory path contains spaces ... just the table names.

abc 123.dbf    Fails on insert, ok to read
abc_123.dbf    Ok

URL: http:// cpcug.org / user / clemenzi / technical / Databases / Delphi / Misc_Problems.html