Subject Re: [IBO] More EXECUTE BLOCK problems?
Author Helen Borrie
At 02:30 AM 14/12/2007, you wrote:
>On this table:
>
>CREATE TABLE I
>(
> I INTEGER
>);
>
>
>I prepare and run this statement:
>execute block
>as
>begin
> insert into I (i) values (1);
> insert into I (i) values (2);
>end
>
>With AutoKeyLinks = True and get this error message:
>Problem in BindingCursor: Check KeyLinks property


Could you provide some more info, Martijn?

Why would you set KeyLinksAutoDefine true for a DML statement? Is it because you have assigned the statement to the InsertSQL property of a dataset?

If it's a stand-alone statement:

Which statement object are you using? Is the IsSelectSQL property available to it? (should be set False in BeforePrepare).

Do you call Execute or Open to run it?

Helen