Workarounds & APIs Guide

Appeon® PowerServer® 2017

FOR WINDOWS & UNIX & LINUX

DOCUMENT ID: ADC20236-01-0700-01

LAST REVISED: January 29, 2019

Copyright © 2000-2018 by Appeon Limited. All rights reserved.

This publication pertains to Appeon software and to any subsequent release until otherwise indicated in new editions or technical notes. Information in this document is subject to change without notice. The software described herein is furnished under a license agreement, and it may be used or copied only in accordance with the terms of that agreement.

No part of this publication may be reproduced, transmitted, or translated in any form or by any means, electronic, mechanical, manual, optical, or otherwise, without the prior written permission of Appeon Limited.

Appeon, the Appeon logo, Appeon PowerBuilder, Appeon PowerServer, PowerServer, PowerServer Toolkit, AEM, and PowerServer Web Component are trademarks of Appeon Limited.

SAP, Sybase, Adaptive Server Anywhere, SQL Anywhere, Adaptive Server Enterprise, iAnywhere, Sybase Central, and Sybase jConnect for JDBC are trademarks or registered trademarks of SAP and SAP affiliate company.

Java and JDBC are trademarks or registered trademarks of Sun Microsystems, Inc.

All other company and product names used herein may be trademarks or registered trademarks of their respective companies.

Use, duplication, or disclosure by the government is subject to the restrictions set forth in subparagraph (c)(1)(ii) of DFARS 52.227-7013 for the DOD and as set forth in FAR 52.227-19(a)-(d) for civilian agencies.

Appeon Limited, 1/F, Shell Industrial Building, 12 Lee Chung Street, Chai Wan District, Hong Kong.


Table of Contents

Appeon Workarounds PBL Reference
Introduction to Appeon Workarounds
Best practices for calling APIs
General API
AppeonExtFuncs Object
Appeon Client Functions
Client Logs
File Upload and Download
Appeon Labels
Calling EJB Component
Calling .NET/COM server components (.NET only)
Calling Web Service
Appeon Text Controls
Creating Data Source Dynamically
Accessing JSON-format Data
Appeon Resize Object
Mobile Device API
Audio
Appeon Workspace
Barcode
Camera
Connection
Device
GPS
Image
Map
Media
NFC
Notification
Offline
Online Payment
Textchecker
WebView
Appeon Resize PBL Reference
Integrate with Cordova Plugins
Overview
Appeon Cordova PBL (solution 1)
Introduction to Appeon Cordova PBL
eon_cordova_base object
eon_cordova_bluetooth object (Android only)
eon_cordova_bluetoothle object
eon_cordova_contact object
eon_cordova_fingerprint object
eon_cordova_gps object
eon_cordova_orientation object
eon_cordova_vibration object
Cordova plugins (solution 2)
Connecting with AppeonMobile.CordovaPlugin
AppeonMobile.CordovaPlugin object
Accessing the JavaScript object properties/methods
Accessing the JavaScript array
Using callback functions
Code examples
PowerServer open interfaces
PowerServer open interfaces
Overview
getAllClients
getAllSessions
getSessionByID
getSessionCount
getServerVersion
killAllSessions
killSessions
rollbackAllTransactions
Calling PowerServer open interfaces via EJB component
Calling PowerServer open interfaces via .NET component
Calling PowerServer open interfaces via Web service
Workarounds for Unsupported Features
Objects & Controls
External user object
UserObject object
System Objects
System Controls
System Functions
DDE Server functions
FileLength64 function
FileSeek64 function
FileWriteEx function
FromAnsi function
FromUnicode function
Garbage Collection functions
GetLibraryList function
Help functions
HyperLinkToURL function
LibraryDirectory function
PopulateError function
Registry function
Shared Object functions
SignalError function
PowerScript Reference
PowerScript Topics
PowerScript Statements
SQL Statements
PowerScript Events
DataWindow Reference
DataWindow operators
DataWindow Object Properties
DataWindow control
Controls in a DataWindow
Functions of DataStore object
DBParm parameters in Database
ConnectString parameter
FAQ & Workarounds
What files will go to the plugin folder and how to access them
How to generate a PDF file and send it via email
How to make a phone call in the mobile application
How to open Google Map in the mobile application
How to download an image to the mobile device and show it in the application
How to replace the icon that shows in the IE tab or address bar
How to replace Appeon image that displays at the running of applications
How to remove the Internet Explorer menu
How to deploy an Appeon application without PowerServer Toolkit
How to log in the Appeon Web application with single sign-on
How to add headers & footers to a Web application
How to get the user name and password of the operating system
How to modify the storage location of Web application files in PowerServer Toolkit
How to integrate Appeon Web applications with JSP/ASP
Applying Appeon CommandParm and Hyperlink features
Using Internet Explorer Frame
Integration through intermediate n-Tier Server-level solutions
No Workarounds
Index