Search results for query: *

good idea!! i will give it a try. Thanks, Steve.

i am using them in the child query... i just create the parameter and put this in the initial value of lets call it p_1 rpad(' ', 11) col1, etc.. for each column name. This one would be a varchar2 with name col1. then i use this col1 variable on the layout model. In the program unit i then...

well ya, i am dynamically doing that.... i just create a paramter with an initial value.. ie initial value of p_1 is rpad(' ', 11) columnname, rpad(' ', 5) columnname .... in the query i would say : select &p_1 from table_name where ... and even table can be a parameter too and the where...

i mean the initial value of the parameter starts as: to_char(date_col, 'YYYY-MON') and when the user chooses to see the report yearly and not monthly i change it to : to_char(date_col,'YYYY') is this clear enough ? if not let me know.. Steve.

Hey, I was wondering if a problem i have been having is a bug or if you just cant do what i want to do. Heres the situation... I have a data block, that block is linked to alot of other blocks. I have the column that they are linked on in a parameter which changes depending on what is chosen...

Thanks everyone! I actually ended up using the cut command. Thanks to all for your input. Steve.

I am very new to unix scripting and I have some up against a problem and i cant find any documentation on it. I simply want to substr out part of a string and assign it to another var. Something like this.... set var = substr($another_var,1,3) If anyone could help me out with this i would...

this might work, but the only problem is I wont be the one opening the file. it will be downloaded via the web using php. i will try to figure something out, but thanks alot for your help, it might get me on the right track. Steve.

i am actually running a script that generates RTF code, i need the row to be deleted before the document is opened in word. i was hoping for an rtf command that would delete a row while the script is running.

hi if you know anything about rtf coding i would like to ask if there is a way to delete a row from a table in MS Word using rtf. Thanks Steve.

hi, just wondering if anyone knows how to code RTF. i am having a problem with creating a table in RTF. I need to know how to delete a row in RTF. I dont even know if RTF can do this. If anyone knows how to do this it would be great it you could let me know. Thanks Steve.

why dont you try loading a table with the output data then moving that table to the output line, do the sane with your headings and thats it. i have done this before and it works well for this type of thing. hope it helps. Steve.

hello there, I believe that you cant run microfocus cobol on any versions of windows above 98. I have heard of many people with this problem, the solution: dual boot your computer to a 98 partition, or get a new computer, or install 98 over the other OS'. Other than that there is nothing you...

i have had this error before. It is when you have a index value in your table search out of range of the table itself. You need to check all of your index names making sure you use the right ones at the right time and make sure that if you are moving a value into your index that it is valid and...

Hi i am wondering if anyone knows how to choose what fields that you want to repeat first in a matrix report. i seems to default to the field that is being displayed across the top and not the one down the side(which is the one I want) if anyone knows how to fix this or maybe there is a...

actually you need to have 2 dots before the file extension ie spool c:\schedule\abc&1..dat Steve

hi there if you have existing triggers that are subclassed to the block then you can only add the new trigger to the bottom of the subclassed triggers. this might help.?? Steve

i know you can input a parameter into the sql file that has a date value in it so im pretty sure you can do this. if you try putting a parameter in the filename with a date value this would be the syntax spool c:\schedule\abc&1.dat by default if you dont put a file extension it will make a...

try entering in data in the VB screen and then query it up later in SQL. that is the only way to be sure if the data is being stored properly steve

Peter rides the little yellow bus and so does his mom