Ugh, this is an SOS because soon I am going to tear my hair out!
I have two separate reports I am trying to create in infomaker, I have the sql created already.
When I go into infomaker and select the stored procedure to use I receive this error:
"Cannot create Datawindow Requested result set number 1 not found; execute stored procedure @ parameters"
The only thing I can think of is I have the sql doing different select statements depending on the mode that is chosen however all of that is inserted into a temp table and the final select is from the temp table.
Thanks!
Naomi
Thanks guys. It turned out that I did not include my begin and end statements in my if clauses, the sql ran ok but infomaker could not determine where to stop and where to start.