External BAQ - empty fields

Yahoo Archive
1
I had a similar problem with part descriptions, due to some extremely long descriptions that had been cut & paste into Epicor. The fix for me was: select CAST(PartDescription AS VARCHAR(1024)) AS [PartDescription] ...

Epicor 9.05.607B, SQL Server 2008.

Brian.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tanya Denison
Sent: Thursday, November 29, 2012 5:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] External BAQ - empty fields

We are on 9.05.605, SQL Server 2008



I have an external BAQ that I have created, but not all of the data comes across when I run it. I have pared it down to a very simple example.



Create view Test as (select * from part)



When I bring this view into the BAQ Designer, and show all columns, the PartDescription and Character01 (our legacy part ID) fields are empty. I have tried replace() in SQL Server to eliminate any special characters, but it still won't show any text. The view displays correct in SQL Server Management Studio.



I found the unique characters in the first position in the string:

Select distinct substring(partdescription,1,1) from part



Then I did a replace to eliminate any special characters:

Select
replace(replace(replace(replace(SUBSTRING(part.PartDescription,1,1),'.','Q'),'*','Q'),'"','Q'),'
','Q') as [testone] from part



Then selecting from Management Studio gave me a lot of single characters, but displaying in BAQ Designer shows all rows with no value.



Does anyone have any experience with this kind of issue with External Queries?

*Tanya Denison* | IT Manager | NRS, Inc.

*2009 S. Main Street, Moscow, ID 83843*



*tdenison@... *|* www.nrsweb.com*

*c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
We are on 9.05.605, SQL Server 2008



I have an external BAQ that I have created, but not all of the data comes
across when I run it. I have pared it down to a very simple example.



Create view Test as (select * from part)



When I bring this view into the BAQ Designer, and show all columns, the
PartDescription and Character01 (our legacy part ID) fields are empty. I
have tried replace() in SQL Server to eliminate any special characters, but
it still won�t show any text. The view displays correct in SQL Server
Management Studio.



I found the unique characters in the first position in the string:

Select distinct substring(partdescription,1,1) from part



Then I did a replace to eliminate any special characters:

Select
replace(replace(replace(replace(SUBSTRING(part.PartDescription,1,1),'.','Q'),'*','Q'),'"','Q'),'
','Q') as [testone] from part



Then selecting from Management Studio gave me a lot of single characters,
but displaying in BAQ Designer shows all rows with no value.



Does anyone have any experience with this kind of issue with External
Queries?

*Tanya Denison* | IT Manager | NRS, Inc.

*2009 S. Main Street, Moscow, ID 83843*



*tdenison@... *|* www.nrsweb.com*

*c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*


[Non-text portions of this message have been removed]