Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]@ Sign When Referencing SQL Script
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]@ Sign When Referencing SQL Script
 Login/Join
 
Gold member
posted
Hello,

For whatever reason when I reference certain fields via compute, the result comes out as "@SUM#112_PAIDAMT" if I just try to reference the field "PAIDAMT". Can anyone advise why the @ sign and all those weird characters display before the field I want to reference?

I'm doing:

TABLE FILE _ADM_STAR
SUM 
	PAIDAMT
ON TABLE HOLD AS 'HOLD' FORMAT SQL_SCRIPT
END 

This message has been edited. Last edited by: Brandon Andrathy,


WebFOCUS 8204
 
Posts: 70 | Registered: July 10, 2018Reply With QuoteReport This Post
Gold member
posted Hide Post
never mind, I realized you need to reference the entire field name in these kinds of circumstances


WebFOCUS 8204
 
Posts: 70 | Registered: July 10, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]@ Sign When Referencing SQL Script

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.