We are using PB/SnapDevelop 2019 build 2082 with an Oracle 12 database. I created a datawindow/datastore object with a SELECT that matches the columns and datatypes of an external datawindow and then ported it to the API using the C# Model Generator. Once populated with data in the API, we want to use ShareData() in the client to populate the existing external datawindow.
One of the columns in the select for the new datastore dw is a LONG data type. The new datastore retrieves the column just fine in PB. I can also cut, paste and run the select in the PB database painter and it will return rows. However, when it is retrieved as part of a service method in the API, the column is blank. This seems like a .NET datastore bug to me given that the retrieve works ok in PB but not SnapDevelop. Because the client application does not have any embedded SQL I need to figure out a way in the API to set this column by converting the LONG data into a string. Any thoughts or suggestions on how best to do that?
Thanks, Tom