 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
birgerii
Joined: 21 Feb 2007 Posts: 29
|
|
SQL Syntax Checker points out wrong line |
|
The SQL Syntax Checker underlines the wrong error.
SC underlines the blue part, but that line is OK, the error is found in the red part, by the last LEFT JOIN.
I'm using version 5.2.59.
SELECT pk_orr_kostnadsrader_id = COALESCE(ok.pk_orr_kostnadsrader_id, 0)
, o.orderid
, levsattkod = COALESCE(f.levsattid, o.levsattkod, '')
, levsatttext = COALESCE(ls.anmarkning,
CASE
WHEN o.levsatttext = '' THEN o.levsattkod COLLATE FINNISH_SWEDISH_CS_AS
ELSE o.levsatttext
END)
, godsmarke = COALESCE(f.godsmarke, '')
, levvillkorkod = COALESCE(fo.levvillkorid COLLATE FINNISH_SWEDISH_CS_AS, o.levvillkorkod, '')
, levvillkortext = COALESCE(xv.anmarkning,
CASE
WHEN o.levvillkortext = '' THEN o.levvillkorkod COLLATE FINNISH_SWEDISH_CS_AS
ELSE o.levvillkortext
END)
, ok.kostnadsartikel
, artikelbeskrivning = COALESCE(a.beskrivning, '')
, ok.antal Antal
, ok.pris Pris
FROM ph ph
INNER JOIN (SELECT pr.ph
, pr.gruppnr
, pr.orderid
, max(COALESCE(pr.fsid, 0)) fsid
FROM pr
WHERE pr.ph = @ph
AND pr.gruppnr = @gruppnr
GROUP BY pr.ph
, pr.gruppnr
, pr.orderid) s_pr ON
ph.ph = s_pr.ph
INNER JOIN oh o ON
s_pr.orderid = o.orderid
LEFT JOIN orr_kostnadsrader ok ON
o.orderid = ok.orderid
LEFT JOIN ar a ON
ok.kostnadsartikel = a.artnr
LEFT JOIN x_frakt_ls xl ON
o.levsattkod = xl.leveranssatt_kod
LEFT JOIN x_frakt_lv xlv ON
o.levvillkorkod = xlv.leveransvillkor_kod
LEFT JOIN fs f ON
s_pr.fsid = f.fsid
LEFT JOIN fs_oh fo ON
f.bolagid = fo.bolagid
AND f.fsid = fo.fsid
AND o.orderid = fo.orderid
LEFT JOIN x_ls ls ON
f.levsattid = ls.levsatt
LEFT JOIN x_lv xv ON
f.levvillkorid = xv.levvillkor COLLATE FINNISH_SWEDISH_CS_AS
WHERE ph.ph = @ph
AND s_pr.gruppnr = @gruppnr
ORDER BY o.orderid
, ok.kostnadsartikel
|
|
Fri Aug 12, 2011 2:12 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
The error is returned by the database server engine, not by SQL Assistant. The database error message is not very specific. It simply indicates that there is an issue with levvillkorid and no specific line number is provided. SQL Assistant finds the first reference to that text and highlights it. That is by design.
|
|
Fri Aug 12, 2011 10:39 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|