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

    Retaining DisplayCoulm value of dddw which is multiply used in a single datawindow

    Try the following: In the Datawindow for your answer dropdown list: 1. Add a text field to the Header Band for a question code, such as t_question_code. 2. Add a computed column to the Detail Band, such as c_showrow, using the following expression: if(describe(“t_question_code.Text”) =...
  2. xsyguy

    calculate days between different da

    Try converting the DaysAfter between the dates to seconds by multiplying it by 86400, then add the SecondsAfter between the time, then convert the result back to days by dividing it by 86400. For example: ldec_days = ((DaysAfter(test_dt, dx_dt) * 86400) + SecondsAfter(test_tm, dx_tm)) / 86400
  3. xsyguy

    Grid Column width disabled

    The columns defined by the grid lines in a Grid DataWindow are a function of the presentation style. Other objects besides the data column objects may be associated with each grid column, such as Header text objects or computed field objects in the Summary or Footer bands, so the X and Width...
  4. xsyguy

    Page break in DW

    Try adjusting the height of the Detail band and/or the Bottom Margin property in the Print Specifications of your Datawindow.
  5. xsyguy

    how Set a decimal to NULL

    Try using the SetItem function instead of a DataWindow data object reference to set the value. Example: decimal ln_foo SetNull(ln_foo) dw_1.SetItem(row,columnname,ln_foo) If the column has an Edit Style of Edit you may also need to make sure the "Empty String is NULL" Edit property is checked on.
  6. xsyguy

    Button that goes to link

    In the Clicked event of the Button you can get an instance of an inet object (Internet ContextService object) and call the HyperlinkToURL function to open a web link in the default Browser. Example: // Clicked event inet linet_base GetContextService("Internet", linet_base)...
  7. xsyguy

    Menu: I can't see toolbar!

    Is the window you are using the menu in an MDI or MDIHelp window? Toolbars only appear on MDI-Type windows.
  8. xsyguy

    Pb 7.0.3 -> Windows 2003??

    I have not tried to migrate any application to PB 10 yet, but I have migrated applications from PB 6.5 to 9 without any trouble. I don't think you should have any trouble but maybe someone else who as done such a migration can relate their experience.
  9. xsyguy

    Pb 7.0.3 -> Windows 2003??

    PowerBuilder 7 is not "supported" at all any more. The Sybase End-of-Life for PowerBuilder 7 support was July 15, 2003. So Sybase no longer certifies it for any version of Windows. (FYI, the End-of-Life for PowerBuilder 8 support is April 2, 2005). As to whether your application will run under...
  10. xsyguy

    Urgent! Datawindow disappears when a column is added

    Is the DataWindow shared to another DataWindow or DataStore (using ShareData)? After adding the column the DataWindow object may work fine by itself, but if the DataWindow is the secondary DataWindow in a ShareData, the function may fail if the column is not also added to the DataWindow object...
  11. xsyguy

    Windows API for checking file created date?

    My suggestion would be to use the PFC File Service object n_cst_filesrvwin32. It has two functions, of_GetCreationDate and of_GetCreationDatetime, that will return the creation date of a file. If you do not want to use the PFC service, look at the PFC object pfc_n_cst_filesrvwin32 in...
  12. xsyguy

    why is the library list disabled?

    I believe PB 9 will not allow you to change the Library list if you have any object open in a painter. Try closing all open objects before opening the Library List.
  13. xsyguy

    Making a word in a string bold

    In a RichTextEdit object you use the SetTextStyle function to set the currently selected text to bold, underlined, italics, etc. The trick is to select the text you want to change. The SelectText function in a RichTextEdit object requires a starting line, starting character, ending line, and...
  14. xsyguy

    Toolbar Buttons Too Large??? How can I change them?

    It sounds like you may have the application ToolbarText property set to TRUE. This makes the toolbar buttons larger in order to display a text description (even if no text description has been set in the menu for the toolbar buttons.) In PB6.5 I think this property must be set in a script. (I...
  15. xsyguy

    why file DSN isn't working?

    In your File DSN, is "mydbName" the name of your MS Access database? If it is, did you try changing the Driver name to the Microsoft Access Driver instead of the Sybase Driver? Also, you have a user ID parameter in your File DSN but do you also need to have a password parameter?
  16. xsyguy

    why file DSN isn't working?

    The Driver named in you File DSN does not appear to be a valid ODBC Driver name to me. Open the ODBC Administrator on your PC and select the Drivers tab. The Driver parameter in your File DSN must match one of the driver names listed. Also, since you are trying to link to tables in an Access...
  17. xsyguy

    DNSless (dns-less) connection to an MS Access Database

    I have not tried to make a DSN-less connection to an MS Access database, but following is a sample of some code I use to make a DSN-less connection to an ASA database. String ls_connectstring SQLCA.DBMS = "ODBC" ls_connectstring = "Driver=Adaptive Server Anywhere 7.0;" + &...
  18. xsyguy

    Change the colour of different lines in MultiLineEdit control..

    The only way to set the colour of the text in a MultiLineEdit control is by the TextColor property, which sets the color for all the text. So the answer is no, you cannot set multiple colors for text in a MultiLineEdit control. The only native PowerBuilder objects that will allow you to set...
  19. xsyguy

    DWC.Modify() - Error???

    You need to put an extra set of quotes around the text in ls_value because the "expression" you are trying to set is a literal string. Try setting ls_mod_string as follows: ls_mod_string = "c_field_name.Expression=~"'" & + ls_value & + "'~""
  20. xsyguy

    DWC.Modify() - Error???

    It could be because the expression in ls_value is invalid or contains quotes that conflict with the quotes surrounding the expression in ls_mod_string. Can you give an example of the expression you are trying to set and what is returned in ls_err?

Part and Inventory Search

Back
Top