Vince Teachout wrote:
> 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.
Use named parameters. I just posted a similar answer yesterday to a
fellow Foxer.
See http://leafe.com/archives/showMsg/421557
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16
_______________________________________________
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.
