I don't have SQL Anywhere installed on my dev machine so I can't confirm this, but I would try different binary types for your db column.  I'd try binary and varbinary to see if those work.  I'd even try image if the other 2 didn't work.  It should be easy to try, just create a table (or additional columns on the existing table) and write the blob to them all, then selectblob from each and see which one works.

KR

Hi Kevin,

thanks for your suggestion. The problem is not with the DB : it's the same engine used in Powerserver and in dev ...

The problem is the blob generated by getfullstate. The size of the is totally different :

When the blob is generated in PB IDE : size = 283185

When the blob is generated in teh app published in Powerserver : size = 12456

Regards,

Philippe.

HI Phillipe;

   Unfortunately, you cannot use DataWindow binaries generated using the Get/Set FullState commands between PowerServer and PowerBuilder as each uses a different technical approach to the generation and reconstitution of the DW binary datum. You can certainly use the Get/Set approach between PB based Apps (but only of the same PB version) and the same for PowerServer based apps (same restriction as PB).

   I would recommend looking at using a different format for exchanging data between these technologies that is not software realm specific.

HTH

Regards ... Chris

That stinks.  What about using a resultset instead of the fullstate blob?

You might want to compress the resultset prior to saving it to the database. Then in the other app you can decompress it before importing into the DataWindow.

I have an example of using the free ZLIB library. The example app highlights zip file handling but you can use the of_compress and of_uncompress functions to work with data in-memory. The of_uncompress function needs to know the original size so it will need to be saved to the table.

http://www.topwizprogramming.com/freecode_zlibwapi.html

Hi Kevin;

      Another great idea - but unfortunately, the ResultSet system object and GenerateResultSet method are unsupported in the PowerServer environment.

     My suggestion would be to just export the DWO's buffer contents directly and then save that into the Blob table. For example:

