--- In IBObjects@yahoogroups.com, Aage Johansen <aagjohan@...> wrote:

>
> 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.
>

IB_Monitor segment:

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