Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Retrieving the signature of a stored procedure
Message
De
02/02/2005 09:16:25
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00982987
Message ID:
00983026
Vues:
20
>You can just open the DBC as a table [USE MyDBC.dbc ALIAS DBCTable] and read the contents of the source code memo field just like any other field in a table. Then you can write code to parse through it looking for whatever information you want to write in your metadata tables.

>SELECT ... FROM MyDBC.DBC DBCTable WHERE ...

>also works.

Unfortunately, the code for the AfterAppendProc event will appear in the stored procedures. Within the execution of that procedure, I can't close the database to reopen it as table. That is why I was hoping to have some DBGETPROP for this.

I understand that I could do my parsing offline, once from time to time, but that is unreliable. Automatic updating would be much better.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform