Search results

  1. LawnyToast

    Table Name Interaction with Syntax

    Hello All! Happy Wednesday! I have an interesting problem to present today. I am sure the collective Openedge ABL brain has encountered it before, and could possibly offer a solution. The ERP I am maintaining is interacting with another software and needs to import from another database via XML...
  2. LawnyToast

    Import XML into Database Table - XML Has Some Multiple Values Per Field

    That worked perfectly. In case someone in the future has these exact questions. This article Here details how to select the different "Extent" of a variable with indexing. export delimiter "," id finish finish_date job length_sched next_op_mach[1] next_op_mach[2] next_op_wc[1] next_op_wc[2]...
  3. LawnyToast

    Import XML into Database Table - XML Has Some Multiple Values Per Field

    I see what you mean. I suppose this would be the perfect case for EXTENT! Thank you very much for referring back to that, and thank you for the quick assist. I will run tests and post results before closing the thread.
  4. LawnyToast

    Import XML into Database Table - XML Has Some Multiple Values Per Field

    Below is the XML. In the fields next_op_mach and next_op_wc. There are multiple values for the one field. I would like to get the fields to append or be added together. Progress seems to just overwrite the data in the field instead of adding to or appending the field. I added extra spacing on...
  5. LawnyToast

    How do I/can I export data like parts into an Excel document?

    This is why you're the G.O.A.T.
  6. LawnyToast

    How do I/can I export data like parts into an Excel document?

    I am not sure what version of OpenEdge you are using, but feel free to reference this URL for syntax clues. Syntax 11.7 Best of luck, LT
  7. LawnyToast

    Resolved Adding Field to an existing Database Table - Procedural Errors

    I fixed the issue. I created the column in the table using this statement: alter table pub."rd-document" add column "owner" varchar(10). This gave me a correct column in the correct format that I was expecting. However, it assigned the character value of the table to <NULL>. In order to fix my...
  8. LawnyToast

    Resolved Adding Field to an existing Database Table - Procedural Errors

    This is my first time altering one of our existing database tables. My predecessor taught me everything I know, and he is no longer working with our company. We briefly touched on the altering of existing database tables, and what I took away from that talk was: Every file that references the...
  9. LawnyToast

    Upgrade Questions 10.2B to 11.6 and OS Migration

    Here is the Referenced Thread. It discusses a DB upgrade with a similar jump. Particularly focusing on the Dump & Load strategy. I will definitely be referencing the thread come crunch time. This article from Progress as well. The concerns are not documented, but I believe they were regarding...
  10. LawnyToast

    Upgrade Questions 10.2B to 11.6 and OS Migration

    I am just going to Dump a lot of information here so bare with me... We are hitting a roadblock with Windows Server come 2020. Our OpenEdge 10.2B DB is hosted on a VM who's OS that is going end of life in January. Our software has been created and curated in 10.2B for 12 years. We own 11.6 but...
  11. LawnyToast

    Temporary Message

    This worked perfectly. Thank you for the help. I took Osborne's advice and used the combined effort. I will now be making the text a little more flashy and distracting to make sure they at least see it. Again, thank you all.
  12. LawnyToast

    Temporary Message

    Hello All, Another minor development question for everyone today... I am wanting to create a pop-up window or message that appears for 5-8 seconds then disappears without any interaction from the user. This window will be opened up by the users actions, but will not require any response or...
  13. LawnyToast

    Variable for Current Month

    Fantastic! You guys are alright! I didn't think about 'case' in this situation. I am learning, and I will take all the advice I can get. You will definitely see me again.
  14. LawnyToast

    Variable for Current Month

    Hello ProgressTalk! This is my first post so I will be brief. I am trying to find the most efficient way to display the current month in string form. Right now I have. iMonth = month(today) cCurrentMonth = if iMonth = 1 then 'January' else if iMonth = 2 then 'February' else if iMonth = 3 then...
Top