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 Sep 09 2020 06:15 PM
-----

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!