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 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 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 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 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 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 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 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 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 06 November 2006]:confused: Hello, everyoneThis question is about the Open-Save dialog box "c$opensave".Is it possible to select more than one file in the open function?Thanks!

[Migrated content. Thread originally posted on 04 December 2006]In thin client is there a way to allow a user to login only one time.We have a problem where most users we want to restrict them from loging into thin client more than one time and 1 or 2 users at each location to be able to log in 2 times to have 2 screens up.Does anyone know how to control this.Thanks

[Migrated content. Thread originally posted on 17 January 2007]I'm just curious, has anyone else noticed that the exit status of the runtime no longer reflects the state of the runtime at the time it exits? In the latest version it reports as the exit status the result of itself or the last internal exit status, such as to a file rename or other call.Brad

[Migrated content. Thread originally posted on 25 January 2007]I want to retrieve the name of the default email client (just the name, I don't want to actually launch it) found in the registry at:HKLM\\Software\\Clients\\MailSo I have the following call:CALL "REG_QUERY_VALUE" USING HKEY_LOCAL_MACHINE, Q-RESULT, Q-RESULT-SIZE, Q-SUBKEY GIVING Q-STATUS.But I think it's trying to bring back every entry under that subkey, because I get a status of 234 which means that the result is too large for Q-RESULT. Is there a way to only get the (Default) data value (i.e. "Outlook Express" in this case)? Or do I have to somehow enumerate the results?

[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 07 November 2006]I've been keep reading about V8.0. Does anyone have any idea what are the major enhancements in the release?Chin

[Migrated content. Thread originally posted on 03 November 2006]Has anyone used or tested this setting, and if so would you share any thoughts or guidance?Years ago we evaluated a system for a huge number of users and identified a performance bottleneck regarding locks performed when a data file is read. This enhancement would address that issue, but we are not on hardware/operating system that has the system tools to monitor the information that we identified at that time, so we have never moved forward with this. Just curious if others have, and how much benefit they have receivied.brad

[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 30 November 2006]Windows Application Development with AcuBench? and ACUCOBOL?-GTHands-On TrainingAcucorp's Office, Twickenham, UK February 5-8, 2007 Led by our team of experienced Systems Engineers, Acucorp's training course provides intensive instruction on a wide variety of extend?7 development and deployment solutions. Held at our Acucorp office in Twickenham, the four-day workshop includes practical tutorials and exercises on Acucorp's ACUCOBOL-GT development system and AcuBench integrated development environment. This hands-on course includes detailed information on AcuBench and ACUCOBOL-GT, the best tools for COBOL Windows development. As an attendee, you will: ? Become productive using AcuBench for all phases of the application development cycle (design, coding, and testing)? Receive an overview of the extend7 components? Receive introductions to project management and configuration, graphical designers, the integrated d

[Migrated content. Thread originally posted on 19 October 2006]We are running THIN Client (release 6.2.0) on LINUX. Our application allows multiple sessions to be accessed of the same application program that has 2 major screens that the user can use ALT/xx keys to switch back and forth between. One of our screens is executed as an event of a button of the other. Our users have been complaining that they see the 2nd screen from one thread in the other thread. While trying to investigate this problem, I noticed that when I click on the windows tasbar icons of one screen, it will, after some clicking back and forth, begin to show the wrong associated threads. Yet when I use ALT/TAB to move between the taskbar icons, it consistantly works fine.(1) Is this a known problem with AcuCobol thin client?(2) Is there any code anyone knows of where i can ensure that the taskbar click is ALWAYS associated with the thread it is supposed to be associated with?

[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 09 November 2006]Hi,OK, we have a program in our application which has the ability to allow a user to click a button using an event procedure, it uses event because I don't want the after procedure to trigger etc.Now, because we make use of multi threading, this button pushing has the potential to allow the user to be in another program, but get back to the start and press the same button again.If upon pressing the button I modify the screen's VISIBLE control to FALSE, then when he eventually realizes that he has to close something down to get back modify it back to TRUE is it likely to cause me any grief.It seems to work a treat, but does the modifying cause lots of network traffic etc?I also do it in another place in the same program which does indeed tidy things up greatly from the users graphical view of what they can see.Thanks,Shaun

[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 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

[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