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: {OT] Warming Revives Dream of Sea Route in Russian Arctic

2011-10-18 Thread Ed Leafe
On Oct 18, 2011, at 7:46 PM, Nicholas Geti wrote: > I hit the { key instead of the [ key for OT. I thought Ed said his program > accepts either one. It seems that the software to segregate the lists accepts either, but many people subscribe to the full list and have rules to put [OT] me

Re: {OT] Warming Revives Dream of Sea Route in Russian Arctic

2011-10-18 Thread Pete Theisen
Nicholas Geti wrote: > I hit the { key instead of the [ key for OT. I thought Ed said his program > accepts either one. Hi Nicholas, Ed's program does, but what of us poor proles out in the 'hood frantically searching our folders for something, anything, that you have posted. I mean, serious

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: {OT] Warming Revives Dream of Sea Route in Russian Arctic

2011-10-18 Thread Nicholas Geti
I hit the { key instead of the [ key for OT. I thought Ed said his program accepts either one. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mail

Re: m$ & dell msgs in my face.

2011-10-18 Thread Paul McNett
On 10/18/11 5:10 PM, william tormey wrote: > Does anyone know how to kill off this intrusion, please. Also where can Look for a service called something like "Error Reporting Service". Paul ___ Post Messages to: ProFox@leafe.com Subscription Maintenanc

m$ & dell msgs in my face.

2011-10-18 Thread william tormey
Hi all, Using VFP 5.0 Prof. on a Dell(ug) laptop running Xp, while program testing. Any run time crash causes an m$ pop-up requesting details of the crash. Well funny thing, the crashes have to be my fault. The environment has a mix of machines cooperating in a process control environment running

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: [OT] Scientists trace heat wave to massive star at center of solar system, .

2011-10-18 Thread Pete Theisen
Michael Madigan wrote: > http://www.theonion.com/articles/scientists-trace-heat-wave-to-massive-star-at-cent,21088/ Hi Michael, Little bugger has been slacking off the last few . . . -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/ __

[OT] Scientists trace heat wave to massive star at center of solar system, .

2011-10-18 Thread Michael Madigan
http://www.theonion.com/articles/scientists-trace-heat-wave-to-massive-star-at-cent,21088/ ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/li

Re: VFP9: Oracle ODBC (11g)

2011-10-18 Thread Christof Wollenhaupt
The easiest installation is usually the Oracle InstantClient ( http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html ). Christof On Tue, Oct 18, 2011 at 9:09 PM, Desmond Lloyd wrote: > Good Afternoon, > > Have just spent almost 1 hour digging through Oracle stuff

Re: VFP9: Oracle ODBC (11g)

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 3:36 PM, Desmond Lloyd wrote: > Thank you, > > Have that information actually.  The Oracle client is installed on each > workstation.   The Oracle site is this morass of use this if, but on > cloudy days use that,  but then again.  8-) - There may h

Re: VFP9: Oracle ODBC (11g)

2011-10-18 Thread Desmond Lloyd
Thank you, Have that information actually. The Oracle client is installed on each workstation. The Oracle site is this morass of use this if, but on cloudy days use that, but then again. 8-) Regards, Desmond On 18 October 2011 15:33, Stephen Russell wrote: > On Tue, Oct 18, 201

Re: VFP9: Oracle ODBC (11g)

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 3:06 PM, Desmond Lloyd wrote: > Nope...  Have an ERP system that uses Oracle 11g,  Would like to use VFP as > a report writer/"specialty" apps. 8-) -- You will have to find the tnsnames file and that is your pointer to Oracle. That is what I use wi

Re: VFP9: Oracle ODBC (11g)

2011-10-18 Thread Desmond Lloyd
Nope... Have an ERP system that uses Oracle 11g, Would like to use VFP as a report writer/"specialty" apps. 8-) On 18 October 2011 15:04, Stephen Russell wrote: > On Tue, Oct 18, 2011 at 2:09 PM, Desmond Lloyd > wrote: > > Good Afternoon, > > > > Have just spent almost 1 hour digging

Re: VFP9: Oracle ODBC (11g)

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 2:09 PM, Desmond Lloyd wrote: > Good Afternoon, > > Have just spent almost 1 hour digging through Oracle stuff trying to find an > ODBC that will allow both 32 bit and 64 bit Windows 7 machines to access > Oracle 11g from VFP9. > > Can someone perhaps give me the version nu

VFP9: Oracle ODBC (11g)

2011-10-18 Thread Desmond Lloyd
Good Afternoon, Have just spent almost 1 hour digging through Oracle stuff trying to find an ODBC that will allow both 32 bit and 64 bit Windows 7 machines to access Oracle 11g from VFP9. Can someone perhaps give me the version number or perhaps a link to what I neeed to download and install...

[OT] Michigan Cops have no sense of humor

2011-10-18 Thread Pete Theisen
Hi Everybody, I was driving good! http://www.aol.com/2011/10/18/girl-drives-drunk-dad_n_1017373.html -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/ ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leaf

[OT] Zap a Spic

2011-10-18 Thread Pete Theisen
Hi Everybody, http://www.foxnews.com/politics/2011/10/17/hispanic-advocacy-groups-rebuke-cain-over-electric-fence-joke/ Actually, the voltage is low, it just gives you a poke. But no one gets near it twice! Getting a poke at the fence is way better than dying in the desert a day or two later an

RE: VFP9: Error Loading Print Driver

2011-10-18 Thread Jarvis, Matthew
> was good Modified the button click with the only difference being > the > addition of a preview. Well, it didn't like that, get a Error Loading > Print Driver, however if I just output directly the printer all is well! > > FWIW it's a Brother Printer... Not sure this would apply to

VFP9: Error Loading Print Driver

2011-10-18 Thread Desmond Lloyd
Good Morning, Long time since I have been on the list. Nice to be able to hear all the Fox and OT chatter again. 8-) In any event, have a VFP9 app, runs fine. Added a new report to it the other day, it is essentially a tag (about 4 x 3) with the printer set to manual feed. (printer en

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: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 8:18 AM, Alan Bourke wrote: > > > On Tuesday, October 18, 2011 7:50 AM, "Stephen Russell" > wrote: >> >> I like the easy find capabilities in intellisence myself.  I have >> worked with a lot of Oracle minded data developers so having a column >> name that is 12-14-20 char

Re: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-18 Thread Ed Leafe
On Oct 18, 2011, at 7:50 AM, Stephen Russell wrote: > Sounds like jealousy. :P No, more like relief that I'm no longer tied to an IDE. Plain text editing rocks! > I like the easy find capabilities in intellisence myself. I have > worked with a lot of Oracle minded data developers so h

Re: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-18 Thread Alan Bourke
On Tuesday, October 18, 2011 7:50 AM, "Stephen Russell" wrote: > > I like the easy find capabilities in intellisence myself. I have > worked with a lot of Oracle minded data developers so having a column > name that is 12-14-20 char is normal. Not what I want to type but you > get over it. >

Re: Converting an old FPW 2.6 to VFP 9.0

2011-10-18 Thread Alan Bourke
On Tuesday, October 18, 2011 2:06 PM, "Paul Hill" wrote: > > Just a thought: Can VFP launch a FPW EXE? e.g. 'DO MyApp.exe' > Probably not... No, you get 'Object file xyz.exe was compiled in a different version of FoxPro.' -- Alan Bourke alanpbourke (at) fastmail (dot) fm _

Re: Converting an old FPW 2.6 to VFP 9.0

2011-10-18 Thread Paul Hill
On Tue, Oct 18, 2011 at 1:37 PM, Alan Bourke wrote: > On Tuesday, October 18, 2011 2:53 AM, "Michael Madigan" > wrote: >> Will it compile as-in in VFP 9? > > What I meant was - it might be less hassle to leave it as it is now if > the customer doesn't want to pay to bring it up to VFP9 properly.

Re: How to RELEASE a .app file from FoxPro IDE?

2011-10-18 Thread Christof Wollenhaupt
I've seen this when classes are instantiated with NEWOBJECT() passing the application name as the third parameter or when the IN clause is used with SET CLASSLIB. You could run the code from my security session to peek into the system datasession whether there's any VCX open. When you clear classe

Re: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 7:41 AM, Ed Leafe wrote: > On Oct 18, 2011, at 7:13 AM, Stephen Russell wrote: > >> If your naming screws how intellisense works and I cannot FIND the >> sucker you just wasted my time.  Do it time and again and it is >> wasteful. > >        If you base your naming conventi

Re: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-18 Thread Ed Leafe
On Oct 18, 2011, at 7:13 AM, Stephen Russell wrote: > If your naming screws how intellisense works and I cannot FIND the > sucker you just wasted my time. Do it time and again and it is > wasteful. If you base your naming convention on Intellisense, you've already lost. If you need Inte

Re: Converting an old FPW 2.6 to VFP 9.0

2011-10-18 Thread Alan Bourke
On Tuesday, October 18, 2011 2:53 AM, "Michael Madigan" wrote: > Will it compile as-in in VFP 9?    > > What I meant was - it might be less hassle to leave it as it is now if the customer doesn't want to pay to bring it up to VFP9 properly. You would at the very least have to run it through t

Re: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 6:41 AM, MB Software Solutions, LLC wrote: > On 10/18/2011 7:28 AM, Stephen Russell wrote: >> On Tue, Oct 18, 2011 at 3:00 AM, Thierry Nivelet  wrote: >>> ftp://foxincloud.com/standards.pdf >>> >> -- >> >> Keeping the pollution in plain sight.  Please DO NOT

Re: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-18 Thread MB Software Solutions, LLC
On 10/18/2011 7:28 AM, Stephen Russell wrote: > On Tue, Oct 18, 2011 at 3:00 AM, Thierry Nivelet wrote: >> ftp://foxincloud.com/standards.pdf >> > -- > > Keeping the pollution in plain sight. Please DO NOT EMBED data type > in column name. That is perfect for your variables but i

Re: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-18 Thread Grigore Dolghin
I would add something about PK notation convention. I've seen a lot of "CustomerId", "ProductId" and so on as PK column name. The argument for this was it makes easier to spot the join columns (CustomerId in parent table, CustomerId in child table). Yeah right. In my oppinion, Customer.Id = childt

Re: Data Structure

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 6:05 AM, Eurico Chagas Filho wrote: > Dan > > The data in this free table, "comanda", will be saved into my data structure > already in place. > This will happen when the customer pays and is using a card. > If I delete the record, i can use an autoinc primary key and sear

Re: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 3:00 AM, Thierry Nivelet wrote: > ftp://foxincloud.com/standards.pdf > -- Keeping the pollution in plain sight. Please DO NOT EMBED data type in column name. That is perfect for your variables but it is wasteful in column names. It makes for long searche

Re: Data Structure

2011-10-18 Thread Eurico Chagas Filho
Dan The data in this free table, "comanda", will be saved into my data structure already in place. This will happen when the customer pays and is using a card. If I delete the record, i can use an autoinc primary key and search for the card #( regular index), no need for a composite key. Then ev

Re: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-18 Thread Malcolm Greene
> ftp://foxincloud.com/standards.pdf Thanks Thierry! Malcolm ___ 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

Re: Converting an old FPW 2.6 to VFP 9.0

2011-10-18 Thread Michael Madigan
Will it compile as-in in VFP 9?    From: Alan Bourke To: profox@leafe.com Sent: Tuesday, October 18, 2011 5:34 AM Subject: Re: Converting an old FPW 2.6 to VFP 9.0 On Monday, October 17, 2011 1:28 PM, "Michael Madigan" wrote: > Re-writing this > program from

Re: Converting an old FPW 2.6 to VFP 9.0

2011-10-18 Thread Alan Bourke
On Monday, October 17, 2011 1:28 PM, "Michael Madigan" wrote: > Re-writing this > program from scratch is not an option.  > Is leaving it as is an option then ? Because that might be easier. -- Alan Bourke alanpbourke (at) fastmail (dot) fm _

Re: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-18 Thread Thierry Nivelet
ftp://foxincloud.com/standards.pdf thn Le 16/10/11 14:53, Malcolm Greene a écrit : > Has anyone published guidelines on table and column naming > conventions/abbreviations? > > I'm talking about conventions for primary and foriegn keys, > surrogate keys, natural keys, and common column names such