I am in the process of mixing remote views and SQL Pass through, and have run into a problem. I have a business class superclass, a sub-class of KBizObj, that all my business classes are based on. I want to add a method, GetServerDateAndTime(), that uses SQL Pass-through to get the data and time from SQL Server. However, it doesn't look as though I can easily add a call to KBizObj.ExecSql() because all my primary data access objects are remote views, and CDynamicViewCursor does not support the ExecSQL method. Am I understanding this correctly and are there any good work-arounds?
Chris McCandless
Red Sky Software