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!

Register Log in
  • Congratulations Mike Lewis 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. joechan

    Capturing Exception of oleobject operation

    Hi all, I need help on how to trap exceptions within the same procedure/function and display customed message when dealing with oleobject operation. Code (within button click() event) oleobject ole1 ole1 = create oleobject : : ole1.application.activeworkbook.worksheets.Add...
  2. joechan

    SQL Query

    Hi all, I got 2 tables : Account_Header and Account_Transaction with the following fields : Account_Header : ACCT_CODE, ACCT_NAME Account_Transaction : ACCT_CODE, TXN_AMT I want to obtain the a view of the each account with top 3 transactions like this: ACCT_CODE TXN1 TXN2 TXN3 001...
  3. joechan

    PB7 datawindow saveas function to Excel cannot exceed 255 characters

    Thanks reevda. I tried to change the column type to text but still not succeed. I repainted the dw as well. I also tried to use saveas in different format. use Text! parameter >255 char can be exported. I found the type in dw for the text column displayed "char(4099)", is it the same in your...
  4. joechan

    PB7 datawindow saveas function to Excel cannot exceed 255 characters

    Hi all, I tried to export data from a datawindow to Excel using SaveAs function and found that first 255 characters can be exported when the column size is over 255. I tried to split the columns and merge it using OLE automation but the performance greatly decreased. Any suggestion to solve...

Part and Inventory Search

Back
Top