Subject using RDB$PRIMARY17 in PLAN
Author Ben Johnson
Hi,

I have used SELECT statment like the following and I have
used
RDB$PRIMARY17 in PLAN.

SELECT account_book.entry_date, account_heads.account_nm,
account_book.narration,
account_book.debit, account_book.credit,
account_book.chq_dd_no
FROM account_book, account_heads
WHERE ( account_book.company_id = account_heads.company_id )
AND ( account_book.account_id = account_heads.id )
AND ( ( account_book.company_id = :dCID ) AND (
account_book.cash_bank_id = :dCBID )
AND ( account_book.entry_date >= :dFrom ) AND (
account_book.entry_date <= :dTo ) )
PLAN ( ACCOUNT_BOOK INDEX ( ACCOUNT_BOOK_CB ), ACCOUNT_HEADS
INDEX ( RDB$PRIMARY17 ) )


Is there any chance of 17 in RDB$PRIMARY gets changed to some
other value
during a restore/backup or any other process ?

Thank you.

Ben.
_______________________________________________________________________
Odomos - the only mosquito protection outside 4 walls -
Click here to know more!
http://r.rediff.com/r?http://clients.rediff.com/odomos/Odomos.htm&&odomos&&wn