I have a set of child records with a common key and a unique sequence.
I want to insert a record and renumber the sequence numbers from the
insertion point to the end of the set.  I call Query.insert, update the
fields of the new record, then increment the sequence numbers from there
to the end, but when I attempt to commit the data I get a "operation not
supported" error.  I am currently using local Interbase.  The table has
no constraints or indexes that might be interferring with the updates.
No problem if I append and only update one record.  What gives?

Bruce

I have just reported a variation of this as a bug to Borland!

What I found was that any time I went to use local parameters in
the sql statment, the statement barfed on the parameter.

This ONLY APPEARS TO HAPPEN on NT 4, Ie 4.01 and possibly
the NT Option pack.  Detail is:

In the Vcl for DBTables, in TQuery.SetParams, there is a statment
       Call(dbiQSetParams) which is returning 10756 (Operation not
supported)

I can run the same program(compiled on NT4) on any version of Win95 -
with or without ie4 - and it will work fine.

Check and see if you can run a "plain" statement of the type
       select * from table where field = 'value'
AND NOT be able to run
      select * from table where field = :valuename
after you have setup the parameters.

I have no solution, but I have the problem.  BDE4.01/4.51 made no
difference,
Video driver made no difference, the 11/97 patch made no difference.