RE: VFP 2 MySql

Back to top

VFP 2 MySql

Author: Sytze de Boer

Posted: 2011-10-17 21:33:59 Link

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 ?

--

Regards

Sytze de Boer

Kiss Software

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

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/CAG1nNy-JUeZvJG5_D5dSG6QE9SM4qqnV5ai+_GG5=w3iJiJU_A@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.

New Search

Back to top

Re: VFP 2 MySql

Author: MB Software Solutions, LLC

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

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.

New Search

Back to top

RE: VFP 2 MySql

Author: Kurt Wendt

Posted: 2011-10-18 10:22:12 Link

Hey Mike - thanks for the explanation - as I've seen WAG used a lot

lately - but, was not sure what it meant - and now I do!

-K-

-----Original Message-----

From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com]

On Behalf Of MB Software Solutions, LLC

Sent: Tuesday, October 18, 2011 12:20 AM

Just a wag...(wild ass guess)

--

Mike Babcock, MCP

_______________________________________________

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/289EA162F5642645B5CF64D624C66A140B7CE2DA@us-ny-mail-002.waitex.net

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

New Search

Back to top

Re: VFP 2 MySql

Author: Sytze de Boer

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

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.

New Search

Back to top

RE: VFP 2 MySql

Author: Jarvis, Matthew

Posted: 2011-10-18 18:50:33 Link

>

> 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

>

Uhm.... do you even have mySql installed in order to use it?

If you do, then you should have a/the username password to start it up.

You can google these commands but it goes something like this at a

command prompt:

msql -u MyUserName -p

list databases;

use MyDatabase;

list tables;

Is that the sort of thing you are struggling with? How to get into and

around in mySql?

Thanks,

Matthew Jarvis || Business Systems Analyst

IT Department

McKenzie-Willamette Medical Center

1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax:

541-744-6145

--------------------------------------------------------------------------

Disclaimer: This electronic message may contain information that is

Proprietary, Confidential, or legally privileged or protected. It

is intended only for the use of the individual(s) and entity named

in the message. If you are not an intended recipient of this

message, please notify the sender immediately and delete the

material from your computer. Do not deliver, distribute or copy

this message and do not disclose its contents or take any action in

reliance on the information it contains.

_______________________________________________

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/69F310C05DD83C48A84BA3769CE1ECF805C01959@TNTRIEXEVS02.triadhospitals.net

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

New Search

Back to top

Re: VFP 2 MySql

Author: Sytze de Boer

Posted: 2011-10-18 18:54:07 Link

Yup

I think from what you say, i can even open the mysql database from within

vfp, and then open a table just like any other table?

S

On Wed, Oct 19, 2011 at 11:50 AM, Jarvis, Matthew <MatJar@mckweb.com> wrote:

> >

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

> >

>

> Uhm.... do you even have mySql installed in order to use it?

>

> If you do, then you should have a/the username password to start it up.

> You can google these commands but it goes something like this at a

> command prompt:

>

> msql -u MyUserName -p

> <enter the pw>

> list databases;

>

> use MyDatabase;

> list tables;

>

> Is that the sort of thing you are struggling with? How to get into and

> around in mySql?

>

> Thanks,

>

> Matthew Jarvis || Business Systems Analyst

> IT Department

> McKenzie-Willamette Medical Center

> 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax:

> 541-744-6145

> --------------------------------------------------------------------------

> Disclaimer: This electronic message may contain information that is

> Proprietary, Confidential, or legally privileged or protected. It

> is intended only for the use of the individual(s) and entity named

> in the message. If you are not an intended recipient of this

> message, please notify the sender immediately and delete the

> material from your computer. Do not deliver, distribute or copy

> this message and do not disclose its contents or take any action in

> reliance on the information it contains.

>

[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/CAG1nNy8HJ=LnVaG6OEPaTkA0mkdykLtAn7ffQ0yv9H=whjasYA@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.

New Search

Back to top

RE: VFP 2 MySql

Author: Jarvis, Matthew

Posted: 2011-10-18 19:05:35 Link

> Yup

> I think from what you say, i can even open the mysql database from

within

> vfp, and then open a table just like any other table?

>

> S

No....

The commands I typed are from the msql command prompt, NOT the VFP

command window.

It is similar syntax and commands, but venture much further and they

(commands) start to diverge a lot more.

You can easily connect to mysql tables via ODBC (as was recently

discussed here), or you can feed data into your tables from the msql

command prompt with INSERT commands. The SQL syntax for VFP versus mySql

is virtually the same as I recall. BUT mySql enforces (can't remember

what the name if it is called) 'proper' GROUP BY syntax, whereas VFP

let's you be pretty free form.