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
Hi Naomi,
Did you copy these .pbl's from other ones?I think I got a similar error lately because I had just gutted another reportand forgot to delete the arguments.
If you think this could be the case right click the column specification window and select stored procedure and click arguments to check.
Sorry, I just realized that it sounds like you are "creating" these reports not copying them.