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
SQLexplorer Important Bug
2 posts
• Page 1 of 1
Posts: 1
Joined: Thu Jul 05, 2012 9:14 am |
|
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! |
|
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 5 guests