Freehand SQL results

building reports desktopintelligence
1

Below is a copy of a SQL statement that was originally created in business objects and works fine there. When I try to use it with freehand SQL as the data provider it returns everything okay except the ARSystem.dbo.FAB_Incident.Problem_Description, and the ARSystem.dbo.FAB_Incident.Solution_Description only display a “|” sign. Any ideas why this is happening???

SELECT
ARSystem.dbo.FAB_Incident.Incident_ID,
ARSystem.dbo.FAB_Incident.Status,
ARSystem.dbo.FAB_Incident.Call_Begin_Date, ARSystem.dbo.FAB_Incident.End_User_Site, ARSystem.dbo.FAB_Incident.End_User_Name, ARSystem.dbo.FAB_Incident.Assigned_to,
ARSystem.dbo.FAB_Incident.AIS_POC,
ARSystem.dbo.FAB_Incident.Problem_Description, ARSystem.dbo.FAB_Incident.Solution_Description FROM
ARSystem.dbo.FAB_Incident
WHERE
(
ARSystem.dbo.FAB_Incident.AIS IN (‘FS’)
AND ARSystem.dbo.FAB_Incident.Incident_Flag = ‘C’ AND dateadd(second, ARSystem.dbo.FAB_Incident.Call_Begin_Date, ‘Jan 1, 1970’) IS NOT NULL
AND (datediff(day, dateadd(second,
ARSystem.dbo.FAB_Incident.Call_Begin_Date, ‘Jan 1, 1970’), Getdate()) = 1 )
)

Listserv Archives (BOB member since 2002-06-25)

2

Not sure exactly what’s going on but see if anything here helps you find the answer.

Is there something for those 2 fields that is done at the Universe level like a look up or something?

Remember that Freehand SQL isn’t recognized by BOb as being part of the universe. So if anything is special done to those fields, when it was defined in Designer, for the unverse as the DP, it won’t work there.

Also is it constantly returning “|” only in the report portion or in the actual SQL results as well?

If it’s only in the report portion, check the structure of the report to see if there is anything being done for those fields. Since that is a hard return just makes me wonder if something was going on at the report level.

Sorry couldn’t be more help …

Jim Droppa
Source Consulting

–

On Thu, 15 Oct 1998 18:14:01 Michaud, Steven, F TSGT HQ SSG/SWSF wrote:

Below is a copy of a SQL statement that was originally created in business objects and works fine there. When I try to use it with freehand SQL as the data provider it returns everything okay except the ARSystem.dbo.FAB_Incident.Problem_Description, and the ARSystem.dbo.FAB_Incident.Solution_Description only display a “|” sign. Any ideas why this is happening???

SELECT
ARSystem.dbo.FAB_Incident.Incident_ID,
ARSystem.dbo.FAB_Incident.Status,
ARSystem.dbo.FAB_Incident.Call_Begin_Date, ARSystem.dbo.FAB_Incident.End_User_Site, ARSystem.dbo.FAB_Incident.End_User_Name, ARSystem.dbo.FAB_Incident.Assigned_to,
ARSystem.dbo.FAB_Incident.AIS_POC,
ARSystem.dbo.FAB_Incident.Problem_Description, ARSystem.dbo.FAB_Incident.Solution_Description FROM
ARSystem.dbo.FAB_Incident
WHERE
(
ARSystem.dbo.FAB_Incident.AIS IN (‘FS’) AND ARSystem.dbo.FAB_Incident.Incident_Flag = ‘C’
AND dateadd(second,
ARSystem.dbo.FAB_Incident.Call_Begin_Date, ‘Jan 1,1970’) IS NOT NULL
AND (datediff(day, dateadd(second,
ARSystem.dbo.FAB_Incident.Call_Begin_Date, ‘Jan
1, 1970’), Getdate()) = 1 )
)

Free web-based email, Forever, From anywhere! http://www.mailexcite.com

Listserv Archives (BOB member since 2002-06-25)

3

It appears that any freehand SQL that includes a SELECT on a field of “long text” will not return the proper any results for those fields. It will however, return data for other type fields in the same query. . Has anyone managed to successfully run a freehand SQL against long text fields and a 6.5 SQL SERVER database ?

Listserv Archives (BOB member since 2002-06-25)