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] Joining on GUID's
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Joining on GUID's
 Login/Join
 
Silver Member
posted
In my SQL table the primary QUID key contains squirrely brackets {quid...} but the foreign QUID key does not. What's the best way to join them and why does one have them and the other not?

Thanks in advance.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8

Windows, All Outputs
 
Posts: 42 | Location: Phoenix | Registered: March 01, 2018Reply With QuoteReport This Post
Gold member
posted Hide Post
Could you please provide some sample...


WebFOCUS 8
Windows, All Outputs
 
Posts: 54 | Registered: May 26, 2017Reply With QuoteReport This Post
Guru
posted Hide Post
Are you saying that the actual SQL tables some GUIDs have curly braces and some do not?

Or are you saying the WebFOCUS master file/synonym isn't showing them on some tables?

More specifics would help.


Hallway
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 402 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
Silver Member
posted Hide Post
The data in SQL tables do not have the brackets but WF displays the data with brackets for the key fields(A38) but not the foreign keys(A36V).


WebFOCUS 8

Windows, All Outputs
 
Posts: 42 | Location: Phoenix | Registered: March 01, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
quote:
Originally posted by Les J:
The data in SQL tables do not have the brackets but WF displays the data with brackets for the key fields(A38) but not the foreign keys(A36V).


Can you share the master file and sample data ?
Looks very weird for me that WF add brackets...
Maybe they are coming from you master file definition


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2114 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Silver Member
posted Hide Post
Here's a screenshot of both files.


WebFOCUS 8

Windows, All Outputs
 
Posts: 42 | Location: Phoenix | Registered: March 01, 2018Reply With QuoteReport This Post
Silver Member
posted Hide Post
Not sure if I attached the image correctly


WebFOCUS 8

Windows, All Outputs
 
Posts: 42 | Location: Phoenix | Registered: March 01, 2018Reply With QuoteReport This Post
Guru
posted Hide Post
quote:
Originally posted by Les J:
Not sure if I attached the image correctly


You can't upload pictures to the forums #cuzIBI. Frowner

You have to upload them to a file sharing service (something like cloudinary.com) and then us the public link to that picture in the image URL.


Hallway
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 402 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Joining on GUID's

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