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!

Register Log in
  • Congratulations Chriss Miller 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. MichaelHuber

    Closing a single Excel file vs. all files

    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...
  2. MichaelHuber

    Closing a single Excel file vs. all files

    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...
  3. MichaelHuber

    Closing a single Excel file vs. all files

    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...
  4. MichaelHuber

    Closing a single Excel file vs. all files

    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...
  5. MichaelHuber

    Closing a single Excel file vs. all files

    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...
  6. MichaelHuber

    TO_NUMBER for alphanumerics

    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"...
  7. MichaelHuber

    JOIN

    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...
  8. MichaelHuber

    HYYMDS

    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...
  9. MichaelHuber

    SUBTOTAL

    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...
  10. MichaelHuber

    SUBTOTAL

    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...
  11. MichaelHuber

    SUBTOTAL

    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...
  12. MichaelHuber

    Character Substitution Within String

    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...
  13. MichaelHuber

    Dyanamically adjust the positions of the contols.

    ...End If MyOffset = MyOffset + MyHeight End Sub You'll have to assign MyOffset = 0 somewhere in the group component, and assign MyHeight = 15 * OnePoint (or something else that you see fit) in the Start method of the main app. Also, make sure that the components are in the correct order in...
  14. MichaelHuber

    ATODBL Returns 0

    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...
  15. MichaelHuber

    ATODBL Returns 0

    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:' |...
  16. MichaelHuber

    ATODBL Returns 0

    If I'm not mistaken, everything is an alpha to Dialogue Manager. I came up with a solution (thanks to focwizard's call-by-reference comment). &VAR.EVAL is the solution, and here's why: This goes for every language I can think of, and FOCUS seems to follow these general principles. When you...
  17. MichaelHuber

    How to use parameters as variables?

    In a few situations, we had to create multiple parameters that contained the same value. Maybe you can extrapolate a solution for your own situation. We made a parameter called :First in SqlQuerySource1, and one called :Second in SqlQuerySource2. These two parameters need to be hidden...
  18. MichaelHuber

    Field as Column Title

    It sounds like you may want to make that field an ACROSS field. TABLE FILE CAR SUM DEALER_COST BY COUNTRY AS ' ' ACROSS BODYTYPE AS ' ' END Does this help? -Michael
  19. MichaelHuber

    Ampersand in a string literal

    How do I embed an ampersand (&) in a string? For instance: WHERE MY_FIELD EQ 'R&D'; would return the following error: (FOC295) A VALUE IS MISSING FOR: D Apparently, it thinks that &D is a Dialogue Manager variable! Thanks for your insight, Michael
  20. MichaelHuber

    columns titles on each page

    If the users are going to print things out, we've found that PDF is the best format. You have complete control over what the user sees on a printed page. With HTML, it uses a "logical page" to determine where page breaks occur. These logical page breaks don't necessarily correspond...

Part and Inventory Search

Back
Top