Ben Johnson wrote:

>
> 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.

If you're using Firebird 1.5 then this is no longer necessary. Use the name you've given the PK.
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)