| 
	
		| 
		
			|  | 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: 7990
 
 |  
 | 
			
				|   |   |  
				| 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
 
 |  |  |