Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 061178

    Checkboxes

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

    Datawindows

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

    Comments field declared 500 varchar only showing 256 chars

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

    Comments field declared 500 varchar only showing 256 chars

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

    Comments field declared 500 varchar only showing 256 chars

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

    Calculating 2 years from a date

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

    Calculating 2 years from a date

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

    Implementing new validation on existing records

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

    Implementing new validation on existing records

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

    Validation on save

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

    Validation on save

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

    Validation on 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...
  13. 061178

    pfc_prermbmenu

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

    Datawindow doesn't have update property error

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

    Required value message on datawindow

    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!
  16. 061178

    Required value message on datawindow

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

    Required value message on datawindow

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

    Required value message on datawindow

    BTW: the field in the database table allow NULLS.
  19. 061178

    Required value message on datawindow

    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'...
  20. 061178

    using describe to get the current update properties of dw

    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?

Part and Inventory Search

Back
Top