Jump to content

Click the link below to see the new game I'm developing!

Neil Hunter

Member Since 12 Jun 2001
Offline Last Active Apr 15 2019 10:34 AM

Topics I've Started

Reading xls/xlsx with ExcelWriter SSO

25 March 2019 - 12:10 PM

So i've got the writing thing going, but can't seem to get reading an xlsx file to work


I've tried a combination of setXlsxFilename, openExistingExcelFile, openExistingWorksheet and set CurrentRow.


getCellContent keeps throwing Cannot get content - Column/row not found. Guessing my source file isn't being read or setup correctly


Can someone paste a code snippet of the sequence of opening up a file?

Converting JSON from HTTP SSO Get

08 January 2019 - 05:24 AM

Hi all,


I have a restful web service that I need to pull data from, connects fine with HttpSSO and reads content fine.


Is there a way to convert the returned JSON content into something usable or do I have to do it the long way round? I've been using the @DemoHTTPSSO for reference, and it seems to be doing it the long way



ProIV supplied LDAP SSO

23 July 2018 - 06:53 PM

Anyone using the ProIV LDAP SSO in their organisations?

I seem to have gotten authentication working and mapping to an existing ProIV user. I cant seem to get attributes of said user like email, position, telephone no etc

Setting up Screen modes via code?

31 March 2014 - 06:27 AM

I'm busy with a new request where certain conditions mean users may add, change and delete records within a Paging screen. Under other conditions, they are only allowed to change records. Is the a command like @XCODE available whereby you can set what modes are allowed before entering the cycle? 


My other options are allowing all modes and stopping users based on said conditions with MSG's/UMSG's and FLD jumps or creating a mirror second cycle with the different modes. Both will work but aren't the greatest of solutions 

Connecting to Multiple SQL DB's?

13 February 2014 - 08:47 AM

I can't seem to find a worthwhile answer in the V7 documentation


Our current architecture:


Server A with DB A and DB B (Win 2008 R2 with SQL2008)

Server B with DB Z (Win 2008 R2 with SQL2008)


Is it possible to:


From ProIV on Server A, connect to DB Z whilst still connected to DB A and exchange data between the 2 DB's?

Click the link below to see the new game I'm developing!