Paul,

your assumption was correct, I simply suppressed the -d option on the
gpre command line and it now works like expected.

Many thanks,

Fabrice

> >
> > When trying to pre-process the following file cs.e with gpre, I am
> > getting the following error:
> >
> >
> > "D:\Program Files\Interbase\bin\gpre" -c -n -s 3 -d
> > Controller.gdb cs.e
> > (E) cs.e:59: TABLE MY_TABLE is ambiguous
> > 1 error, no warnings
> >

>
> If you include the SET DATABASE ... COMPILETIME, structure, it

needs

> to be the first EXEC SQL in the module, and then you don't need the
> -d option on the gpre command line.
>
> I think the fact you have both the SET DATABASE and the -d is
> confusing it, because it doesn't realise that they both point the
> same place, and it's telling you it can't figure out which one to
> use.
>
> Paul Schmidt