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
August 02, 2019, 12:54 PM
NewBee...WF8
Could you please provide some sample...
WebFOCUS 8 Windows, All Outputs
August 02, 2019, 05:59 PM
Hallway
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
Prod: 8202M1
Test: 8202M4
Repository:
OS:
Outputs:
August 02, 2019, 06:17 PM
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).
WebFOCUS 8
Windows, All Outputs
August 05, 2019, 07:24 AM
MartinY
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.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
August 05, 2019, 10:36 AM
Les J
Here's a screenshot of both files.
WebFOCUS 8
Windows, All Outputs
August 05, 2019, 10:37 AM
Les J
Not sure if I attached the image correctly
WebFOCUS 8
Windows, All Outputs
August 05, 2019, 01:04 PM
Hallway
quote:
Originally posted by Les J: Not sure if I attached the image correctly
You can't upload pictures to the forums #cuzIBI.
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.