Re: autoincremental values

2008-09-25 Thread Gérard Lochon
- Original Message - From: "Rafael Copquin" <[EMAIL PROTECTED]> To: Sent: Wednesday, September 24, 2008 4:24 PM Subject: Re: autoincremental values > > Further to the below, I just discovered that in reality, it is the second > autoinc field that getautoincvalue() takes its value from.

Re: Numeric overflow

2008-09-29 Thread Gérard Lochon
> REPLACE AMOUNT WITH 100*10, SUMTHING else with 7890 > I get error 39 > How can I tell programatically that it is AMOUNT which is now ** > > OR > mam =1 > xmam=0 > replace amount with MAM/XMAM, SUMTHING else with 7890 > I get error 39 > How can I tell programatically that it is

Re: Numeric overflow

2008-09-29 Thread Gérard Lochon
... to test each of them. overflow => (asc(str(yourfield))) = 42 G. ___ 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/profox

Re: Calculating text width

2008-09-29 Thread Gérard Lochon
> However the expression > txtwidth("Period","Tahoma",8)*FontMetric(6,"Tahoma",8) returns 30. > > Is there a way to more accurately calculate the width of the label ? wIth txtwidth(REPL("Period",1000),"myfont",8)*FontMetric(6,"myfont",8)/1000 && you"ll get better precision (if not an exotic fon

Re: Calculating text width

2008-09-29 Thread Gérard Lochon
> > I don't necessarily consider one or the other to be "more correct" - but I > would like a way of calculating the width in such a way that the result is > consistent with what AutoSize yields ... Are you ready to reverse compile VFP ? ;o) ___

Re: VFP9SP1 Error 1705 access denied when running INDEX on MyDateFld tag MyDateFld

2008-09-30 Thread Gérard Lochon
> > INDEX ON Transdate TAG Transdate Do you get the same error with INDEX ON DTOS(Transdate) TAG Transdate Gérard. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this l

Re: Disable Mouse When A Form Is Visible

2008-10-03 Thread Gérard Lochon
> My smartass suggestion: display a messagebox: > > "Press Okay once you've unplugged the mouse". > > :) I agree with this opinion. Think about another problem : the computer may have some physical problem with the keyboard ... how the user will be able to finish / save its work if the mouse i

Re: Disable Mouse When A Form Is Visible

2008-10-03 Thread Gérard Lochon
- Original Message - From: "Jack Skelley" <[EMAIL PROTECTED]> To: Sent: Friday, October 03, 2008 3:24 PM Subject: RE: Disable Mouse When A Form Is Visible Gerard: I don't want to disable the mouse permanently only when the send email form is visible. As soon as the mail is sent enable

Re: VFP9 Job Opportunity Available immediately

2008-10-22 Thread Gérard Lochon
> > If interested, give me a call at 415-578-4496 or email me directly at I guess that's a good job for me. Is there any suburb train from Paris, France ? :o) Santa Cloose Gérard. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance

Re: VFP9 Job Opportunity Available immediately

2008-10-22 Thread Gérard Lochon
> > What happened to the last guy? Pll !! ___ 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: h

Re: Comparing 2 tables and showing differences between them

2011-08-11 Thread Gérard Lochon
> > Does anyone know if a tool exists to do this? Basically we want to compare > table structures and data differences with the ability to move the correct > data to the final production tables. > Have you got equal primary keys in the two tables ? _

Re: DIR command output????

2011-08-11 Thread Gérard Lochon
> > > Has anyone developed a better DIR command for VFP Just look at ADIR() function ! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailm

Re: Formula to Round to Closest Half Dollar

2011-08-20 Thread Gérard Lochon
> Jerry > How about > x= IIF(x+.5> INT(x),INT(x+.5),INT(x)) > Jack > if x > 0, x >= INT(x) => x+.5 >= INT(x) So IIF(x+.5> INT(x),INT(x+.5),INT(x)) will always return INT(x+.5) !! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: htt

Re: "Access Denied" on ERASE for Closed DBF File on Server

