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 gkittelson 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

Status
Not open for further replies.

ajacka

Programmer
May 26, 2000
2
US
I'm trying to use APPEND PROCEDURES FROM to append new procedures to a client's database, but it generates a &quot;Feature not available&quot; 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?
 
Hi ajacka,<br>&nbsp;&nbsp;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>&nbsp;&nbsp;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>&quot;APPEND PROCEDURES only works when the full VFP environment is available, since it needs to be able to compile the procedures.&quot;</font> <p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br>
 
Thanks.<br><br>Does anyone know how to update the stored procedures of a database without using the APPEND PROC command?<br>
 
My apologies, I only tested within the interpreter, not the compiled app.<br><br><font color=blue>&quot;APPEND PROCEDURES only works when the full VFP environment is available, since it needs to be able to compile the procedures.&quot;</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.&nbsp;&nbsp;They intend that you can now &quot;compile on the fly&quot;, 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 &quot;compile on the fly&quot;, 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
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top