Hi

>in FB1.5 this behavior was changed. Primary key or foreign key was
>saved in RDB$INDICES with original name !! This is very good for using your
>own plan in sql query, but it crashed IBRest and foreign keys Now IBRest
>think this is a secondary index, create them and crashed when trying to
>create foreign key.
>
>I am in a fix here I am dependent on the util and this problem does not want to go away. I have requested Bogdan but I can understand he has his own commitments.
>

>I will come back to this, have you tackled of converting FB databases to the new structure from a sample empty database? Basically I feel this util, which is in Delphi, is pretty open source as Bogdan has personally sent me the codes. Is there any way to clone it, albiet with Bogdan's permission, in VFP?
>
>I have studied the code, but there are few things like data structures for opening a FB database (I guess equiv. to FILE in C/C++) which I am not sure about.
>
>I don't intend to monopolize your time but I would appreciate your feedback.

I would write one from scratch, but a one need a lot of docs. reading about system tables. Takes time.