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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.