Search results for query: *

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

OK, this is what is happening on my end. I'm using PB 6.5 and the datawindow is of type RichText Presentation style. When I created the datawindow, all fields in the sql are displayed in the datawindow. So, if I export the object then the visible property is set to &quot;1&quot;. In my code...

I'm trying to modify the visible property of my column in my code. However, it doesn't seem to be working. Here is my syntax: dwo.modify(&quot;col_1.visible=1&quot;) Is there different syntax for a RichText Datawindow? Because that is the type of the datawindow I'm using.

I have a richtext dw obect and I want to conditionally display a field when the query is ran. I have two fields where one field is a yes/no type field and another field I want to conditionally display base on the value of the yes/no field. For example if field_1 is a yes/no type field and it is...

I have an external datasource window with one of the columns defined as a string with a length of 11. I'm also using an edit style of editmask - ###-##-####. When I do a getitemstring on this column it always returns a null. However if I change the style to just 'edit', getitemstring returns...

Thanks. I did a cast() function to convert it to a varchar and it eliminated this error. However, I get another error: &quot;select error: Data-conversion resulted in overflow&quot; Do you have any idea what this means and how to correct this? Since this datawindow is used as a report for the...