Hi.

I'm migrating my application from bde to elevate with delphi 2007 and elevate 2.0

I have an unit to find records that use the index if exist. Curiously i have a table with
an index that if the length of the field is between 18 and 25 it gives me the error
"Access violation" when i try to use this index.

In the example that i send you if you type some character in the fields "CODIGO" or
"DESCRIPCION" the unit select the index asociated and find the first record than have the
character typed correctly. If you type in the field "ARTICULO" will do an error. If you
change the length of the field "ARTICULO" to 30 for example it not give error.

The example must execute in the folder C:\PruebaElevate

¿Any idea?

Thank you

Francisco,

Thanks for the project, but please do not post attachments in this
newsgroup - use the Binaries newsgroup instead.

<< I have an unit to find records that use the index if exist. Curiously i
have a table with an index that if the length of the field is between 18 and
25 it gives me the error "Access violation" when i try to use this index. >>

It's just a coincidence.  The problem is switching the active index with an
OnFilterRecord event handler defined.  A fix will be in 2.01 B2.  The
workaround for now is to set the OnFilterRecord event to nil before
switching the index, and then setting it back to the desired value after
switching the index:

with MyTable do
  begin
  OnFilterRecord:=nil;
  IndexName:='MyIndex';
  OnFilterRecord:=MyFilterRecordEventHandler;
  end;

--
Tim Young
Elevate Software
www.elevatesoft.com

Solved.

Thank you and sorry for the file attached.