I don't know how SQLCA is set up. And I can't remember how to get to it. I'm sure it's in some main file somewhere.
But I just tried something a friend suggested. I just replaced SetTrans() with SetTransObject() and it works now.
But I don't know why.
1| open(w_report)
2| w_report.dw_1.DataObject = "d_cat_breakdown"
3| w_report.dw_1.SetTrans(SQLCA)
4| if w_report.dw_1.Retrieve() = 0 then ....<snip>
This is the relevant part of the code that, up until recently, has been working fine.
Now, the debugger shows me that on line 4, an error is...
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.