SeedCode Support Forum

Just decided to give the SQLE file a whirl for my lack of ability to generate FMQL.

There is DEFINITELY a bug when accessing tables with field names with spaces.

Here's the botched, generated code:
SELECT a."SKU", a."Account Number"
FROM "InvTRANSACTIONS" a
WHERE n."Acc" = ?

And here's what it should be:
SELECT a."SKU", a."Account Number"
FROM "InvTRANSACTIONS" a
WHERE a."Account Number" = ?

HTH you guys with what seems to be an otherwise great file!

Cheers,
Denis

Thanks Denis! We've followed the "no spaces" convention here for so long I'm sure we missed that!

I'll take a look and we'll get that fixed!