I am in the process of evaluating a move to either Interbase
or SAPdb, clearly leaning towards Interbase if it wasn't
for 1 major issue....

All our code is in ESQL and makes heavy use of:

struct {
int x;
char y(10);
} xs;

EXEC SQL DECLARE c1 CURSOR FOR SELECT * from x;
EXEC SQL OPEN c1;
EXEC SQL FETCH c1 INTO :xs;

It seems "gpre" is unable to expand the structure into
individual values at compile time because I get an
error about column count and host variable count unequal.

Am I missing something here or is "gpre" limited in this way?

Thanks! Tim