Re: VFP 2 MySql

Author: MB Software Solutions, LLC

Posted: 2011-10-18 at 00:20:06

On 10/17/2011 9:33 PM, Sytze de Boer wrote:

> Hi folk

> I need help with something I've never done

> I have a system that needs to produce a GIF file. That's no problem, I know

> what to do

> I need to populate/update a mysql database field with the name of this gif

> file

> I have no idea how to do this

> Can someone point me in the direction ?

Can you take the gif and store it in a LongBlob field? I do that with

my Inno Setups in a MySQL table. Similarly, you could do that with your

.gif file. Just do a pbFile=FILETOSTR("c:\abc\def.gif") into private

variable pbFile, then use the INSERT INTO MyTable (bfile) values (?pbFile)

Just a wag...(wild ass guess)

--

Mike Babcock, MCP

MB Software Solutions, LLC

President, Chief Software Architect

http://mbsoftwaresolutions.com

http://fabmate.com

http://twitter.com/mbabcock16

_______________________________________________

Post Messages to: ProFox@leafe.com

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/4E9CFE76.1060500@mbsoftwaresolutions.com

** 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.

©2011 MB Software Solutions, LLC