Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
APPENDING STORED PROCEDURES
Message
From
14/12/2000 15:53:33
Steven Edge
Soft Solutions Limited
Lagos, Nigeria
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
APPENDING STORED PROCEDURES
Miscellaneous
Thread ID:
00453610
Message ID:
00453610
Views:
112
Hi.

I have developed a framework for my applications, which has the normal 'New', 'Open', 'Close', 'Save As' etc. commands in the 'File' menu. Clicking 'New' will create a new database, with the DBC named according to the user's choice. The creation is done from script.

To handle stored procedures I use the command:

APPEND PROCEDURES FROM ( m.lcTempFile ) OVERWRITE

This works well in the development environment, but when I compile the application for distribution, I get error 1001 (Feature is not available) when the line executes. This means that the stored procedures are not copied into the database, and the database can no longer function properly.

Anyone knows a way around this? Surely, there must be some way to create a database on the fly from a VFP application compiled for distribution, even if they contain stored procedures.

Any help appreciated.

Steven
Reply
Map
View

Click here to load this message in the networking platform