Rocket® COBOL

[Migrated content. Thread originally posted on 09 March 2007]HelloI am running version 6.2 with AcuSQL. I am running a thread in a program that pulls records from a SQL Server table using the following code: EXEC SQL DECLARE COBCURDW CURSOR FOR SELECT COUNT(HDL_PK) FROM VW_TBL_HANDLERDAILY_WITH_NAMES_FARM WITH (NOLOCK) WHERE FARM = :SEL-FARM-NUM AND MMYYYY = :SEL-MMYYYY AND HMMYYYY = :SEL-MMYYYY FOR READ ONLY END-EXEC EXEC SQL OPEN COBCURDW END-EXEC EXEC SQL FETCH COBCURDW INTO :WS-Count-Weights END-EXEC EXEC SQL CLOSE COBCURDW END-EXECOnce this thread is running I cannot seem to stop it programmatically or switch to another thread until the SQL search has completed. Is there any way to stop or interrupt an SQL search or pass a control break to SQL Server?

[Migrated content. Thread originally posted on 11 April 2007]I am exporting data to Excel using the Application, Workbook, Worksheet and Range objects. I was able to set the Header and Footers for the current version of Excel(2003) that I have on my computer. The code that I am using isMODIFY EX-WORKSHEET @PageSetup::LeftHeader = GUI-HEADER-TITLE.MODIFY EX-WORKSHEET @PageSetup::LeftFooter = FOOTER-DATE.MODIFY EX-WORKSHEET @PageSetup::CenterFooter = PROJECT-NAME.MODIFY EX-WORKSHEET @PageSetup::RightFooter = %P.So currently when I do the export to Excel and print the Excel spreadsheet, it will print the header and footers correctly.Now I just tested this on Excel 2007 and I get an error when my program hits the above code and will not continue with the export to Excel. According to the online documentation on the MSDN website about Excel 2007, the PageSetup property is part of the Worksheet Object, so I am not sure why I am getting an error? Error I am gettting is "Unable to set

[Migrated content. Thread originally posted on 15 March 2007]We loaded our application on Windows Vista and it is not able to create files in the root directory. Does anybody know if there is a setting in Windows that controls this? We have made sure that the user has full permissions in the root directory. We can create Folders in the root, just not files. Even if we try to create a shortcut in the root directory, windows says we do not have permission to do so.This problem came up because our application creates a lock file in the root directory to prevent more than one instance of the application running on a single PC. I know that we could make a code change to use a sub directory for the lock file, but we were hoping we would be able to get around doing that.Anybody have any ideas on changing Windows to allow for file creation in the root directory?

[Migrated content. Thread originally posted on 08 March 2007]Hello Everyone, has anyone experienced some Flowchart ActiveX/.Net Component/Java Component with Acu?TIA Giovanni.

[Migrated content. Thread originally posted on 28 February 2007]quisiera saber si han habido algunos cambios en lo que se refiere a la impresion desde un punto remoto como si fuera local.gracias

[Migrated content. Thread originally posted on 07 March 2007]Hello,i have a little problem with the Web-Browser control.I created a programm with only a web-browser control - all works fine... the only problem i have is that the focused buttons in the web-page aren't terminated when the enter key is pressed.The programm recive that enter is pressed but not the web-browser control, have i any chance to forward the enter-key to the browser-control?I tested a little bit to change the keystroke for the enter-key but no success :(David

[Migrated content. Thread originally posted on 23 April 2007]Instructor-led Training AcuConnect? Thin Client Acucorp's Office, Twickenham June 12, 2007 Led by our team of experienced systems engineers, Acucorp's instructor-led courses provide intensive training on a wide variety of extend?7 development and deployment solutions. Held at Acucorp's office in Twickenham, the one-day workshop include practical tutorials and exercises.This course offers a comprehensive look at AcuConnect, Acucorp?s versatile remote COBOL listener, running in Thin Client mode. It includes:Installing and set-up on server and client machines Configuration and administration of AcuConnect Troubleshooting Thin Client connectionsSet-up, configuration and use of the Auto Update featureProgramming best practices for developing applications that work effectively within a Thin Client environment Please contact your Sales Professional to register or for more information at 44 (0) 20.8843.7100.

[Migrated content. Thread originally posted on 15 February 2007]One of my customers wants to secure all communications using digital certificates utilizing encrypted IPsec traffic.Does anyone know if this will impact the use of Acuconnect? thanks!

