before activating form:
if {ActiveDocument.Sections["myResultSection"].RowCount ==0) {
Alert("Yo...Sorry No Records Found")
}
else {
ActiveDocument.Section["MySecondForm"].Activate()
Blah
Blah...
}
add ALL the tables you need to the first query
from the command menus choose DataModel/DataModel Options/ go to the Joins tab and select 'use the minimum number of topics'
If the topic(s) columns needed for the second union query are/is not in the limits and not in the requests it will not be...
are you in Oracle? (in sybase look up the 'case' statement)
select sum(decode(QuestionResponse,a,1,0)) Q1a,
sum(decode(Question1Response,b,1,0)) Q1b,
sum(decode(Question1Response,c,1,0)) Q1c,
sum(decode(Question2Response,a,1,0)) Q2a,
sum(decode(Question2Response,b,1,0)) Q2c,
etc, etc...
Then...
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.