Skip to Content
0
Former Member
Mar 03, 2009 at 07:03 PM

Rows missing when executing query

75 Views

Hi All,

I hope someone can help and that I can explain the issue clearly. I am trying do some integration between SBO and our Time Management system using VB.NET 2008. I need to obtain a list of projects from a table named @SUBPROJ which is located within our SBO database. This tabel is a user defined table, as far as I am aware, that our SAP consultants created.

If I execute the following query, "SELECT * FROM [@SUBPROJ]" using the query generator, all the rows are returned as desired, however if I run a similar query through SQL Server Management Studio ("SELECT * FROM [sfengine].[dbo].[@SUBPROJ]) there are nearly 200 rows missing.

I am remotely accessing the database using SQL Server 2008 Express (Management Studio)

The [@SUBPROJ] table contains a list of all projects and [sfengine] is the name of our SAP database. The correct list of rows is only showing when accessed through the SBO application under User-Defined Windows.

I hope someone can offer a few ideas?

Thanks in advance,

Declan

SQL Server 2005 Enterprise (8.00.760)

SAP Business One 2007 A (8.00.178) SP: 00 PL: 42