• Any   la_data[ ]
• la_data =  DC/DS.object.data
• UPDATEBLOB SET = :la_data

     The issue with this approach (or even the GenerateReultSet) vs the Get/Set FullState is that you loose the row & column "state" information. Hopefully, Philippe does not require this in his project.

  Regards ... Chris

  Comment

  

  1. Philippe PILAT
  2. Wednesday, 25 July 2018 14:10 PM UTC

  Chris,
  
  the DW is a composite containing 5 other DW ...
  
  I don't think your solution would work.
  
  
  
  Regards, Philippe.

  1. Helpful Loading... Helpful 0

  

  1. Chris Pollach @Appeon
  2. Wednesday, 25 July 2018 14:16 PM UTC

  You are correct. Neither then would the Get/Set FullState.
  
  
  
  In PB2017R3 though, you will have a JSON Package object where you can package multiple DWO buffers into one JSON data stream. Unfortunately, the JSON Package object will not be in the PS2018 feature set when released later this year. This feature will come in a later PS release.

  1. Helpful Loading... Helpful 0

  There are no comments made yet.
  

  Appeon Support Team Accepted Answer Pending Moderation

  1. Thursday, 26 July 2018 01:25 AM UTC
  2. PowerBuilder
  3. # 7

  Hi Philippe,

  
  1 The blob that was created using GetFullState in PB can’t be used by Appeon if you used standard datawidnow and standard datastore and vice versa.

  2 The blob that was created using GetFullState in PB is compatible with Appeon if you used appeondatawindow and appeondatastore(in appeonworkarounds.pbl), but there is one exception, it won’t work for reports that contain nested reports, which is exactly what you are trying to do.

  We have a customer who successfully work around this kind of issue by using the .net assembly, please give a try to see if it can satisfy your requirement. Below are the details from this customer for your reference (we have uploaded the related document and PB case to the .net assembly folder on our FTP site: ftp.appeon.com (guest/guest)).

  If you need any help please let us know.

  I am using the AppeonDotNetComponent NVO to call server-side DLLs from my Appeon web client, including a DLL created with PowerBuilder Classic from a .NET Assembly target.

  Functions in this DLL running on the Appeon server can connect to the same database as the calling web client. Data can be retrieved, processed, and updated in the database using datastore.

  I’ve included appeon_workarounds.pbl to the Library List of the .NET Assembly target so I can create AppeonDatastore objects. This allows me to retrieve an AppeonDatastore on the server, do a GetFullState, send the blob to the client via a temp table, and then on the client do a SetFullState to an AppeonDataWindow.

  I can also retrieve an AppeonDataWindow on the client, do a GetFullState, send the blob to the server via a temp table, and then on the server do a SetFullState to an AppeonDatastore in the PowerBuilder .NET Assembly DLL.

  However, in order to get this to work I had to make a number of changes to the AppeonDatastore and AppeonService NVOs in appeon_workarounds.pbl. I had to do this because
  • When running as a .NET assembly, some PowerBuilder syntax is not supported.

  • DataWindow objects are not deployed to the .NET assembly DLL. In order to use DataWindows you have to either add a PBL containing them to the DLL’s Library List at run-time, or create them from syntax. You have 4 external DataWindows used when processing GetFullState() and SetFullState(). When running as a .NET assembly I’m now creating these from syntax.

  • When creating a temporary file your function knows how to do this when running as an Appeon Web application and when running as an NVO in EAServer. I added a third option which uses the Windows TEMP directory when running as a .NET assembly.

  
  Regards,
  ZhaoKai

  Comment

  

  1. Philippe PILAT
  2. Thursday, 26 July 2018 06:41 AM UTC

  Hi ZhaoKai,
  
  thanks for your answer and workaround. We have decided to adapt the 'robot' PB app to include all DW's and do the full process (retrieve, create PDF, send mail).
  
  
  
  Regards,
  
  Philippe.

  1. Helpful Loading... Helpful 0

  There are no comments made yet.
  • Page :
  • 1
  
  
  

  There are no replies made for this question yet.
  However, you are not allowed to reply to this question.
  Please login to post a reply

  You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

  Username

  Password

  Remember Me

  Forgot Password?

  Find Questions by Tag

  .EXE .NET 6.0 .NET Assembly .NET Core 3.1 .NET Core Framework .NET DataStore .NET Std Framework 32-bit 64-bit ADO.NET AEM Algorithm Amazon AWS Android Apache API APK App Store App Store (Apple) Appeon Workspace Appeon Xcelerator Plug-in Architecture Array ASE Asynchronous Methods Authentication AutoBuild AutoCompiler Automated Testing Automation AutoScript Azure Barcode Base64 Batch BigData BLOB Branch & Merge Browser Bug Build Button C# C# Class Importer C# Editor C# Model generator Calendar Camera Certificate Chrome Citrix Class Client Client/Server Cloud Cluster Collection COM Command Line Compiler Compression Computed Field Configuration Controls Cookies Cordova Crash Cross-Platform Crosstab CSharpAssembly CSharpObject CSS CSV Cursor Data Database Database Driver Database Painter Database Profile Database Provider DataObject DataSource DataStore DataStore (C#) DataStore (PS) DataType DataWindow DATE DATETIME DB2 Debug Debugger Debugging Deployment Design DLL DO-WHILE Dockable Docker Documentation DOUBLE Download DragDrop Edge Edit Style Editor Elevate Conference Email Embedded SQL Emulator Encoding Encryption Enhancement Request Entity Entity Framework ERP Error Event Event Handler Event Handling Excel Exception Export Expression External Functions F# Field File File Access Filter Firefox Firewall Font FOR-NEXT Foreground Format Function Garbage Collection GeoLocation Git Graph HANA Hash Header HTML/5 HTTP/S HTTPClient Icon IDE Identity IIS IMAPI Import InfoMaker Inheritance Installation Integer IntelliSense Interface Internet Internet Explorer iOS IPA iPad iPhone IWA J# Java JavaScript JBoss JDBC JOIN JSON JSONGenerator JSONParser Kestrel Label Lambda Large File LDAP Library License LINQ Linux OS Load Balancing Localization Localized PBVM Log In Log Out Logging LONG LONGLONG macOS MAPI Maps MDI Memory Memory Leak Menu Merge MessageBox Messagging Method Migration MIME TYPE Mobile Model ModelStore ModelStore (C#) MSOLEDBSQL Multi Threading MVC MySQL n-Tier Namespace NativePDF NVO OAuth ODATA ODBC Office Offline OLE OLEDB Online Open Source OpenAPI OpenSSL Oracle OrcaScript Other Outlook Output Package Parameter Patch PayPal PB Classic PB Native PB.NET PBC PBD PBDOM PBG PBJVM PBL PBNI PBORCA PBVM PBX PDF Performance Permission PFC Picture Pipeline Play Store (Google) Plugin Popup Port POST PostgreSQL PowerBuilder PowerBuilder (Appeon) PowerBuilder (SAP) PowerBuilder Compiler PowerBuilder Runtime PowerClient PowerScript (PS) PowerScript IDE PowerScript Migrator PowerServer PowerServer Mobile PowerServer Toolkit PowerServer Web PowerServerLabel Print Properties Proxy Publish PULL PUSH Query Regression Release Renew Resize Response REST Retrieve RibbonBar RibbonBar Builder Rich Text Roadmap RPC Runtime Packager SaaS Scaffolding Script SDI SDK Security Server Service Session Single Sign-on Size SMTP SMTPClient SnapDevelop SOAP Sort Source Code Speech Recognition SQL SQL Anywhere SQL Server SqlBuilder SqlExecutor SQLite SqlModelMapper Storage Stored Procedure Subscription SVN Swagger Syntax TabbedBar TabbedView Tablet TabPage Target TE Control Testing Text TFS Theme TIME Timer TLS/SSL Tomcat TortoiseGit TortoiseSVN Transaction Transparency Trial Trigger TRY-CATCH TX Control Type UI ULONG UltraLite Uninstall Unit Test Unit Testing UNIX OS Update Upgrade Upload URL User Center User Object UWP Validation VARCHAR Variable Versioning Visual Studio Visual Studio Code VM Voice Warning WCF Web API Web Extensions Web Service WebBrowser WebForms WebLogic WebSphere WildFly WinAPI Window Windows OS WinForms Wizard Workgroup Workspace WPF XCODE XHTML XML Zoom
  We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.

  Got it!Learn more