Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Re-create Stored Procedure
Message
From
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:
00454347
Views:
34
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
Next
Reply
Map
View

Click here to load this message in the networking platform