Recent content by MichaelHuber

HA! So what we have is an Excel MDI that looks exactly the same on the taskbar as the Word SDI!! And if you want them to look like a true MDI on the taskbar, you can check the "Windows in Taskbar" option in either program (even the Word SDI). Wow. It's all making sense now (at least the what...

Thanks for the suggestion, John. I might have to start getting used to that. I figured out a couple workarounds (don't know if they're the best way to do it, though). It turns out that every time you open an Excel sheet, it uses DDE to open the file in the existing Excel instance. I tried...

Geoff, that didn't solve it. "Windows in Taskbar" was already checked in both apps on my machine. I tried unchecking it, and the taskbar boxes combined together (as expected). With the boxes combined, the X in question shut down the entire app (for both Word and Excel). When I rechecked the...

Hmm... I just opened a few Word docs & clicked the extreme upper right X, and only one file closed (not all of them). Does anyone know why mine behaves differently than Geoff's? Can this behavior be applied to Excel as well? Unfortunately, the "prompt for saving changes" doesn't apply. A...

Hello All, This is a pet peeve of mine, and hopefully there's a way to configure it. In Excel 2002, when everything is maximized, there are 2 X's in the upper-right. The inner X closes the active file, and the outer X closes the ENTIRE Excel application. This behavior is different than other...

One of my VARCHAR2 fields contains numerics as well as alphanumerics. I'd like to use TO_NUMBER or a similar function against this field, and treat the alphanums as 0. When I call TO_NUMBER('123'), of course it returns 123. When I call TO_NUMBER('A123'), I get "ORA-01722: invalid number"...

I forget the syntax exactly... you might need to doublecheck a manual to see how to test null values. Try: WHERE blah EQ MISSING; '.' is just what WebFOCUS displays on the output... it's not the real value in the database. You can change this display value by doing something like: SET NODATA...

DT() will also accept slashes in the date. In most of our reports, we have &StartDate and &EndDate that signify a date range. In the WHERE section, we have: WHERE timefield GE DT(&StartDate) AND timefield LT DT(&EndDate); The users can type any of the following without any adverse effects...

As usual, there are many ways to solve a problem. If you include a WHERE TOTAL (even if it's always true), then your EMBASSY_REGION values won't display unless PRINTPLUS is ON. (It's OFF by default). This seems like a more direct approach to your problem... no HOLD files or anything. 8^) SET...

Ahh that's right... I had the ACROSS in the HOLD files, and needed the multi-verb so I wouldn't have INSORT & NEWSORT repeated for each across value. Since I decided the ACROSS could be a BY in the HOLD files, we can take the multi-verb's out completely! Good catch, gizzy! Thanks, Michael ps...

WHEW! ...This one actually WAS pretty fun!! 8^) Basically, I gathered the detailed information in one request, and the subtotal information in another request. I added a NEWSORT field which is just the outer sort with an extra character concatenated to it. I used '{' and '}' because they...

There may be a solution to your problem. I've never done this, but I know it's possible to create your own fuctions with the language of your choice. You could write something in C that does what you need, put it on your WebFOCUS server, then call the function inside your DEFINE FILE. The...

You'll probably need to use the AdjustSize method for each control. I know you can change the height in this method, and I assume you can change the upper position as well. You might need 2 global variables: MyOffset and MyHeight. MyHeight will be the height of each control, if you want to...

kiddpete, Let's call a truce. It's apparent to me that we're both highly intelligent people trying to outdo each other, and it's getting us nowhere fast. I am a firm believer that no single person can know everything about any given topic, and we've seen hints of that in this thread. I thank...

I stand corrected. I wasn't aware that DM accepts non-alphas. Thanks for the info. 8^) Here's more code: DEFINE FUNCTION FN1(MYINPUT/A3) MYLEN/I3 = ARGLEN(3, MYINPUT, 'I3'); MYVAL/D3 = ATODBL(MYINPUT, '03', 'D3'); FN1/A40 = 'MYINPUT:{' | MYINPUT | '} MYLEN:' | EDIT(MYLEN) | ' MYVAL:' |...