I'm trying to use APPEND PROCEDURES FROM to append new procedures to a client's database, but it generates a "Feature not available" error when compiled as an EXE.<br><br>COPY PROCEDURES TO works fine, so I'm confused why APPEND PROCEDURES FROM won't.<br><br>Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Appending stored procedures
- Thread starter ajacka
- Start date
Hi ajacka,<br> The 'Feature Not Available' error is normally generated from a Debug or Set Step On being left in the code. These features arent available in the compiled app. Do you have the source code? If so, verify there isnt a SET STEP ON just before the APPEND PROCEDURES FROM command.<br><br> I tested the COPY PROCEDURES TO and APPEND PROCEDURES FROM commands and found no apparent problems, so the odds are, the problem is in your code. Post a snippet of your code here if you dont figure it out.<br><br>Jon<br><br>
According to <i>Hacker's Guide to Visual FoxPro 6</i>:<br><br><font color=blue>"APPEND PROCEDURES only works when the full VFP environment is available, since it needs to be able to compile the procedures."</font> <p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br>
- Thread starter
- #4
My apologies, I only tested within the interpreter, not the compiled app.<br><br><font color=blue>"APPEND PROCEDURES only works when the full VFP environment is available, since it needs to be able to compile the procedures."</font><br><br>Bummer....the COMPILE DATABASE command doesnt work in runtime. And I thought one of the more superior features of VFP 6 SP3 was the ability to compile on the fly. Guess it's not a complete truth.<br><br>In VFP 7 it will be even easier to compile on the fly with this new command:<br><br>TEXT TO cMyString NOSHOW TEXTMERGE<br>.... your code here ....<br>ENDTEXT<br><br>and then a new function EXECSCRIPT(cMyString) will run the code inside the character string.<br>Or you can write a VFP program to disk from any app, then take it into variable with FILETOSTR() function and execute with EXECSCRIPT(cMyVariable)<br><br>These are <i><b>suppose</i></b> to be some of the new functionalities added to VFP 7.<br><br>Jon
You can <i>try</i> the DoCmd method within the runtime and see what happens...but I don't have much hope that it would work.<br><br>Jon, I wonder if it was an oversight by MS. They intend that you can now "compile on the fly", and perhaps they forgot about turning on that switch for the APPEND PROCEDURES command. <p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br>
<i>Jon, I wonder if it was an oversight by MS.</i><br><br>What??..Microsoft make a mistake??..No..No..Never..Couldnt be that.<br><br><i>They intend that you can now "compile on the fly", and perhaps they forgot about turning on that switch for the APPEND PROCEDURES command.</i><br><br>Wouldnt be the first time.<br><br>I havent done much testing with the COMPILE commands during runtime. I generally only use them when I'm testing/debugging. Although, I did test the COMPILE DATABASE command after I stuck my foot in mouth early on this thread, and it fails just as the APPEND PROCEDURES. <br><br>Has anyone tried these commands under SP4? Maybe they made the correction. (laugh)<br><br>Jon<br><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
