Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can MSSQL Stored Proc call VFP?
Message
 
 
À
23/12/2009 19:56:29
Hong Yew
People Quest
Malaisie
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01440444
Message ID:
01440458
Vues:
61
>Hi Naomi
>
>I have some existing VFP vodes that uses VFP EVALUATE. I gather it will be very diificult or impossible to do such using T-SQL code.
>
>I understand that .NET reflextion does something similar but isn't quite easy to implement.
>
>Appreciate if you could advise
>
>Wishing you a Merry Christmas and a great New Year!
>
>Thanks & Best Regards

Yes, I think it may be better to re-write VFP logic into T-SQL, if possible. If it's some complex functionality, in SQL Server 2005 and up you can create CLR function/sp/ or trigger. I didn't try myself, but we have a project that implemented CLR for getting a Hebrew birthday (in Hebrew calendar).

Happy Season to you as well!
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform