Re: [Info-ingres] Invalid TID

Hi Martin !!!

Thanx for the mail. Dropping of secondary index has
infact solved my problem. I thank you for the precise
solution u gave me. U r indeed great !!!

However when i created secondary index again , the
problem of "Invalid TID recurred" .

I think I have to work without secondary indexes.

Thanx again for the help.

Its the tip that matters , and a drop of water in the
sea that makes a pearl .


Bodh RAJ



--- martin.bowes@xxxxxxxxxxxxx wrote:

Hi BODH

In fact this eror is only appearing when I am
inserting /updating data on a table "po_file2"
I have checked that through putting messages in
the
application.

Do you know exactly what query your application is
running when this
error is generated. My guess is that its involved in
a multi-table join and
that the problem relaates to the query itself and
not to any underlying
problem in the data table.

Does the table have a secondary index that is
involved in the query?
If so drop the index and try the query again.
Then recreate the index and try again and see if the
problem returns.


Nothing appears during direct table update.
I have run verifydb and found no error.

Which is comforting.

Marty




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
.

Relevant Pages

  • Re: Query fails to retrieve data
    ... This query returns no record. ... I remove any of the other two secondary index files, ... I see that it has an index on acode (the field that we ... checked by looking at the block code in another secondary key file that does ...
    (comp.databases.paradox)
  • Re: Query fails to retrieve data
    ... If you have a secondary index that starts with the primary key, ... Finally, is it just this query that is slower, or other aspects of your system? ... Well..in fact this query is not slower. ...
    (comp.databases.paradox)
  • Re: Query fails to retrieve data
    ... If you have a secondary index that starts with the primary key, ... In my experience, using peer-to-peer networking, every ... is to speed up sequential processing. ... Finally, is it just this query that is slower, or other aspects of your system? ...
    (comp.databases.paradox)
  • "order by" slow on indexed field
    ... Adding a top clause like ... so the query is very slow ... query using ADO? ...
    (microsoft.public.data.ado)
  • Re: Class to select/insert/delete/update
    ... which takes the tablename, a list of fields to query and the where cluse, ... > Do You Yahoo!? ... Mail has the best spam protection around ...
    (perl.beginners)