Search results for query: *

Thanks very much for the tip carp. works like a charm.

I am passing a value based on a value retrieve from another cursor. The cursor where the value is passed to always retrieves the same number of rows, basically it just returns the value from just one variable. For example, cursor cur_prog always displays the first value returned from cursor...

In MS ACCESS, use Asc(Mid(FIELD_NAME,start,length)) In Access, this gives you the Dec ASCII value which you can then lookup. Example my column is called INITIAL, and this record has a valid value in the first space, but invalid in second space. Expr1:Asc(Mid(INITIAL,1,1))...

Did you want the decimal to still be there? If so, you could: 01 sale 9(4)v9(5) comp. 01 sale_moved pic ---9.99999. So 0012.34567 would look like 12.34567.

Thanks for the help. That Microsoft link gave me an idea in PL/SQL where I got this thing to work. Thanks again,

Before I attempt to write a program for this, has anyone ever tried to keep a running balance on a query, and at the same, change the balance fields, for instance: INPUT DATA: NAME AMT ID JOE 125.00 1 JOE 125.00 2 JOE 200.00 A JOE 100.00 B...

Yes, just found that. Thanks again for the help.

OK, the NZ([fieldname],0) was working, I did not realize it because there was too much data and all my null fields are at the bottom. So my null fields display as '0', how do I change the query so that only my null or '0' fields are returned in the query, rather then everything, plus my null...

Thanks, I tried the Right, but apparently had the incorrect format. This worked. Thanks again.

I have a field that I though was Null or empty, but I do not seem to be able to get a return from my table. So far I tried: Len(Trim(Nz(myfield,"")&"")) > 0 Nz(Table1.Field1,'')=''; NZ([fieldname],0) I assume the field has to be either NULL or empty, but why do I not get any returns from...

The Format([Number field], "@@@@@@@@@@") formats everything left justified still. Any other ideas?

Yes, in the query results. Yes, I'll check out the Format([Number field], "@@@@@@@@@@") Thanks

Converting a number to string using Cstr, but everything is left justified. How can I make my converted text right justified? Have not found a way yet, Thanks, in advance,

Thanks. I did not think so, but worth a try.

I know that the 'Reset Dimension' button only takes away your filters, is there a known way to reset the cube all the way back to the default view? So it takes away all the replaced rows/columns and all you have left are the first 2 dimensions (which is my default view)? Thx.

You're absolutely correct flex13. I was using an mdl. Will save it as a pyi file. Thanks again.

Using PowerPlay, and when looking at the Properties of the Signons, I uncheck the 'Prompt for Password' box, save then close. But when open again, the check is back in the box, causes me to put in my password each time I generate a cube. I did not have this problem using a 9i database, but now...

Thanks.

Can you see the script or macro that runs in the background when building or updating a cube or model? Just trying to get an idea for what is happening in the background during a build. thanks,

Thanks. I did put the correct names without spaces ( progra~1) and (Cognos~1), so now yes, it does at least bring up the .pyi. My understanding after reading the Cognos documents what that this would or could refresh my cube? Is this correct, or is this just limited to opening up my .pyi...