At 12:01 PM 1/07/2005 +0000, you wrote:

>Sorry for the double post but I am desperate,
>
>I need help badly, I do not understand this problem at all. the error
>is 'Cannot insert a new row' which seems to occur after the database
>is created.

It's not a database error, it's a client-side error. Causes: one or more
of the following:

1) You don't have RequestLive true; or, if you do, it's not an updatable
dataset.
2) If either of the above is true, then you have no InsertSQL defined.
3) You don't have any KeyLinks defined; or, if you do, they are not unique.
4) You have some strange linking in the dataset, e.g. like a mastersource
with no masterlinks defined; or keylinks and masterlinks defined for the
same pair of dependent sets.

>It's created with a sql script which I have been using forever
>I even install FB1.5 server, removed empbedded server, same problem.
>request live is set to true for all iboqueries

RequestLive is for updatable sets. For non-updatable sets, it will become
true if you have defned valid InsertSQL.

>has anyone seen this before

Yes. But it's an off-topic question in Firebird-support. Post a proper
description of the setup in the IBO list.

./heLen