2011-09-02 Thread Gérard Lochon
Inside vfp : Maybe a fopen() is pending somewhere (cause you don't CLOSE ALL but only CLOSE DATA/TABLE) Outside vfp : Maybe the .DBF is opened by Excel, Open Office, ... Gérard. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http:/

Re: VFP9SP2 - Error 2066: Index file "z:\data\costs.cdx" tag"Njobid"iscorrupted. Please rebuild it.

2011-09-07 Thread Gérard Lochon
> > Heck, I'd be tempted to do my own ZAP routine before going the DELETE ALL > / > PACK route... > > Function myzap > parameter cTbl2Zap > LOCAL cDataDir > cDataDir = addbs(justpath(dbc())) > > select (cTbl2Zap) > copy structure to (cDataDir + cTbl2Zap + "_tmpthing") database (dbc()) > with CDX

Re: Steve Jobs Dies

2011-10-11 Thread Gérard Lochon
The media don't speak about Lisa ... ___ 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.

Re: [OT] Store refuses $32 in quarters.

2011-11-03 Thread Gérard Lochon
> What kind of dumbass turns away a paying customer? In France, the store can refuse if you pay by giving more than 50 coins (whatever are the coins values). ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailma

wizard.fll

2011-11-16 Thread Gérard Lochon
Hello. Has someone any detailed information about wizard.fll functions and their parameters? Gérard. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox

Re: VFP and Least Squared Regression

2011-11-29 Thread Gérard Lochon
> Anyone know of a VFP friendly Least Square Regression Routine? Free is > good. > If you want the coefficients of a regression line : CREATE CURSOR test (xi n(4),yi n(4)) INSERT INTO test VALUES (1,180) INSERT INTO test VALUES (2,182) INSERT INTO test VALUES (3,187) INSERT INTO test VALUES

Re: VFP record locking

2011-11-29 Thread Gérard Lochon
>> >> If your files are on a server running Windows Server the Admin can look >> at a file, see who has a lock on it, and remove any he/she wishes. I >> believe this capability is restricted to Windows Server. > > If your files are on a Samba server you can easily find out who has what > locks o

Re: [OT] If you think the Volt is impractical . . .

2011-11-29 Thread Gérard Lochon
> > The "companies", of course, share a name. Swiss Air, Swiss Rail, and > Swiss Post. What a coincidence! So you multiply by 3 the risk of loosing your luggage ... :o))) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leaf

Re: Vfp and counter

2011-12-05 Thread Gérard Lochon
> That will show you a WAIT WINDOW every 100 rows processed. > > Fred Optimization ... It is not necessary to waste time testing at each turn the value of m.done : here is an alternate one using nested loops. [VFP] m.todo = " of "+TRANSFORM(RECCOUNT())+" ..." m.odom = 100 GO TOP SCAN REST

Re: Alternatives to storing a user's password in your database

2011-12-21 Thread Gérard Lochon
> I defy anyone to recover the password from the stored value :-). There is a big risk of collision using your method. As the result set is composed of only 65128 different values, it doesn't take a long time to input in the routine a string whose result will be the same value as the stored one

Re: Alternatives to storing a user's password in your database

2011-12-21 Thread Gérard Lochon
From: "MB Software Solutions >>> I defy anyone to recover the password from the stored value :-). >> >> >> There is a big risk of collision using your method. >> As the result set is composed of only 65128 different values, >> it doesn't take a long time to input in the routine a string whose resu

Re: Alternatives to storing a user's password in your database

2011-12-21 Thread Gérard Lochon
> - Original Message - > From: "John Weller" > Could you explain why there can only be 65128 different values? At the first turn , you have 256 seeding possibilities. You randomize. Then you multiply this value (between 0 and 1) by an ascii code (between 0 and 255), then take the in

Re: Happy New Year!

2011-12-31 Thread Gérard Lochon
I would also add my best wishes to our whole community for the New Year. Cautiously, i would say that i only hope it brings more solutions than it offers problems ;o) Gérard. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://l

Re: [NF] Anders Altberg

2008-07-01 Thread Gérard Lochon
> LOL! No, but someone recently had mentioned him. Glad to see he's > still involved in the Fox community (albeit on Foxite instead of here). He's also still active in our french community, AtoutFox. Gérard. Analysé par G DATA AVK Version : AVK 18.4340 de 01.07.2008 Information

Re: [OT] My life gets crazier

