Hi Ivan, I'm trying to pin down the steps:
1. open the interactive SQL interface 2. enter one or more SQL files, delimited by semi-colon 3. press the 'execute' button Is this correct? Also, how do I specify that I wish to replace an old SQL procedure with a new one? Is there an "edit" function in the iSQL interface? Thanks, -sherman On Tue, Aug 30, 2011 at 1:01 AM, Ivan Mikhailov <[email protected]>wrote: > Hello Sherman, > > > Is there any document that cover the development/testing phase of the > > VAD lifecycle? I can't imagine that I would need to redeploy each time > > I wanted to modify and test new SQL. > > There's little need in any special techniques for VAD, because 99.99% of > the application code resides in plain old .SQL files that can be edited > by any appropriate editor and loaded via ISQL. The only requirement for > them is to put ending ';' of statements at separate lines, so the VAD > routines will cut the file by semicolon-only lines. As soon as all .SQL > files are ready and tested on fresh empty database, writing the .vad > file itself is quite simple (and patching some existing one is even > simpler) > > Best Regards, > > Ivan Mikhailov > OpenLink Software > http://virtuoso.openlinksw.com > > > -- Thanks, -sherman Every good gift and every perfect gift is from above, and cometh down from the Father of lights, with whom is no variableness, neither shadow of turning. (James 1:17)
