General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
APPENDING STORED PROCEDURES
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only