2008-07-13 Thread Gérard Lochon
> > How do you value 30-foot cedar trees? Can you even buy one if you wanted > one? And what about the depreciation if you want to sell the house ? Analysé par G DATA AVK Version : AVK 18.4484 de 14.07.2008 Informations sur les virus : www.antiviruslab.com

Re: VFP9 - sorting

2008-07-14 Thread Gérard Lochon
> I have a table which amongst other things has a field called salespers and > salesrev > I want to print the report in salesperson order, then salesrevenue > The sales person gose from 1 to 999 > How do I sort or index this table so that salespeople go from 1 to 999 but > sales from highest to low

[OT] Ning socail network

2008-07-23 Thread Gérard Lochon
Hello guys. I need to create a ning-based site (containing some important data), but i don't know if security issues are important. Have anyone of you some experience about ning development ? Gérard. Analysé par G DATA AVK Version : AVK 18.4615 de 24.07.2008 Informations sur les

Re: VFP9-Internal messages

2008-07-24 Thread Gérard Lochon
>> > I use a method in my Doctor's program. Basically, to send a message, > you type in a screen, choose the doctor, and hit send. It them puts a > record in a file. All programs have a timer that periodically queries > the file, and if a message is to you, changes an icon in your system > tray

Re: Suggestions for a text editor that opens files > 2G?

2008-08-15 Thread Gérard Lochon
http://www.contexteditor.org/features.html Analysé par G DATA AVK Version : AVK 18.5007 de 16.08.2008 Informations sur les virus : www.antiviruslab.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/ma

Re: [OT] How to Un-MP3 an Audio File?

2008-08-18 Thread Gérard Lochon
Hello all of you. I don't know anything about "SD". What kind of file is it ? If you don't have to use a reader (like mp3 one), how do you read the file ? Is it direct audio card adressing ? Gérard. >> >> > Downloaded some MP3 files and need to burn them to SD's such that an >> > MP3 >> > play

SQL VFP6 Integer

2008-08-25 Thread Gérard Lochon
Hello guys. My mind is out my brain today, so i don't scope a simple solution for a simple problem : I don't remember how to create a new column containing an integer only using a select statement. i.e : select space(4) as myfield,* from toto && will create a add field, with four space char

Re: SQL VFP6 Integer

2008-08-25 Thread Gérard Lochon
> select as intcolumn from yourtable into cursor yourcursor That was i thought. But no, it returns a N(12) field ! I tried also int (2**32-2**32) but => N(15) Gérard. Analysé par G DATA AVK Version : AVK 19.108 de 25.08.2008 Informations sur les virus : www.antivirus

[OT] Obama vs Mc Cain (from outer)

2008-08-25 Thread Gérard Lochon
I'm hearing and reading a lot of things about your presidentials. (Conceive that we are very attentive to what's happenig in your country). And i'm asking myself : what do american people really want to choose ? A good president or a good candidate ? Is there a possible good president within the

Re: [SOLVED] SQL VFP6 Integer

2008-08-25 Thread Gérard Lochon
Thanks Gianni. (our fiend Jean Maurice was telling me the same thing privately). Finally ... i knew it, but i forgot it. Do you know that's the christian name of Alzheimer ? No ? Hmmm ... it begins like that :o) Gérard. P.S. The response was Aloïs. Haha ! Analysé par G DAT

Re: [OT] Clintons get caught planning assasination of Obama

2008-08-26 Thread Gérard Lochon
> You must be rather surprised.. Hacked by a government agency ? ... :o)) Analysé par G DATA AVK Version : AVK 19.119 de 26.08.2008 Informations sur les virus : www.antiviruslab.com ___ Post Messages to: ProFox@leafe.com Sub

Re: [NF] Downloading speed

2008-09-14 Thread Gérard Lochon
> The Hp downloads files from the internet about 10 times faster then > the Toshiba. Using the broadband, Toshiba downloads at 30 Kb/s > and the HP 300 Kb/s. > Any hints ? It is the processor, the bus, the HD, what ? Have you the same antivir ? What are the threads running on the two machines whil

To be or not to be [OT]

2008-09-17 Thread Gérard Lochon
Hello. Did someone post anything not [OT] since 2 says ? I can just receive OT ones ... i changed for a new PC with Vista :o) Gérard. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- __

Re: [NF] Windows Scripting and/or Windows Scheduled Tasks problem

