Compiling Stored Procs (OpenInsight Specific)
At 21 JUL 1999 06:08:32PM Kevin Bolitho wrote:
I really miss some of the AREV editor features. (eg SF2 to directly access $Inserts etc). Since a simple AREV style editor would suit me better I have played with the concept of a simple form with an edit box control for editing. As such I can build in the features I want. BUT I am not sure how to compile a stored proc and GET COMPILER Errors in the form of line numbers and syntax error descriptions. Repos compile seem to return if the compile succeded or not.
Has anyone managed this - RevTech can you point me in the right direction.
Thanks all
At 21 JUL 1999 07:06PM Paul Rule wrote:
I've done something like what you're trying to do. A home made editor with the ability to compile. Try this as an example.
call recompile_proc("PROGRAMNAME*":account)
error=get_status(errormsg)
call set_status(0)
if error then
line=errormsgif not(num(line)) then line=0call msg("","ERROR COMPILING|":errormsg:"|Line ":line:"|":errormsg:" is invalid")end
There are other things to consider, such as if the procedure is not defined in the repository yet, you'll have to create an entry for that too.
At 17 NOV 1999 09:20AM Jackie Jones wrote:
Paul, the other things to consider such as if the
procedure is not defined in the repository yet, you'll
have to create an entry for that too.
How do you do that?
Thanks
At 17 NOV 1999 09:35AM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura Group[/url] wrote:
You could try a REPOSITORY NEW.
One of the best ways to get information on the repository is start an engine log before doing some things. Then, save the log, cut&paste what you need and make variables out of the important parameters.
akaplan@sprezzatura.com