On Wed, Jun 10, 2009 at 1:24 PM, Vince Teachout<[email protected]> wrote:
> Stephen Russell wrote:
>
>> Well there is no conversion in your description from string to proper
>> file type before use.
>
> Hi Stephen,
>
> I just posted the bare minimum for the problem. In real life, I have
> PDF file, and cString = FiletoStr("somefile.pdf")
>
>> This is not the first time images and storage in a DB have been a
>> problem. You just have to stop that use of cstring in your insert.
>> [values('123', '" + cstring + "')"]
>>
>> You will have to make the conversion before hand and pass that value
>> instead. I experienced that when 2000 came out so it was a long time
>> ago.
>
> And that is the question I was trying to ask, but failed. How do I
> pass that value in a SQL statement to use in SPT? The code above was my
> non-working attempt. Thanks.
----------------------------
Stop this first:
PDF file, and cString = FiletoStr("somefile.pdf")
FiletoStr() is the gun that is shooting you in the foot here.
In VFP I don't know how to how to pass the .pdf file.
C# has a few options as does java and python I am sure but don't know them.
I know that you will have to get to low level vai shell to do this. I
know that there is a site for all that shell calls from VFP, but I
cannot remember it. Sorry.
--
Stephen Russell
Sr. Production Systems Programmer
Web and Windows Development
Independent Contractor
Memphis TN
901.246-0159
_______________________________________________
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.
