Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
APPENDING STORED PROCEDURES
Message
De
14/12/2000 15:53:33
Steven Edge
Soft Solutions Limited
Lagos, Nigéria
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
APPENDING STORED PROCEDURES
Divers
Thread ID:
00453610
Message ID:
00453610
Vues:
113
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
Fil
Voir

Click here to load this message in the networking platform