Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Retrieving status of records

  1. Issue
0
Votes
Undo
  1. John Vanleeuwe
    John Vanleeuwe
  2. PowerBuilder
  3. Wednesday, 3 January 2018 13:52 PM UTC

Hi all,

We are using PB2017 with SQL Anywhere database.

At the moment our pb application allows the user to 'demand' a status of a certain record. A txt file is being send to our software with the identification of the record and an action trigger being : retrieve status.

This txt is read by our software and the results (being the status of a certain record) will be output into a txt file which then can be read and processed in an external software.

All this works ok , but i would like to start using more modern solutions.

Does anyone have any idea's ? I am thinking of a sort of rest API on my database or something like that ? Does this exist ? Or ... ?

 

I don't like to give them full access through ODBC on my database....

 

 

Grts

John

  1. ASE
Web Service Call Errors with Method xxxxxxxx can n...
Strange problem with external functions
Responses (2)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 3 January 2018 14:45 PM UTC
  2. PowerBuilder
  3. # 1

It would be dependent on the capabilities of the external software.

PB 2017 R2 will have new JSON/REST abilities. I believe it will be out by the end of this month.

Comment
There are no comments made yet.
David Peace (Powersoft)
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 3 January 2018 16:38 PM UTC
  2. PowerBuilder
  3. # 2

I believe that SQL Anywhere has the capability to host web services. You could create a simple web service and call that from PB.

Alternatively you could write a PB service using Rolands service wrapper and create a TCP/IP listener within that service to receive and send messages to the PB client.

PBNISERV Service wrapper: http://www.topwizprogramming.com/pbniserv.html

TCP/IP winsok code: http://www.topwizprogramming.com/freecode_winsock.html

Both would work fine.

Cheers

David

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