[Migrated content. Thread originally posted on 01 March 2007]I am trying to setup a website that interactes with the ERP data files in real time. The only way I see possible is if I connect a Microsoft SQL Server to to the ERP system via AcuODBC. Can I setup SQL Server as a client to the ERP's ODBC datasource. If I can, I can build the website around the MS SQL Server and perform queries on the SQL server to read and write data to it. This should result in the data being written back the ERP system. Is this understand correct? I would appreciate any help. Thanks in advance.

[Migrated content. Thread originally posted on 28 June 2007]Hello, Is it possible to control the size of the print preview? I have a routine that displays two print previews, one after the other. The first one is the size of the display screen that calls the preview. When the first preview is closed, the second one displays as a small box on the top right corner of the crt. Why is it not the same size as the first preview? Can I programmatically control the size of the preview?Thanks!!:confused:

[Migrated content. Thread originally posted on 20 April 2007]I have written an AcuCobol 7.2 program that uses Acu4GL for ODBC to extract daily transactions that are stored in a Pervasive SQL 2000 database on a Windows 2003 server. The program works fine, accessing the appropriate table and reading the records (rows). The problem is that it is incredibly slow!The process takes more than 2.5 hours to sequentially read 12,000 transactions in a test environment. Once in production, the daily transaction count will be 75,000 transactions across several company databases. Obviously, I need a different approach.I don't know if I should continue to search for a solution within AcuCobol or perform some sort of utility operation outside of AcuCobol. My preference is to use AcuCobol because all the criteria that defines which records should be extracted from the Pervasive databases are defined by information stored in Vision files. Additionally, the supplier of the software using the Pervasi

[Migrated content. Thread originally posted on 28 June 2007]Hi,When upgrading from Acu 5.2 to 7.2 and glibc 2.2 to glibc 2.3 (RHEL2 to RHEL4), some of our users are getting these errors:-*** glibc detected *** double free or corruption*** glibc detected *** free() : invalid next size(fast)Has anyone seen (or hopefully resolved) these errors before?We thought we had resolved it on one site by recompiling their object using version 7.2 compiler, but it didn't help with the other site that is exhibiting the same behaviour. The old object works fine on the old run-time. It doesn't happen in all programs, but it is repeatable in those that do exhibit the error.I've sent the issue to tech-support, so this is a general query to see if anyone else has come across it before.Thanks,Ian

[Migrated content. Thread originally posted on 09 November 2006]Hello,does anybody have any experience with creating a menu with ActiveX that looks more Office2000 / 2003 / XP like ?Thanks in advance :D Steen

[Migrated content. Thread originally posted on 05 October 2006]Hi, I am currently working on a project which requirest crystal com automation from acucobol. As part of this project I need to pass a variant array to a COM component. I used c$setvariant to create array and working fine with standalone pc. When I want to run this program on Linux acuconnect server c$servariant not working and from the documentation I found that it is not supported in thin client environment. Can anyone provide me some details on alternate approach.Here is my sample program. 01 WS-ROW. 05 WS-ROW-ARRAY OCCURS 10 TIMES . 10 WS-FLD-ARRAY OCCURS 3 TIMES. 15 WS-FLD USAGE HANDLE OF VARIANT. PERFORM VARYING SUB-SX FROM 1 BY 1 UNTIL SUB-SX > 10 MOVE SPACES TO WS-STR STRING "ID_" SUB-SX DELIMITED BY SIZE INTO WS-STR END-STRING CALL &quo

[Migrated content. Thread originally posted on 13 December 2006]Se questa ? la vostra prima visita, vi invitiamo a consultare le Frequently Asked Questions (in inglese) cliccando in alto a questa pagina sul link ?f.a.q.?. Per poter pubblicare messaggi sul forum ? necessario prima registrarsi cliccando in alto sul link ?register?. Per accedere ai messaggi, selezionate dalla lista seguente il forum a cui volete partecipare:? Generale? Interoperabilit? tra linguaggi ? Programmazione grafica/ActiveX? Linux e UNIX? Funzionalit? potenziate in extendVi aspettiamo numerosi!

[Migrated content. Thread originally posted on 15 December 2006]Hi I want to know how many users opened a .dat file programatically? In other way how to know whether a.dat file is opened by any other user or not.Please help me

[Migrated content. Thread originally posted on 16 November 2006]On Rebuilding a file, I sometimes get the message : xx broken records (xx= number). these records are then lost.Can someone explain to me how you get broken records? and what I can do to prevent this from happening?Marelize:confused:

