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).