Recent content by kaul125

FYI - I tried using a text object in the header band and used the following syntax you suggested in your first reply and it worked fine: dw.Object.<Header-Text>.Text = &quot;<...>&quot; For some reason it's not working with a computed object. Thanks, Keith

I tried this and it still doesn't work. This is what I did. I have a dw where I use the toolbar button to select 'compute'. I point to the area of the datawindow where I want to put this compute object(in the header band). The 'computed object' dialog box appears. In the name field I type the...

I've tried the following syntax: dw.modify(&quot;computedfieldname.expression='&quot; + ls_value + &quot;'&quot; + '&quot;') When I run this and check the return value of the modify() function I get the following error: Lin 1 Column 51: incorrect syntax My computed object(field) is placed in...

I have a compute column on a datawindow in PB6.5. During run time I would like to change the text value of this column(in other words the expresion for the compute column). The expression will just be plain text. Its just a column that will display different text during run time. I've tried the...

I'm using MSSQL Server and PB6.5. I have a window where the user can select multiple criteria and retrieve their results. If I select no criteria and then click my retrieve button. row are returned. Let's say now I want to filter the result set now. I select anyone of my parameters that I know...

As far as I can tell, the datawindow is of SQL Select DataSource and a Tabular Presentation Style. I am using a DDDW as one of the columns in the DW. Will this cause the problem? I am using this function on a datawindow and not a datawindow child. The reason I'm using SaveAsAscii() is because I...

I'm trying to use the dwc.SaveAsAscii() function in PB 6.5. However, it always returns a -1. Also, it creates an empty file. In PB help it just states if an error occurs, the function will return a -1. However, what does this -1 mean? I'm unable to find anywhere what the -1 means. When I use...

Thanks for your help!!! Using - iw_Parent.Event DYNAMIC ue_Filter_DW( ... ) - corrected the problem.

I have a window that I've placed a user object on. This user object has a button on it. The script behind the button looks like: iw_parent.Trigger Event ue_filter_dw(is_parm1, is_parm2) iw_parent is an instance variable that is populated in the contructor event of this user object: iw_parent =...

I have to apologize for this issue. I was not looking closely at my datatypes. I made an assumption that my datatype was of type string and instead it was of type integer. Everything is working fine now. Thanks your input!!!!!

I'm dynamically building a sql statement using PB6.5 by using SQLCA.SyntaxFromSQL(ls_sql,&quot;&quot;,ls_errors) statement. I then issue the dwc.Create(ls_dwsyntax, ls_errors) Everything works fine at this point. It creates the sql fine and after I issue the settransobject and dwc.retrieve()...

When I open a file with FileOpen() in PB6.5 I want to read the last record. FileSeek() has a few parameters that allows for you to start at the end of the file(FromEnd!) and then read back some many characters. However since I don't know how long the last record is, I won't be able to use the...

I would like to append to an existing file using the dwc.SaveAs() function. I'm using PB6.5. Whenever I have an existing file, and I want to use the dwc.SaveAs() function, my file get overwritten after the SaveAs() function is called. How can I have an exisiting file with data and then use the...

Thanks for your reply. However I just figured out what the problem was. My drop down datawindow has 3 fields in the SQL. One field is the argument, the other ones would be the Display value and the Data value. In my datawindow/column that holds the dddw, I had the data column set to the...

I have a window that has two drop down datawindows. One of them is invisible until the user selects a value in the first DDDW. As soon as I select a value in the first dddw, the itemchanged event will then populate the second dddw based on the value selected in the first one. It also will set...