[Migrated content. Thread originally posted on 15 November 2006]In moving our application from 6.2 to 7.2 I'm getting a sortfile 3002 error and 'Can't make temp file' on our reports that use temp files and sort. I'm using AcuThin and my sort_dir and temp_dir are both set to ./What change in 7.2 am I missing that might cause this? The server is unix and the client is on windows.

[Migrated content. Thread originally posted on 12 October 2006]I have a issue using richtext box methodsall file are only seen and placed in the local bin directoryI need to find what the path that thin client uses to execute the application in which case I can then string it all togetherin order to place rtf files on server.:(

[Migrated content. Thread originally posted on 27 January 2007]We have a program that allows us to send emails using msmapi32. We are attempting to add the ability for a user to select email addresses from their address book. MODIFY MYMESSAGE @SHOW().The first time this method is used, it works fine! However, subsequent attempts do nothing. Has anyone had success with the SHOW method? I have attached the entire program.Thanks if you can provide any hints or links!

[Migrated content. Thread originally posted on 06 November 2006]I need to know if there is a simple way to get the run time to read/write the VLI in reverse order. We have several systems that we interface to that we need to create variable length data files for and they require the VLI to be in the opposite order that ACU puts them in.I have already contacted Tech support with this question and they say there is no way of doing that.

[Migrated content. Thread originally posted on 22 January 2007]Has anyone ever found a way to correctly handle paged list box with a DUPLICATE KEY. The code examples work fine when the key is unique (primary key, etc). However, if the secondary key is a duplicate and there are indeed duplicate records in the file (many of them), the recommended code acts erratically.I am beginning to think the best solution is to remake the file and eliminate the duplicate key by appending the primary key. That, of course, will require a file conversion, which postpones the fix to our next general release.Thanks,Larry

[Migrated content. Thread originally posted on 12 February 2007]Can someone please help me translate the next macro to create 2 lines in excel.Thanks. ActiveSheet.Shapes.AddLine(275.25, 124.5, 275.25, 282.75).Select Selection.ShapeRange.Line.EndArrowheadStyle = msoArrowheadTriangle Selection.ShapeRange.Line.EndArrowheadLength = msoArrowheadLengthMedium Selection.ShapeRange.Line.EndArrowheadWidth = msoArrowheadWidthMedium Selection.ShapeRange.Flip msoFlipVertical ActiveSheet.Shapes.AddLine(275.25, 281.25, 375#, 281.25).Select Selection.ShapeRange.Line.EndArrowheadStyle = msoArrowheadTriangle Selection.ShapeRange.Line.EndArrowheadLength = msoArrowheadLengthMedium Selection.ShapeRange.Line.EndArrowheadWidth = msoArrowheadWidthMedium

[Migrated content. Thread originally posted on 08 February 2007]Has anyone been able to successfully embed a Bulk Collect PL/SQL statement into an AcuCobol-GT program? This code generates a precompiler error:Working Storage: EXEC SQL BEGIN DECLARE SECTION END-EXEC. 01 ARRAY-GROUP-LEVEL-NAME. 02 ACCT-NO-ROW OCCURS 10. 03 ACCT-NO PIC X(10). EXEC SQL END DECLARE SECTION END-EXEC.Procedure: exec sql execute BEGIN SELECT ACCT_NO BULK COLLECT INTO :ARRAY-GROUP-LEVEL-NAME FROM ABC-TABLE WHERE AR_APN = :DB-SEARCH-ITEM END; end-exec;Error: PCB-S-00204, Group item ARRAY-GROUP-LEVEL-NAME cannot be used except in INTO or VALUES clauseIf I use the item level variable ACCT-NO it gives me a different error saying to use a GROUP item.I've written and rewritten this a hundred times trying everything.Anyo

[Migrated content. Thread originally posted on 20 January 2007]I want to change the shape of the mouse while I am dragging whithin a grid.I tried using "W$MOUSE USING SET-MOUSE-SHAPE, WAIT POINTER" at the start (MSG-BEGIN-DRAG) and also while dragging (MSG-GOTO-CELL-DRAG) but it doesn't change (of it changes and gets reset immediately after).I also added ALLOW-LEFT-DOWN and ALLOW-MOUSE-MOVE to MOUSE-FLAGS but nothing seems to work.Is there a way around this because I think this is controlled at low level.Andre