2010-02-22 Thread Gérard Lochon
> ... All of the CMD.EXE commands will work with UNC paths. And if you put 1 in HKEY_CURRENT_USER\Software\Microsoft\Command Processor\DisableUNCCheck ? Gérard. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mail

Re: Google: Desktops Will Be Irrelevant In Three Years

2010-03-04 Thread Gérard Lochon
> > > Have you seen this article, "Google: Desktops Will Be Irrelevant In Three > Years"? > http://www.huffingtonpost.com/2010/03/04/google-desktops-will-be-i_n_485415. > html Error 404 ! ___ Post Messages to: ProFox@leafe.com Subscription Maint

Re: [OT] Island succumbs to rising oceans

2010-03-27 Thread Gérard Lochon
You know about Archimède, buoyancy, and so on. Practical application : you put an ice cube in a glass, then fill the glass of water. When the ice has melted, does the glass overflow ? So, how can melting ice in the sea submerge as much lands as heard nowadays ? Gérard. _

Re: [OT] Island succumbs to rising oceans

2010-03-27 Thread Gérard Lochon
- Original Message - From: "Ricardo Aráoz" To: "ProFox Email List" Sent: Saturday, March 27, 2010 1:13 PM Subject: Re: [OT] Island succumbs to rising oceans Gérard Lochon wrote: > You know about Archimède, buoyancy, and so on. > > Practical applicati

Re: [OT] Island succumbs to rising oceans

2010-03-27 Thread Gérard Lochon
> However, he makes a good point, how much of the melt actually goes to the > sea and how much remains in lakes And we must also consider the evaporation cycle on land (and over the sea, which also decrease the desalinization). If temperature grows, evaporation too ... Gérard. ___

Re: "Locate File" errors

2010-04-09 Thread Gérard Lochon
Pattern design ... in case of inexecution : An encapsulating handler is a way for trying to avoid miscelleanous underlying errors (from vfp, or as a discriminating tool between OS/vfp). First, create, build and compile exe as standalone a little prg, "a launcher app" whose exclusive work is to

Re: kaspersky

2010-04-14 Thread Gérard Lochon
> > Hi Foxgang > Anyone using kaspersky. A client is having read only problems with the new > version and dbf's. Anyone know where to turn off the dbf check? > Al Effectivly, Kaspersky is known about that kind of 'sometimes' issues (from my own, in western Europe, using VFP9/SP2 under W7/64).

Re: kaspersky

2010-04-15 Thread Gérard Lochon
> > I agree and it's a shame because it used to be good. Years ago ! They were pioneers developing heuristic behaviour, and so on. But their original technology has been re-used by many others, successfully, with increase of performances. I especially could mention AVK (a product from the G-Da

Re: kaspersky

2010-04-15 Thread Gérard Lochon
> > Did you think the same way about seatbelt? EJECT !! (foxpro command) :o))) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinf

Re: Statistical question for VFP data -- determining "Other" group

2010-04-26 Thread Gérard Lochon
There are cultural affectors about that kind of problem, and also technical ones. For example, in France, if you put-in-your-face a chart with more than 12 quarters, ... plop ! will say the (common) brain ... ... elsewhere, if the readers are tax accountants, under 40 quarters, your job will

Re: Statistical question for VFP data -- determining "Other" group

2010-04-26 Thread Gérard Lochon
> If < 1/5, i aggregate. If not, i maintain the value as individualy > 'printable'. > That is not true if i must deal with the government budget data (and i had to do so years ago). It was then 1/100, but there' so weird ... Gérard. ___ Post

Re: Statistical question for VFP data -- determining "Other" group

2010-04-26 Thread Gérard Lochon
> > I was thinking of a spinner control on screen that allows them to > determine the magic cutoff number for inclusion into the "Other" group. > That way, they have the power. Two issues : - if a category must be considered whatever is its score ... look at my other post. - if 'other' group i

Re: Statistical question for VFP data -- determining "Other" group

2010-04-27 Thread Gérard Lochon
> I'll have a checkbox option (or just set that setting to 0 to not lump > any categories/counts into Other) giving them complete control to have > it either way. Pretty good. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: Statistical question for VFP data -- determining "Other" group

