RE: VFP 2 MySql

2011-10-22 Thread Allen
I used a dbc once, that's why I won't do it again Al -Original Message- Gee, I've never had any problems at all. Maybe that's because I've never used a DBC? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/m

Re: VFP 2 MySql

2011-10-22 Thread Dan Covill
On 10/22/11 10:47, Stephen Russell wrote: > That seems like a lot of duct tape. > > The more I attempt to use DBCs the more I am disgusted with them. Gee, I've never had any problems at all. Maybe that's because I've never used a DBC? Dan Covill ___

Re: VFP 2 MySql

2011-10-22 Thread Stephen Russell
On Sat, Oct 22, 2011 at 12:27 PM, Bill Anderson wrote: > Rick, > > Yep, that's how I handled DBCs. Three DBCs. One for tables. One for views. > One temp DBC per user, copying the view to the local "scratch" DBC. Worked > in VFP 5, never a problem after that. - That seems like a lot of

Re: VFP 2 MySql

2011-10-22 Thread Bill Anderson
gt; Solved more than a decade ago. > > Rick > White Light Computing, Inc. > > www.whitelightcomputing.com > www.swfox.net > www.rickschummer.com > > -Original Message- > From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] > On Behalf Of Stephen Russe

Re: VFP 2 MySql

2011-10-19 Thread Paul McNett
On 10/19/11 8:52 AM, Rick Schummer wrote: > I am not disagreeing with you Paul, but when people start talking in > absolutes like Stephen's post it is like > fingernails on a chalkboard for me. I dislike absolute thinking too. > It is my opinion though that code that is getting migrated from VFP

Re: VFP 2 MySql

2011-10-19 Thread Eurico Chagas Filho
o. > >Rick >White Light Computing, Inc. > >www.whitelightcomputing.com >www.swfox.net >www.rickschummer.com > >-Original Message- >From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On >Behalf Of Stephen Russell >Sent: Wednesday, October 19, 201

RE: VFP 2 MySql

2011-10-19 Thread Rick Schummer
omputing.com www.swfox.net www.rickschummer.com -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Wednesday, October 19, 2011 09:34 To: profoxt...@leafe.com Subject: Re: VFP 2 MySql On Tue, Oct 18, 2011 at 7:59 PM, R

Re: VFP 2 MySql

2011-10-19 Thread Stephen Russell
On Tue, Oct 18, 2011 at 7:59 PM, Rick Schummer wrote: >>>you have to make a connection to an ODBC database and have scripts (select >>>statements) to pull data back to VFP.  You > will also need update and insert scripts as well to save data.<< > > Not always true. Once you establish a connection

Re: VFP 2 MySql

2011-10-18 Thread Paul McNett
On 10/18/11 5:59 PM, Rick Schummer wrote: >>> you have to make a connection to an ODBC database and have scripts (select >>> statements) to pull data back to VFP. You > will also need update and insert scripts as well to save data.<< > > Not always true. Once you establish a connection you can ma

Re: VFP 2 MySql

2011-10-18 Thread MB Software Solutions, LLC
On 10/18/2011 7:17 PM, Stephen Russell wrote: > On Tue, Oct 18, 2011 at 5:54 PM, Sytze de Boer wrote: >> 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? > > > No you cannot consider it VF

RE: VFP 2 MySql

2011-10-18 Thread Rick Schummer
>>you have to make a connection to an ODBC database and have scripts (select >>statements) to pull data back to VFP. You will also need update and insert scripts as well to save data.<< Not always true. Once you establish a connection you can make remote views. With remote views you USE to open

Re: VFP 2 MySql

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 5:54 PM, Sytze de Boer wrote: > 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? No you cannot consider it VFP lite. you have to make a connection to an ODBC databa

RE: VFP 2 MySql

2011-10-18 Thread Jarvis, Matthew
> 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

Re: VFP 2 MySql

2011-10-18 Thread Sytze de Boer
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 wrote: > > > > Hi Mike > > Thanks for trying to help but I'm completely lost > > Please bear in mind I have

RE: VFP 2 MySql

2011-10-18 Thread Jarvis, Matthew
> > 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.

Re: VFP 2 MySql

2011-10-18 Thread Sytze de Boer
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 < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 10/17/2011 9:33 PM, Sytze de Boe

RE: VFP 2 MySql

2011-10-18 Thread Kurt Wendt
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-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, October 18, 20

Re: VFP 2 MySql

2011-10-17 Thread MB Software Solutions, LLC
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 d

VFP 2 MySql

2011-10-17 Thread Sytze de Boer
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 ? -- Regar