Search results for query: *

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

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

Can anyone explain these results? When I pass a short string to a function expecting a long string, then try ATODBL on the string, it returns 0! Here's some sample code: DEFINE FUNCTION FN1(MYINPUT/A3) MYLEN/I3 = ARGLEN(3, MYINPUT, 'I3'); MYVAL/D3 = ATODBL(MYINPUT, '03', 'D3'); FN1/A40 =...

Has anyone created & used report templates? I'm using WebFOCUS 5.2, which claims to support templates, but it doesn't seem to work as it should. Dev Studio comes with TABLE1.FTP and TABLE2.FTP, but changing the template name under Window->Options->Reporting has NO effect on the reports I...