Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update doesn't work without thisform
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01525200
Message ID:
01525236
Views:
59
>Try this
TEXT to mSqlcommand noshow pretext 15 TEXTMERGE
>UPDATE MyView
>	SET
>		Field1 = nValue1, 
>		Field2 = <<.nSomeValueIHave>> 
>	WHERE code = nValue3
>ENDTEXT
>&mSqlCommand
>
>Be sure to remove all semicolons in your code. The TEXTMERGE comment will replace
<<.nSomeValueIHave>>
with the value of your form property.
>HTH


Bad idea. SQL injection risk

Relevant:
http://xkcd.com/327/
Brandon Harker
Sebae Data Solutions
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform