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     [CLOSED] SQL Passthru code returnin different results
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] SQL Passthru code returnin different results
 Login/Join
 
Gold member
posted
I have embedded SQL in a fex. It is MS SQL Server. When I run the EXACT SQl is a TOAD editor agains the database I get different results than when running it from within FOCUS.

Oddly if I make my connect string UPPERCASE I get the same results as under TOAD.

Had anyone seen this, and know the root cause? I'm concerned that this is just a fluke as we have dozens of FOCUS scripts that run embedded code.

This message has been edited. Last edited by: Kerry,


Laure


Prod: WebFOCUS 7.7.03 - MRE, BID, - WindowsXP - Oracle 9i, SQLServer, DevStudio 7.7.3 - Apache Tomcat , Output: HTML, Excel 2013 and PDF
 
Posts: 78 | Location: Florida | Registered: December 07, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Laure,

The only thing I can suggest is, sometimes, it looks like the SQL is sent directly to the SQL engine (passthru), but instead, WebFOCUS is using the metadata. I would verify the SQL ENGINE connection and also turn SQL traces on - it might shine a light on what's going on. Why post some of your code, including the connection string?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
If your connection string command is failing due to improper case, etc., is the query using a default connection and database instead?


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SQL Passthru code returnin different results

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