Search results

We are bringing on a new DBA to replace the one we lost. We he starts, I will recommend he look into this if he doesn't know about it already. I see. This might come in handy Oh, I didn't know you could do it based on users. Is that easy to setup? I'm not a DBA, so going a little outside...

Thank you. I had to do a lot of reading and playing around to figure out exactly what to do. In my test copy of our database, I enabled client logging and wrote a program to cause the error. It looks pretty accurate. I'll present this to my manager for permission on changing our production...

Would you be able to guide me on enabling client logging? I started logging all the includes and calls to other programs that all happen withing the parent program. It's getting messy. Still no luck on finding this rogue "find".

Would you suggest I try do on error undo, throw: run ar/rpu.p. run ar/rr.p. end. Also, if the error was to occur, would the program return prematurely, or will it continue at the same line the error occurred?

Progress Version = 10.2b Operating System = Linux, RedHat Enterprise We are apparently experiencing a "More than one [table] found with a UNIQUE find" when the program runs. I've checked the source code and the find statement uses "No-Error", so that error should not show up. I've also put...

I didn't see your answer in time, but you're correct. I got a feeling it was that. I went and checked and sure enough, there is a table named "State". So I did reference the current table by doing custs.state I do, I just leave it out when in my sandbox database for quick code testing

This is probably a rookie mistake, but I can't see why it doesn't work. for each custs break by state: if first-of(state) then display state. accumulate discount (sub-total by state). display num name discount (total by state). if last-of(state) then display state ACCUM...

I forget that the value is precompiled. So changing at runtime shouldn't be possible. Thanks

Can scoped variables ever change at run time? Something isn't quite right right this. do v-cnt = 1 to 3: /** master loop **/ case v-cnt: when 1 then &scoped-define STRM s-1. when 2 then &scoped-define STRM s-2. when 3 then &scoped-define STRM s-3. end...

Thank you guys.

I'm just gonna use this as a introduction thread. I am a 23 yr old male. I graduated with an Associates Degree for programming and ended up getting a career immediately following. This is kind of a long and sad story. So you can just skip to TL-DR I recently started a new job as a Progress...

We get the CSV from our customer. I could turn them to a "|" delimiter on my own this way. assign v-data = replace(v-data,'","','"|"') v-data = replace(v-data,','," ") . I'm at the point to say I think I finally got a solution. I was looking at the raw data and the...

Thank you all for the replies. Unfortunately I am maintaining a program that was written a while ago. So adding the temp table would require rewritting a lot of the program. I guess the person who originally created the program didn't realize in the future the gift message column would be...

I got a CSV I am importing using import stream s-in unformatted v-data. Thing is there is a gift_message column where users say stuff like That one column will be read as 4 rows 1: "From: Me 2: To: You 3: 4: I hope you enjoy" I tried Assign v-data = replace(v-data,chr(10),"... ")...

Thanks for the insight.

I got a program, and it exports tracking numbers to a orders spreadsheet. When all is said and done, the travking numbers will be in scientific format. Can I get progress to put them out as normal? Or it this an Excel problem?

It looked like it was working when I go through it in my head. So I went ahead and implemented it. Seems to work great. def var v-x as int no-undo. v-x = length(p-num).. overlay(v-dline,40) = string("000000000000000"). overlay(v-dline,40 + 15 - v-x) = string(p-num). EDIT: Oh, nice, I...

I can't find much in the progress PDFs i have, so I turn to the community. I have a vendor table, each vendor has a unique value for "vendor number". I'm writing a report which contains these numbers. Not every ID is the same length. So I'd like to add leading zeros to them. The vendor ID is...

Alright Thank you. I'll get by using "Form" I think.

I'm learning Progress for my job. I was running one example when I got CREATE WINDOW in character-mode is not supported. (4139) **Unable to set attribute WIDTH on WINDOW widget in the current environment. I'm using Progress v10 on CentOS 5.