Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TLeaders

    Indented Bom's to csv or Excel store procedure?

    Sorry I cannot run down the issue, I no longer have the macola data base on my laptop. It is has been 10 years since I used it so I don’t remember the details any more. Having said that I think the most likely issue is that the same item occurs multiple times in the structure. You may find this...
  2. TLeaders

    Help In Adding Start Code and Function Code To UCC-128 Barcode

    AJ You might want to look at: http://en.wikipedia.org/wiki/Code_128 The FNCx codes are used for special purposes. FNC1 at the beginning of a bar code indicates that it begins with a 2- 3- or 4-digit application identifier assigned by the Uniform Code Council, which explains the following...
  3. TLeaders

    Help In Adding Start Code and Function Code To UCC-128 Barcode

    AJ I am not familiar with the intermec printers but this is what I do on zebra printers. When you design the label turn off the text print option. Then add a new text field under the barcode (in place of the auto generated text). So when you print the label send two data fields one that...
  4. TLeaders

    Acucobol printing in the background.

    Hayden I would suggest that you launch the printing process on a different (new) thread. Have you considered compiling the printing process as an EXE, and launch it a an entire separate process? You would lose that "percent complete" information going back to the menu. But it beats thread...
  5. TLeaders

    Default "All" and flex module

    I thought that the "all" was driven by the screen events in the screen set designer. The events should be available from the system manager screen designer. I don't currently have a Macola install available to verify this. Sorry. Good Luck Tom
  6. TLeaders

    Changing unit price in OE to allow items over 10 million

    Jeff I assume that since the 12million is not saving that you are using a 12 million unit price. You are right that will not save. You can set up a unit measure conversion of per 100 th. or per 1000 th. Then enter the order as 12 hundred thousand or 12 thousand depending. Good Luck Tom
  7. TLeaders

    Fujitsu COBOL for Windows vs COBOL for .Net

    MJ Like a lot of projects the answer is “it depends”. WebRabbit is correct if the mainframe you are referring to is an IBM. And If the operating system/version is one they support. And if the number of users is small. Micro focus has run time license fees for each user. If I were going to...
  8. TLeaders

    Several handhelds scanner

    donporter I use the LS2208. It came with a product manual on cd. In the manual there is a bar code for "Always On". I printed the page and scanned it, worked fine. I assume that the LS1908 has something similar or could be downloaded from the Symbol site. Can't help with the HHP. Gook Luck Tom
  9. TLeaders

    Recursion in VB, but what at SQL

    Run Away Run Away Cursors are bad enough, but over Linked Servers .... You are moving from Gook Luck to God Help You.
  10. TLeaders

    Recursion in VB, but what at SQL

    You might whant to look at http://www.tek-tips.com/viewthread.cfm?qid=1234949 This will explode an entire bom and return all the component items. Good luck Tom
  11. TLeaders

    Removing spaces form a Message

    webrabbit I know what you mean. Sometimes you just have to love these new fangeled gadgets. Tom
  12. TLeaders

    Removing spaces form a Message

    I think your making this harder than it is. Tom 000010**PROGRAM1 000020 IDENTIFICATION DIVISION. 000030 PROGRAM-ID. Program1 AS "Debug_Cobol_Applications_General.Program1". 000040 DATA DIVISION. 000050 WORKING-STORAGE SECTION. 000060 01 SUB1 PIC 999 VALUE 1...
  13. TLeaders

    End Item Where Used

    Spucelik If you use the code that Peter referred to and changed the code “b.Comp_Item_no = ITEM” to reference the parent item number instead, the code will go up the find the initial parent item. The problem is that you will still have to enter the item numbers one at a time. This brings us...
  14. TLeaders

    Code128 Number to String ?

    Please post the actual text string that you are trying to convert. Assuming that there are no odd special characters in the string, I would try increasing the field size in Crystal and see if that works. good luck. Tom
  15. TLeaders

    Convert 16-digit GS1-128 to EAN13 with Symbol LS2208

    That should not be too big a problem. The “01” in a GS1-128 says that the bar code is a shipping container. The next “1” I did not research, but I assume that it is a container quantity. The next group of digits “9780894554039” are your item number, with a check digit. Strip off the starting...
  16. TLeaders

    WIP Variance Account

    It has been awhile since I worked on Shop Floor, but this is how I remember the Shop Floor Wip calculations. Average cost. When material and labor are used/issues against a shop order the amount of the transaction updates a bucket call wip. When finished goods are received the average cost...
  17. TLeaders

    Perform Operations with COMP variables

    Also some (most) compilers have problems displaying comp fields. Try moving the data to the comp field and then move it to a 9(8) field. Then display the new non comp field. Tom
  18. TLeaders

    Flattening a BOM

    Peter I posted a function that would accept a parent item and return all the components for all levels of the bill. Changing this function to a stored proc would be a minor change. I don't know crystal well enough to say what would and would not work for you. here is the thread...
  19. TLeaders

    Update Table without Cursors

    maswiew That is a great idea. Join the table to itself. group one, sum the other. I wish I had thought of it. Tonight after work I'll put the logic back to the org project. The code I posted was a stripped down version to show the issue. I'm sure that this concept will work. Thanks Tom
  20. TLeaders

    Update Table without Cursors

    First let me thank everyone for the help in that past I may not post many questions but I learned SQL by reading tek-tips for direction and the looking up the details in BOL. Without the hints I would have been lost. I have a problem that I have been trying to work through for a while. I want...

Part and Inventory Search

Back
Top