Hi Cetin

>As you already know I don't know Firebird:)

Yes, I know and I appreciate you responding in any case.

>This one took my attention:

Actually this is my own documentation. The CodeBook parent class code was if I am not mistaken made for SQL Server. So it I had to override it and I had put in the comment as my reminder *g*

>>*** we are also assuming that the generator is named as follows
>>*** gen_maccounts_iid"

What I meant here is in the pattern gen_ followed by the table name and then _iid

>"GEN_MSERVICEOFFICE_IID is not defined"

So the generator name here is right as mServiceOffice is a new table I have just added to the application.

>Do you think it's only VFP version that has changed? It looks like there is something wrong in assumption.

I took your advise and tried to reconfirm it using the previous VFP6 version and you were correct that there may be something wrong in my assumption. Somehow now it does not happen. I am sure I have not changed this code in quite sometime, now why does it break?

On the other hand I have another place where I create new generators if I do not find it, this one is for sequential nos. like Bill No., but nevertheless they are generators of the regluar type we use for PKs. The particular logic still does work. I will have to model this method as per the function for nos.

Thanks for the eye opener and sorry for the trouble.