2010-04-27 Thread Gérard Lochon
> > >> I'll have a checkbox option (or just set that setting to 0 to not lump >> any categories/counts into Other) giving them complete control to have >> it either way. You could also create a table describing groups (list of categories), each one having a triggering level for aggregation. The

Re: *** SPAM ***[OT] Chinese accused of vast trade in organs

2010-04-28 Thread Gérard Lochon
An old S-F novel (i don't remember nor the title neither the author) i read in past 70's introduced a vision of society based upon the total control of recycled organs (to permit to save live and prolongate it). Because of a lack of human organs donations (humanity becoming then very numerous

Re: *** SPAM ***[OT] Chinese accused of vast trade in organs

2010-04-28 Thread Gérard Lochon
> Don't know if you ever saw that movie demolition man, but we seem to be > breaking into the haves and the have nots similar to that movie. > and then the unit mentioned the other day where they could automatically > inject you for medical purposes. No, i didn't see that movie (but i'll try to

Re: [OT] Drill, Baby, Drill!

2010-04-29 Thread Gérard Lochon
Heard a few minutes ago, from a Brussels' one : - Well, actually, the oil slick drifting on the water is as big as Belgium. You America, could you split it between Walloons oil and Flemings oil ? :o) Gérard. ___ Post Messages to: ProFox@leafe

Re: Query Fails Under VFP9...

2010-05-07 Thread Gérard Lochon
> > Slight correction: VFP has dynamically-typed variables, versus the static > types common in compiled languages. However, VFP variables are also > strongly-typed, meaning that it will not do assumed coercion, such as > Javascript does (e.g., "Fred" + 42 is perfectly legal in Javascript). > >

Re: [NF] Context Menu

2019-04-22 Thread Gérard LOCHON
Hello. It's not in Settings/Update & Security/Windows Defender ... Where or how do you see these two options ? Gérard. On 20/04/2019 20:39, Charles Hart Enzer, M.D. wrote: I am on WIN 10 64bit Pro Version 1803 The popup menu has two [Scan with Windows Defender]s - One pops up a CMD wi

Re: [NF] Context Menu

2019-04-22 Thread Gérard LOCHON
Aliyah: Cincinnati to Jerusalem's German Colony May, 2017 Volunteer Associate Professor of Psychiatry University of Cincinnati Medical Center WebSite: http://EnzerMD.com Tiny Country, Huge Dreams מדינה זעירה, חלומות ענקיים עם ישראל חי On Mon, Apr 22, 2019, 14:04 Gérard LOCHON wrote: Hello.

Re: [NF] Search String

2019-08-13 Thread Gérard LOCHON
Hello. Using the windows command prompt, you can : dir "/[the_search_root_path]/*.*" /s /b /A-d | find /V "/[the_path_you_want_to_exclude]/" > /[your_output_text_file] /Gérard./ / On 13/08/2019 10:08, Charles Hart Enzer, M.D. wrote: I need a Search String: - All Documents in OTHER DIRE

Re: [NF] Search String

2019-08-13 Thread Gérard LOCHON
A directory based file structure is a tree structure. There is no implied way to unfold a tree structure without recurse. And recurse is not a one-level action. So it cannot exist a file skeleton, acting on a solely level, to impact other levels. Gérard. On 13/08/2019 13:26, Richard Kaye wrote

Re: Another refactoring question regarding unused columns in a DBF table

2019-10-02 Thread Gérard LOCHON
Hello. You must keep in mind that renaming the fields is the same as dropping them : if there is a risk of use, you'll get an error. So the only problem, if you drop them, is to remember the genuine fields names and indexes : why don't you simply make an empty copy of the dbf to trace them ?

Re: {NF] WIN 10 and LibreOffice

2019-12-10 Thread Gérard LOCHON
Hello. I use Version: 6.3.2.2 (x64) with no problem. Gérard. On 10/12/2019 07:12, Charles Hart Enzer, M.D. wrote: Perhaps the problem is my mounting on F: C: is an SSD drive Shai / שי Charles Hart Enzer, MD(Ohio, USA), FAACAP Aliyah: Cincinnati to Jerusalem's German Colony May, 2017 Vol

Re: The Y2K Bug Returns: Revenge of the Kludge

2020-01-08 Thread Gérard LOCHON
Hello. It is always reassuring to think that software developers did not even think that their work would survive them ... Happy new bug ! Gérard. Le 08/01/2020 à 17:35, Christof Wollenhaupt a écrit : https://www.zdnet.com/article/the-y2k-bug-is-back-causing-headaches-for-developers-again/

Re: [NF] X# Summit

2020-02-08 Thread Gérard LOCHON
Why not plan the conference in France ? Gérard. Le 06/02/2020 à 14:39, Johan Nel a écrit : Hi all, October is going to be a busy month it seems.  The X# team plan a conference in Germany for those who cannot make it to SWFOX. https://www.xsharp.info/articles/x-summit-2020 Johan Nel George

Re: *** SPAM *** [NF] Monitor Christmas

2020-03-27 Thread Gérard LOCHON
Hello. Just something that works for a very long time without having to deal with it. Uh, that was just what about VFP was created, isnt'it  ? ;o) Best regards. Gérard. Le 27/03/2020 à 15:12, MB Software Solutions, LLC a écrit : Well, given this "work from home" thing is happening all the

Re: *** SPAM *** Re: [NF] Monitor Christmas

2020-03-27 Thread Gérard LOCHON
[utterly sexist and totally unacceptable]     I'id rather prefer a VaryWoman, 1 bit version. [/utterly sexist and totally unacceptable] :o))) Gérard. Le 27/03/2020 à 15:40, Eric Selje a écrit : A better chair. A Varidesk. --- StripMime Report -- processed MIME parts --- multipart/alt

Re: SQL sum

2017-04-21 Thread Gérard LOCHON
Le 21/04/2017 à 16:46, mbsoftwaresoluti...@mbsoftwaresolutions.com a écrit : On 2017-04-20 09:43, Jean MAURICE wrote: True tip, Jean is right. it's always a bad solution trying to get a minus backtime profit while not having a development analysis cursum. ___

Searching among the ghosts of the night

2017-05-13 Thread Gérard LOCHON
Hello gang. I can't find out my VFP9's install CD ; it is probably somewhere, covered by centennial dust. Has anyone a (true) link where i can download richtx32.ocx ? (i need it for a little app). Thanks by advance. Gérard. ___ Post Messages to

Re: Searching among the ghosts of the night

2017-05-13 Thread Gérard LOCHON
esent, but your real and personal feeling. It's yours now, take the microphone ! G. Le 13/05/2017 à 15:05, Jan Bucek a écrit : Dne 13.5.2017 v 14:09 Gérard LOCHON napsal(a): Hello gang. I can't find out my VFP9's install CD ; it is probably somewhere, covered by centennial d

Re: *** SPAM *** [NF] iDrive Errors

2017-05-13 Thread Gérard LOCHON
As media are currently talking about, a global attack is currently being carried out against all shared data sites. Dont't worry about local uses, and try to extricate you from the global network. Don't make new backups, they may be infected. G. Le 12/05/2017 à 23:49, Charles Hart Enzer,

Re: Appending from a CSV file with CR embedded in fields

2012-02-10 Thread Gérard Lochon
>On Fri, Feb 10, 2012 at 2:01 PM, Joe Yoder wrote: > I am writing code to interface with Google Apps contact information > exported to a CSV file. The formatted address fields in the CSV file > include carriage returns to >separate the individual lines. When I do an > "append from Google~1.csv

Re: SQL prob

2012-02-12 Thread Gérard Lochon
> From: "Jean MAURICE" > Andrew, I don not think that a where clause can work on a calculated > field. So > the correct query is somthing like : > > > SELECT ; >IIF(EMPTY(natno) OR ninoconfirm = .f.,.t.,.F.) as choose, ; >natno, ; >ninoconfirm , ; >surname ; >FROM calcpay!

Re: Importing files > 2GB

2012-02-22 Thread Gérard Lochon
> I was thinking about saving to a CSV file again and then inserting into > the MySQL table from that, with the fields fixed that had issue prior. > If wasting time is not a problem, you can use a loop to split the input file into multiple cursors, then use them your way out : [VFP] *** creati

Re: [NF] why learn how a new M$ product could be better

2012-03-06 Thread Gérard Lochon
- Original Message - From: "MB Software Solutions,LLC" > And cue Thierry Nievlet's comments on Fox-In-Cloud :-) Thierry NIVELET. Nievlet sound like a soviet spy in the cloud ... ___ Post Messages to: ProFox@leafe.com Subscription Ma

Re: Are NESTED LOCATED Allowed?

2012-04-21 Thread Gérard Lochon
- Original Message - From: "Kurt Wendt" Could you explain to me how this can work : > > SELECT EDIHDR > SCAN > xCurrCUSTPO = CUSTPO > xCurrORDER = ORDER > SELECT OrderHdr > IF !SEEK('TARGE'+xCurrCUSTPO) > LOOP > ENDIF > SCAN REST FOR account+custpo+order = 'TARGE'+xCurrCUSTPO***

Re: [NF] Program the car/truck computer for safety

2012-04-30 Thread Gérard Lochon
> You may joke on Breathalysers but its heading that way. From July, in > France > you must carry two of them in the car. In fact, the coming french law says that we must have one breathalyser unused in the car. But how many of them must i really have ? If i drink, i must use the breathalyser

Re: VFP9 SP2 + W7-64 + toolbar

2012-05-29 Thread Gérard Lochon
From: "Jean MAURICE" > So Aero is not for tomorrow neither after-tomorrow ;-) He prefers Rail - o ... :o))) Gérard. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this l

