Search results for query: *

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

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

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'm dynamically building a sql statement using PB6.5 by using SQLCA.SyntaxFromSQL(ls_sql,"",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...

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

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

I'm using MS SQL Server 7 with PB 6.5 and I'm getting the following error when retrieving my datawindow: Select error: The text, ntext or image data type cannot be selected as DISTINCT. Ond of the fields in the dw is of 'text' datatype. My datawindow has multiple select statements using...

I'm using 'union' as part of some of my querys for my datawindows and I'm getting the following error when I run the datawindow? datawindow error: select error; data-conversion resulting in overflow My database is MS SQL Server 7 and I'm using PB 6.5. It seems to me that when the first query...

Someone posed a question to me regarding including icon and bitmap files with the compiled application. The question was, how do I include icon files and bitmap files in my compiled app. where I don't need to ship those files to the client. I'm trying to eliminate the number of files I ship to...

I'm executing an embedded sql statement within my PB6.5 code and the transaction object returns the following: sqlca.sqlnrows = -11 sqlcode and sqldbcode both = 0 and sqlerrtext = ""(empty string) I'm using Sybase Adaptive Server Anywhere Database Engine Version 8.0.1.2600 as my...

I have a datawindow that has a DDDW for the column. In my itemchanged event I have: I check to see if this column is for the 'physician'. If it is I want to open up another window. However, If I selected physician a for the first time, the window opens.(i.e. - PB recognizes that a new phys. was...

I'm using the Message.PowerObjectParm object and when my structure is returned(by using the closedwithreturn() function, I'm getting a null object reference. Here is my code: window one: OpenWithParm(window_two,i_structure_one) i_structure_two = Message.PowerObjectParm ll_start =...

As I'm retrieving rows, or even at the end of the retrieve, I want to change the row color based on the value of a certain field. I put the following code in the RetrieveRow event of my datawindow: string mod_string mod_string = "DataWindow.Detail.Color =...

I'm selecting a record from a table and has multiple fields I need to address. I would like to put these values into an array and do processing on them. All the fields are integers. Once the values are in the array, I would like to sort the array. However, I have not found a PB fuction that...

I've never set up a datawindow that uses the RTF type. However, I'm currently maintaining an app that uses many DW's that are of type RTF. I want to add a new field to the SQL and have it displayed in the detail portion of the DW. I was able to change the SQL and add the new field to the select...

I changed the application objects name to something else and when I try to create a project/executable & pbd's I get the following error: Create of executable file failed What I did was open my original application object. Then I did a save as into the same application objects pbl with a...