Calling a stored procedure creates Fatal Runtime Error! (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 10 AUG 1998 05:33:49PM Jim Wheeler(Aldata Software) wrote:

OpenInsight Specific

I've got a button on my form that gets data from a few controls, like start date, end date, etc. and then passes these to a stored procedure.

Everything worked fine on Friday.

When I continued work on Monday I got the error message "Main program

has been called with arguments." after I had added some code to the procedure.

I placed a debug statement just before the call to the procedure,

everything was fine. As soon as the call to my procedure executes I get the above Fatal Runtime Error. And it says it occurs on a line that is below my "RETURN 0" in my click event for my button.

Can anybody help me please.

At 10 AUG 1998 07:38PM Andrew P McAuley wrote:

What is your routine called? I had a similar problem just the other day with the debugger GPFing…. I'm sure I'll rememebr what caused it eventually as it was quite fixable.

amcauley@sprezzatura.com

Sprezzatura Ltd

World Leaders in all things RevSoft

At 11 AUG 1998 03:43AM Oystein Reigem wrote:

Jim,

Are you sure you didn't introduce syntax errors when you added

code to your procedure? There are some errors that the compiler doesn't detect (at least in earlier versions of OIWG) - errors that result in object code with bizarre effects. E.g, try to leave out the "loop" in a loop-while-repeat, or terminate an if statement with "end case". I've never seen that particular error message you got, though.

- Oystein -

At 12 AUG 1998 12:15AM Aaron Kaplan wrote:

You could have some errant code in the system. Older versions of OI sometimes would miss missing END or ELSE statements or other odd programming errors.

They would generally give bizzare error messages, like the one you are receiving. I'd examine the new code very carefully.

apk@sprezzatura.com

Sprezzatura, Inc.

At 12 AUG 1998 01:38PM Andrew P McAuley wrote:

Aha…

We had ] 10 labelled commons and that bombed with a gpf when invoking debugger.

At 12 AUG 1998 07:14PM Jim Wheeler(Aldata Software) wrote:

It was my code;

IF … THEN
 code
END END
 code
END

I must have looked at this chunk 50 times and didn't

pick up on it, bad day I guess.

Thanks again.

At 13 AUG 1998 12:14AM Aaron Kaplan wrote:

Right. Don't forget, if you click ignore enough times (the number of labeled commons) it will continue.

apk@sprezzatura.com

Sprezzatura, Inc.

At 13 AUG 1998 12:23AM Aaron Kaplan wrote:

Aren't those bugs great?

I once looked at

SomeVar=@RecordSprezzatura, Inc.[/url]

View this thread on the forum...