> is a common situation?
> If it is, then maybe IBO should favor the development of
> such a thing as easy as possible.

It is common, but most commonly (it seems) people can simply use IBOs
automatic building of insert/update etc from the select statement
provided in the SQL property. In these instances everything works as
expected - at least for me. AFAICT the problem only applies when
specific edit/insert sql must be supplied in order to create a live
query.

It may be possible to setup so that, when a prepare is done on the
specific insert/edit sql from within the CanEdit/CanInsert, IBO could
automatically catch the particular exception and return false.

The problem with this approach is its inefficiency. CanEdit/CanInsert
etc tend to get call quite frequently. Because the prepare would
never succeed, these calls would experience the overhead of trying to
prepare the statements on every call. I guess a system of flags could
be setup to prevent this inefficiency - maybe Jason would consider
such an update for IBO4.1 :-)

Geoff Worboys
Telesis Computing