Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert DateTime to a string to send to SQL serv
Message
De
05/09/2010 19:28:04
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., Nouvelle Zélande
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01480183
Message ID:
01480226
Vues:
64
>>I am not sure, in general how I can use the parametrized command with Cursor Adapter approach. For example, say I have a user entry form where Cursor Adapter is created, fills cursor with data from the back end (SQL Server). Then, when user makes changes, the program simply executes TableUpdate() which updates the table in the SQL Server. Could someone enter the "malicious" entry (similar to your example) in one of the fields and cause the table dropped or something like this on TableUpdate()?

No, because Tableupdate() generates parameterized sql and in the case of RV has done so since 1995. This isn't well understood outside the VFP community and even VFP gurus who habitually advise against RVs were unaware that VFP is injection-proof unless you follow their advice to roll your own SP/SPT as you have to with other tools. ;-) Actually that's not so true any more, e.g. Linq, but it's still an example of how advanced VFP was and still is in some respects- e.g. automatic resultset spooling to disk that was in FP since the late 1980s but is just starting to appear in other MS tools this year. But lets not go there. ;-)
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us.
"
-- Shakespeare: Coriolanus, Act 1, scene 1
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform