Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Re-create Stored Procedure
Message
From
16/12/2000 01:44:25
 
 
To
16/12/2000 01:42:14
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00454240
Message ID:
00454348
Views:
33
Come to think of it, it doesn't make any difference.
But if you want to track whether the database had procedures added or not, this is how I would suggest making that determination.

>see the bold line below
>
>>>>Hi everyone,
>>>>
>>>>I have a program, which creates a clone of Database. The question is: how can I clone Stored Procedure for the database?
>>>>
>>>>Thanks in advance.
>>>
>>>
SET DATABASE TO oldatabase
>>>COPY PROCEDURE TO x.prg
><b>IF !EMPTY(FILETOSTR("x.prg"))</b>
>  >>SET DATABASE TO newdatabase
>  >>APPEND PROCEDURES FROM x.prg
><b>ENDIF</b>
>>
>>Trey,
>>
>>If Database doesn't contain Stored Procedure, would it still work or I need to add some check here?
>>
>>Thanks in advance.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform