Page 1 of 1

SQLexplorer Important Bug

PostPosted: Thu Jul 05, 2012 9:21 am
by dsomar
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

Re: SQLexplorer Important Bug

PostPosted: Thu Jul 05, 2012 10:54 am
by JasonYoung
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!