Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement