Is there a way to figure out what a view does behind the scenes?
For example, I have an Image field in a SQL server table, and a view on
that table in vfp.
If I use views:
Insert into myview (key, myimage) values('123', cstring)
it works fine.
The MyImage view field is blob, and the field on the server is image.
But if I try SQLExec with this:
"Insert into myview (key, myimage) values('123', '" + cstring + "')"
It crashes complaining about a quote within the cString (entirely possible)
I'd like to find out how the view handles it, so I can mimic it in my
code. Any suggestions? Thanks.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.