Re: VFP 2 MySql

Author: Sytze de Boer

Posted: 2011-10-18 at 18:44:29

Hi Mike

Thanks for trying to help but I'm completely lost

Please bear in mind I have no idea how to open a mysql database

Can you try again ?

S

On Tue, Oct 18, 2011 at 5:20 PM, MB Software Solutions, LLC <

mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:

> 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

>

[excessive quoting removed by server]

_______________________________________________

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/CAG1nNy8Vi9gSLkGWS-8Ko1Kxvy7pbedNr5zHjeS-dqzhwfxUzw@mail.gmail.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 Sytze de Boer