Subject | Re: [IBO] IBO-Query / CanInsert ? |
---|---|
Author | Patrick Lenz |
Post date | 2001-03-02T00:30:52Z |
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
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 todefined
> false (it defaults to true). Also ensure that no KeyLinks are
> and that BufferSynroFlags are all turned off.
>
> HTH
>
> Geoff Worboys
> Telesis Computing