At 10:18 AM 04-09-02 +0200, you wrote:

>Hi,
>
>When I insert into a Detail dataset, I get the following error:- :"Record
>was not inserted" The procedure below is where the error seems to
>eminate(arrows indicate the exact spot). I am using v4.2E.

Dion,
The likely source of the error is your ambiguous SQL. Because of the
correlated subselects, it isn't sufficient to alias only the subselected
tables, you must alias everything.

Also ensure that the subselected columns are properly marked in
ColumnAttributes as COMPUTED, since the insert may be failing because IBO
can't find those columns in the table's metadata when it compares its
Insert statement with the prepared statement.

regards,
Helen