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 as

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 mmadi10...@yahoo.com 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: 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 alanpbou...@fastmail.fm 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

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

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 t...@zenbuyer.com 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

Re: Data Structure

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 6:05 AM, Eurico Chagas Filho e28cha...@yahoo.com.br 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

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 =

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 Nivelett...@zenbuyer.com 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

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 mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 10/18/2011 7:28 AM, Stephen Russell wrote: On Tue, Oct 18, 2011 at 3:00 AM, Thierry Nivelett...@zenbuyer.com  wrote: ftp://foxincloud.com/standards.pdf --

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 mmadi10...@yahoo.com 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

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

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 e...@leafe.com 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

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

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 alanpbou...@fastmail.fm wrote: On Tuesday, October 18, 2011 2:53 AM, Michael Madigan mmadi10...@yahoo.com 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

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 paulroberth...@gmail.com 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

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 srussell...@gmail.com 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

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

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 alanpbou...@fastmail.fm wrote: On Tuesday, October 18, 2011 7:50 AM, Stephen Russell srussell...@gmail.com wrote: I like the easy find capabilities in intellisence myself.  I have worked with a lot of Oracle minded data developers so having a

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,

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

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 your

[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

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

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

Re: VFP9: Oracle ODBC (11g)

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 2:09 PM, Desmond Lloyd desmond.ll...@gmail.com 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

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 srussell...@gmail.com wrote: On Tue, Oct 18, 2011 at 2:09 PM, Desmond Lloyd desmond.ll...@gmail.com wrote: Good Afternoon,

Re: VFP9: Oracle ODBC (11g)

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 3:06 PM, Desmond Lloyd desmond.ll...@gmail.com 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.

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 srussell...@gmail.com wrote:

Re: VFP9: Oracle ODBC (11g)

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 3:36 PM, Desmond Lloyd desmond.ll...@gmail.com 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-)

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 desmond.ll...@gmail.comwrote: Good Afternoon, Have just spent almost 1 hour digging

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

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/

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 Boer

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. You can

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 mat...@mckweb.com wrote: Hi Mike Thanks for trying to help but I'm completely lost Please bear in

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 and

Re: VFP 2 MySql

2011-10-18 Thread Stephen Russell
On Tue, Oct 18, 2011 at 5:54 PM, Sytze de Boer sytze.k...@gmail.com 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

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

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:

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 the

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: {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]

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 Boersytze.k...@gmail.com 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

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