Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data Retrieval Shortfall

I've contracted my development application and database out to a developer to do some extraneous work.  However, when testing the application in the developer's environment, datastore retrievals and embedded SQL do not return all the data - it's as if the SQL is only retrieving a small sub-set of data.

I've used Team Viewer to test the retrieved data in the developer's environment.  What SQL works fine in PowerBuilder's ISQL will only return a subset in the application. 

For example, a retrieve in ISQL using SQL code copied from a datastore returned an expected 112 rows but only 12 via the datastore when debugging the application.  Doing a SELECT MAX(id) in imbedded SQL returned 12 whereas the code in ISQL retuned a correct 668.   Embedded SQL used to retrieve string values returned NULL although the values sought were towards the end of the tables - that's if the SQL only searched early rows of the table.

Neither I nor the developer have encountered such a problem.  We're both using PB 12.5.2, Windows 8.1, and MS SQLServer - version 2008 in my case (not sure of the developer's version).

Not what you were looking for? View more on this topic or Ask a question