Re: [NF] Is there a script or program that will remove all known games on a pc?

2012-06-13 Thread Gérard Lochon
There IS a solution : recovery, if you did a backup just before the good instant ! Another way is to have a strategy before installing any software : don't install directly, go through a script (even DOS made) able to trace what you are doing. And, you know, computer is no way for Alzheimer's

Re: [NF] Is there a script or program that will remove all known games on a pc?

2012-06-14 Thread Gérard Lochon
- Original Message - From: "Alan Bourke" > Is there company policy around it? You might be better with a solution > that allows you to remotely monitor installations, and make it known > that you have it. Absolutely. It is also easy using Windows (please don't laugh) to prevent many thi

Re: [NF] Legal keylogger

2012-06-14 Thread Gérard Lochon
- Original Message - From: "Michael Madigan" To: "ProFox Email List" Sent: Thursday, June 14, 2012 10:06 AM Subject: Re: [NF] Legal keylogger > How does making someone work for the hours that they are paid considered > "slavery"? That'a a real question. Who decides what salary is suf

Re: Remember when 2GB seemed like a lot for a table ...

2012-06-14 Thread Gérard Lochon
- Original Message - From: "Alan Bourke" > > "A benchmarking machine using 4,000 processor cores and 100TB of DRAM > has given a 600 millisecond data response time querying a 500TB > database" > > The answer is 42. Silly to ask for such a result : no one can debug the result line

Re: Remember when 2GB seemed like a lot for a table ...

2012-06-14 Thread Gérard Lochon
- Original Message - From: "Allen" > Now they just need to know what the question was This will require at least five IT consultants working during 6000 * 4000 * 500 * 1024 *1024 *1024 milliseconds ! Why five ? A supervisor, a senior, and a three Hamming-type progammers team ... Th

Re: Remember when 2GB seemed like a lot for a table ...

2012-06-14 Thread Gérard Lochon
- Original Message - From: "MB Software Solutions,LLC" >> PS : Anal Tuning neither has a solution ... >> >> /me i sack off ... > Is that like fapping? lol Sorry, i don't understand this idiom (and Google's translating tool is NOT my friend) What is fapping ? ... Does it smells goo

Re: [NF] Ignorance and Science

2012-06-22 Thread Gérard Lochon
> From: "Michael Madigan" > It amazes me how many scientists are closed minded. > They start with a premise and ignore all the contrary data. I don't think so. When physicists are stuck somewhere, they ask mathematicians finding new theoretical tools to overcome their contradictions. (i.e. previo

Re: [NF] Ignorance and Science

2012-06-22 Thread Gérard Lochon
I.E : (to match my opponents opinion) Have you heard about Ygor and Grichka Bogdanoff's (friends of mine) "Beyond the Big Bang" theory ? When you're plugged into the average scientist society (lol), the matter isn't to know if this theory is valuable, but if Ygor anf Grichka have any right to pre

Re: [OT] - 10 reasons to ban gay weddings..

2012-06-22 Thread Gérard Lochon
- Original Message - From: "Adam Buckland" To: Sent: Thursday, June 21, 2012 10:20 PM Subject: [OT] - 10 reasons to ban gay weddings.. > Top ten reasons given to ban same-sex marriages:- > 1) Being gay is not natural. Real Americans always reject unnatural things > like eyeglasses, po

[OT] Have you heard about that ? No ? Hmmm, it's because you're too late ...

2012-07-07 Thread Gérard Lochon
http://www.tomsguide.fr/actualite/Livre-Efface-Video,4115.html We should apply this to new laws and incoming bills ... :o))) Gérard. PS : in the fantasmatic way, why not give to clients auto-erasing code ? it could be more efficient than a DRM ... --- StripMime Report -- processed MIME parts -

Months later ... i have an SQL soluce for "what is the rank of this data in an index order?"

2012-07-10 Thread Gérard Lochon
Hello guys. I was reading a lot of 'old threads', before deleting them from my computer. And i came across this one, which answers did not satisfy me : -- -

Re: Months later ... i have an SQL soluce for "what is the rank ofthis data in an index order?"

2012-07-10 Thread Gérard Lochon
>- Original Message - >From: "Jean MAURICE" >To: >Sent: Tuesday, July 10, 2012 3:25 PM >Subject: Re: Months later ... i have an SQL soluce for "what is the rank >ofthis data in an index order?" > >oh my god !! > > >I would never dare use a SELECT in a FROM clause of a SELECT statement

Re: Months later ... i have an SQL soluce for "what is the rank ofthis data in an index order?"

2012-07-10 Thread Gérard Lochon
> > Is there any value to know the location # from BOF(), and if there is > why is closer better depending on index? Grmbl grmbl grmbl ... Let me put my fingers out of my *not so soft* holidays' best drink, (pastis 51), and i'll next find out a *f**ing* solution, if my *suck...g* wife don't make

Re: Months later ... i have an SQL soluce for "what is the rank ofthis data in an index order?"

2012-07-10 Thread Gérard Lochon
- Original Message - > > Is there any value to know the location # from BOF(), and if there is > why is closer better depending on index? BOF() is an XBase iterative function, nothing to do witrh SQL ensembly conceipt. Somewhere, excluding it. However; it is always possible to replace

Re: report problem

2012-07-10 Thread Gérard Lochon
- Original Message - From: "carol" To: "'ProFox Email List'" Sent: Tuesday, July 10, 2012 6:00 PM Subject: report problem > I write specifications, do testing and handle tech support for several VFP > 9 applications. My programmer is on vacation and I have an irrate user > who > can'

Re: Months later ... i have an SQL soluce for "what is the rankofthis data in an index order?"

2012-07-10 Thread Gérard Lochon
- Original Message - From: "Stephen Russell" > Does this handle the tie at the #2 rank properly for ranks 3,4&5? I don't understand what you mean. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/lis

Re: test for array

2012-07-12 Thread Gérard Lochon
TYPE("vVar",1) will return 'A' if vVar is an array (and 'C' if it is a collection). Gérard. ___ 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: [OT] pretty funny

2012-07-18 Thread Gérard Lochon
- Original Message - From: "Stephen Russell" To: "ProFox Email List" Sent: Wednesday, July 18, 2012 8:59 PM Subject: [OT] pretty funny > > > I saw it yesterday. Excellent. Based on "Me, Myself, and I" - short st

Re: [NF] Found a Great Backup Program for Windows

2012-07-20 Thread Gérard Lochon
- Original Message - From: "Ken Dibble" To: Sent: Friday, July 20, 2012 3:11 AM Subject: Re: [NF] Found a Great Backup Program for Windows > >>http://www.cobiansoft.com/cobianbackup.htm >> I do use it too (with a business laptop in use at my home) ; it does good job, quick and silent.

Re: [NF] Found a Great Backup Program for Windows

2012-07-20 Thread Gérard Lochon
Gérard may occurs, sorry. ___ 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/archi

Re: [NF] The sky is falling! The sky is falling!

2012-07-20 Thread Gérard Lochon
> > "Microsoft, the once-dominant computer software giant that has seen its > fortunes wane in recent years, posted its first quarterly loss since > emerging as a public company in 1986 Thursday as it took a huge charge > for a failed acquisition." I was born and programming computers before Micr

  1   2   3   >