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: 686
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: MSN [Bot] and 1 guest

cron
(855) SEEDCODE
support@seedcode.com
Follow us: