Subject Re: [IBO] IBO-Query / CanInsert ?
Author Patrick Lenz
Thanks Geoff,
but it still does not do the insert part :(
Even in SQL editor, it looks like as soon as you select from a
storedprocedure the insertsql is completely ignored ?
Here is what I tried against the employee.gdb with hardcoded
parameters:
(I used a IBOquery off the shelve and set keylinksautodefine to false)

SELECT * FROM DEPT_BUDGET(100) // works fine
INSERT INTO COUNTRY(COUNTRY,CURRENCY) VALUES('AAA','BBB') //does not
work

Patrick

> When using a stored procedure make sure KeyLinksAutoDefine is set to
> false (it defaults to true). Also ensure that no KeyLinks are
defined
> and that BufferSynroFlags are all turned off.
>
> HTH
>
> Geoff Worboys
> Telesis Computing