Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changes in the SP and SDT
Message
De
03/02/2009 07:32:27
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01375527
Message ID:
01378939
Vues:
26
This message has been marked as a message which has helped to the initial question of the thread.
>>>Doug,
>>>
>>>I made a change again and the same thing happen again. For few days it was using my new version and right now it somehow reverted back to the original SP. I believe we did update the structure through SDT.
>>
>>Hi Naomi,
>>
>>if I understand the sequence of events properly:
>>
>>Day 1: make a change in SDT and update database
>>Day 2 - 3: everything fine.
>>Day 4: old stored procedures start being used
>>
>>It sounds like some is restoring your old database/stored procedures on day 4.
>>
>>I have been using SDT for many many years and never had a problem with SPs getting changed.
>
>We're using some special utility written by my former colleague to update our database based on SDT. I'm not exactly sure what this program does. In any case, just to be safe I updated both - out developement database SP and our production DB SP. Hopefully it would take care of the problem now.

Sounds like you need to ensure that update utility is doing the right thing, otherwise this will come back and bite you or somebody else when they don't update both databases with the adjusted SPs
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform