Jump to content

Neil Hunter

Member Since 12 Jun 2001
Offline Last Active Mar 06 2018 06:07 AM

Topics I've Started

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?

Office docs (xlsx,docx) to OpenXML to P4?

21 May 2012 - 05:17 AM

Anyone tried this now that MS Office 2007 documents are essentially open source? So writing to or importing from an existing xlsx

Select All/Deselect All on a Paging section

20 May 2011 - 09:36 AM

I've been messing around with an idea, but i'm not getting a result that I like. Anyone got any other ideas?

Update 1
Build Temp file
Update 2
Mark as All selected
Update 3
Mark as None selected
Header section LS1 with a partial description, calling Update 1 to build a MKY file based on partial description and call LS2 using a WHILE loop. Paging Cycle LS2 is where users can select categories they want to view by checking or unchecking a checkbox. Iconsare used to call the other update cycles and LS2 gets executed

This methodology works but is cumbersome coding wise (if only REFRESH-PAGE worked anywhere ). This is on

Oracle Number help!

29 September 2008 - 11:53 AM

Long time no post...

Busy trying to interface to an Oracle ERP system using their table layout. Only problem is Number fields are not defined or are taking the default value.

Question is, how do I define this on the ProIV side? From reading some old posts, some suggest using ORANUM with storage of S20.20?

I keep getting ORA-01458: invalid length inside variable character string. So I gather storage is incorrect?