Search results for query: *

Hi there, How do you set a checkbox to false according to what other checkboxes are checked? There are multiple rows on my dw. e.g.this.object.synd_uw_responsible[row].Checked = False doesn't run. so when user tries to check a checkbox if they can't then I want to overwrite the fact that they...

I have recently had a lot of hanging problems with PB9. I have created a new workspace and now when I right click - Modify DW the application just hangs. Before I couldn't even get into PB, now I have a new workspace I can not modify the datawindow as the app just hangs. Any help would be...

Hi, I have a column in a table declared as a T_description (500) which is a varchar (500). In the application I save my record which updates the column with 350 chars (for e.g.) the update works and when select the column in query analyser the column has been updated. In the app only 256 chars...

Hi, I need to add two years onto a date in PB. I can not simply add 730 days to the date I have as this is inaccurate. I need to calculate when a leap year occurs and then add on the number of days accordingly. Can anyone point me in the right direction? Thanks.

I have put in new validation on the itemchanged event of a field and in pfc_Validation which works well. But if an existing record is opened which fails the new validation check I am still able to save (as nothing has been changed.) Can someone suggest how I get around this? I could force the...

hi, i have a problem where if 1 field is altered to specific value then a 2nd field should be filled. I can not do this validation soley on the itemchanged event as the 2nd field is not changing. The problem is that the 1st field is filled then the user can simply save with no value being in the...

hi there, I have a dw inherited from dw_main which is inherited from u_dw. I have script in the pfc_prermbmenu to enable the open option on the right menu and then bring back detail of what user chooses. When I run the app the menu doesn't appear. when I add breakpoints in the event and debug it...

Hi, I posted a thread earlier in year but unfortunately nothing that suggested resolved my problem. I have the dw does not have update capability message. the dw has the update properties set correctly. I have even changed the data object (actual datawindow) to another very similar one which I...

I have a datawindow and when I try to save I get the message 'Required value missing for [field name] on row 1. Please enter a value'. This is usualy a message that appears when there is no default value set for a field on the dw. The field in question is a checkbox and the default value is 'N'...

Hi , I can use: This.Describe("DataWindow.Table.UpdateTable") to get the table that is being updated from a dw, but I need to get whether the update properties are set to Yes or No for the dw. I want to do this on the updatestart event. Can anyone help?

Hi, I have used RelativeDate powerscript function to calculate a future date. This was fine, but the client now wishes to exclude weekends. RelativeDate doesn't have this functionality and I can not find a function in PB which does. Does anyone know of a function or can give me some pointers to...

Hi, I've altered the name of db (by backing up db then restoring it to new name under a new SQL Server group in Enterprise manager). I can connect to db in SQL Server 2000. In PB 9 (in the database profiles setup) I can not connect to the new database, I've entered the correct server etc, but...

Hi, I've got a new screen with a lot of fields on it. I have added the functionality to add a new record and use setrowfocusindicator to use a hand to point to the first field of the new record. The only problem is is that although the cursor is on the first field of the new record the window...

Hi, I've done some changes to my pb 9 code. Instead of completing a full build through the project I have built the relevant runtime libraries of the .pbls that have altered. I have then used the .pbds with the relevant exe and dll's that were from the last full build. when I run the exe on a...

Hi, I am getting the above message but the datawindow does have update capability. I have checked Key columns, Use update and selected the correct fields to be updated and check that the primary key is correct, but this error still shows when I try to save. Anyone have any other ideas?

Hi there, I have a dddw in a dw and I have successfully retrieved a value into this dropdown depending on a retrieval argument (using getchild etc). Now all I would like to do is set the value of this field (which is a dropdown) to be the only value that is retrieved. Basically, this field is...

Hi, I have inherited a user object from w_tabpg_entity and created code in the pfc_retrieve event to retrieve on two retrieval arguments. When I run my code a message is displayed which says that it is expectig 2 retrieval arguments but only got 1. The reason I think is because in the...

Hi, I've recently upgraded from SQL Server 6.5 to 2000 and now my application (PB9) sometimes displays the message 'The COMMIT transaction request has no corresponding BEGIN transaction ' when I try to save changes. Any suggestions would be very very helpful. Thanks.