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

Thanks Bernd but I have tried all this. It is a problem with Textlimit for SQLCA.dbms but I have already set this to 32000 (as recommended) and it is still truncating. I have tried using ODBC but there in the database profiles in PB there is not a field for textlimit as there is for MSS SQL...

No, I have not. How do I try this?

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

Thanks, this problem is now solve (in a similar way to your suggestion) thanks for your input

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 only want the validation on exsiting records to be run when the user tries to save. If they don't try to save then they should be able to close the window without any message. This is why I was saying about the before save event.

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

forget that it is calling it and it works great. thanks again.

thanks very much for your help. does this need to be called from of_validation function? If this doesn't exist should I create it? I've basically written the code in the pfc_validation but it isn't being called when I click save.

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

This is for updates only the intial value is working for new records so I don't get this error when I add only when I update. It seems to be associated to the field being a checkbox. If i change to an edit box then I don't get this error!

Yes, in the pfc_update there is a call to the pfc_update in the ancestor but the save is not getting this far. Code is: SUPER:EVENT pfc_update(boolean1,boolean2). I get these errors before it gets to this code. Thanks

Yes the data values are set to N and Y. This error only seems to occur when I try to update an existing record and not when I create a new one. Thanks.

BTW: the field in the database table allow NULLS.

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?