SQLexplorer Important Bug

General support questions.
Posts: 1
Joined: Thu Jul 05, 2012 9:14 am
PostPosted: Thu Jul 05, 2012 9:21 am
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
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Thu Jul 05, 2012 10:54 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!

Return to General Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: