Subject | [IBO] Re: CURRENT_USER Failure |
---|---|
Author | george.elton197 |
Post date | 2008-12-17T15:40:56Z |
--- In IBObjects@yahoogroups.com, Aage Johansen <aagjohan@...> wrote:
DELETE FROM REPORT_RESULTS WHERE OWNER = CURRENT_USER
FIELDS = [ Version 1 SQLd 6 SQLn 30
STAFF_CORE.COMPOSITE_NAME = <NIL>
STAFF_CORE.SURNAME = <NIL>
STAFF_CORE.MIDDLE_NAME[MIDDLE_NAME] = <NIL>
STAFF_CORE.FIRST_NAME[FIRST_NAME] = <NIL>
STAFF_CORE.GRADE = <NIL>
STAFF_CORE.BASIS = <NIL> ]
SECONDS = 0.016
ERRCODE = 335544569
----*//*---
I have no idea why a segment of the STAFF_CORE table is referenced.
REPORT_RESULTS table has no triggers or dependencies. All I am doing
is preparing a table to accept data ready to display a report. Only
the 'CURRENT_USER' data needs to be involved.
Beginning to think something fundamental is wrong, nothing to do with
CURRENT_USER. Any thoughts much appreciated.
George
>IB_Monitor segment:
> george.elton197 wrote:
> >> ...
> > ...
> >
> > ... If I remove CURRENT_USER from the SQL select it works
> > fine (well, apart from returning what I don't need).
> >
>
> Can we see (the full SQL of) one of those queries?
>
> Also, see if this one works:
> select CURRENT_USER
> from RDB$DATABASE
>
>
> --
> Aage J.
>
DELETE FROM REPORT_RESULTS WHERE OWNER = CURRENT_USER
FIELDS = [ Version 1 SQLd 6 SQLn 30
STAFF_CORE.COMPOSITE_NAME = <NIL>
STAFF_CORE.SURNAME = <NIL>
STAFF_CORE.MIDDLE_NAME[MIDDLE_NAME] = <NIL>
STAFF_CORE.FIRST_NAME[FIRST_NAME] = <NIL>
STAFF_CORE.GRADE = <NIL>
STAFF_CORE.BASIS = <NIL> ]
SECONDS = 0.016
ERRCODE = 335544569
----*//*---
I have no idea why a segment of the STAFF_CORE table is referenced.
REPORT_RESULTS table has no triggers or dependencies. All I am doing
is preparing a table to accept data ready to display a report. Only
the 'CURRENT_USER' data needs to be involved.
Beginning to think something fundamental is wrong, nothing to do with
CURRENT_USER. Any thoughts much appreciated.
George