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

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

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

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

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

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

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. It's

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

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: Searching among the ghosts of the night

2017-05-13 Thread Gérard LOCHON
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 dust. Has anyone a (true) link

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

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.

Re: API to find the size of an entire folder structure?

2016-08-01 Thread Gérard LOCHON
Generally, it's multipurpose Le 02/08/2016 à 00:56, Fernando D. Bozzo a écrit : I think that creating a cursor and is too much for something that only need to sum file lenghts. Can be done with 2 arrays, one needed for ADIR and one for keeping the paths and subtotals.

Re: API to find the size of an entire folder structure?

2016-08-01 Thread Gérard LOCHON
This solution must be corrected, because the path length may exceed the field size limit while recursing thru the directories. Personnaly, i create another cursor to contains the pathnames : Pathes(pkid i, path m) When you start a new subdirectory, you insert it in Pathes cursor, and in

Re: API to find the size of an entire folder structure?

2016-07-30 Thread Gérard LOCHON
There isn't such a thing in the Win API. You have to it by yourself, even if it is in C. Gérard. Le 30/07/2016 à 13:04, Joe Yoder a écrit : Is there a programatic shortcut to finding the size of an entire folder/subfolder structure without recursing through it in VFP? Thanks in advance,

Re: Bad getwordnum

2016-07-29 Thread Gérard LOCHON
If leading and trailing spaces are not significant, instead of ?GETWORDNUM(yourstring,i,',') use : ch = strtran(yourstring,',',' , ') ?allt(GETWORDNUM(ch,i,',') Gérard. Le 29/07/2016 à 08:05, Michael Glassman a écrit : I'm afraid I have to disagree with you, Fernando. The DO WHILE

re: [NF] File Manager for Galaxy S$

2015-07-21 Thread Gérard LOCHON
What kind of files, pictures, videos, ... ? Is there ghosts files (blank pictures) ?         Message du 21/07/15 00:25 De : Charles Hart Enzer, M.D. A : Profox Copie à : Objet : [NF] File Manager for Galaxy S$ The files on my SD card of my Galaxy S4 [OS version 4.4.4.] can no

Re: WANTED: VFP Club Membership System

2015-05-26 Thread Gérard Lochon
And I worked in Horsham for over 10 years... Laurie I went to Tunbridge Wells, 42 years ago (argh ...) with 2 friends during holidays. Nice neighbour, nice people (and nice pubs on the later). How does it looks, nowadays ? Gérard. ___ Post

re: Creating SDF files with the database caption as header names

2015-04-14 Thread Gérard LOCHON
Hello.   A table cannot have more than 10 chars as field name, out of a database.   But ... cursors can !   So, if you first make a select from your table into a cursor, and then copy it to a csv file, you'll get your 10 char field names.   Gérard.         Message du 14/04/15 08:42

Re: Happy New Year!

2015-01-01 Thread Gérard Lochon
Happy New Year, Pro-foxers! Best wishes for a safe, happy, healthy, and prosperous New Year! As old, i prefer to say : Good arthrisis and happy prostate ! And, you kvow, 20/15 isn't a good blood pressure ... :o)) Gérard. ___ Post Messages

Re: SQL select

2014-11-11 Thread Gérard Lochon
I didn't know that we could have a 'group by' clause without any 'agregation field' (SUM(), AVG(), ...). It's why I built a '2 stages' query ... Aggregation is not needed when the only fields mentioned in the group by clause are the same that the selected ones. Gérard.

Re: Character to DateTime

2014-11-04 Thread Gérard Lochon
- Original Message - From: Dennis Schuette den...@cbsds.com Thanks to all for the suggestions. Ended up writing the following function: FUNCTION Text2DTime .. Hello guys. Here is Andy's method, a little compacted : * FUNCTION Text2Dtime PARA x =ALINES(y,LOWER(x),, , )

Re: Installshield merge module for VFP 6 SP5

2014-10-31 Thread Gérard Lochon
Anyone got a copy of VFP6RUN.MSM? It seemed that Micro$oft had removed the download from its original URL -- If it is a part of SP5, you can try to download it from http://www.plunder.com/Visual-Studio-6-0-Service-Pack-5-download-21997.htm

Re: FoxInCloud version 2.10 released

2014-09-30 Thread Gérard Lochon
- Original Message - From: Thierry Nivelet tnive...@foxincloud.com To: ProFox Email List profox@leafe.com Sent: Tuesday, September 30, 2014 5:17 PM Subject: FoxInCloud version 2.10 released More on this news here:

Re: [NF] Programmer's Rosetta Stone

2014-09-13 Thread Gérard Lochon
So, you wrote it ? ;o) - Original Message - From: Adam Buckland adam.buckl...@eurohill.com To: ProFox Email List profox@leafe.com Sent: Saturday, September 13, 2014 8:39 AM Subject: RE: [NF] Programmer's Rosetta Stone Scary just how accurate that is.

Re: [NF] Virtual Machine Need for Antivirus?

2014-09-08 Thread Gérard Lochon
- Original Message - From: Charles Hart Enzer, M.D. cen...@gmail.com To: ProFox Email List profox@leafe.com Sent: Monday, September 08, 2014 4:22 PM Subject: Re: [NF] Virtual Machine Need for Antivirus? Thank you. I have three licenses. I'll do a Google search on VMware and on

Re: [OFF] test

2014-08-20 Thread Gérard Lochon
just for test is this list alive USE profox EXCLUSIVE AS test IF RECCOUNT()0 TRY =post(interesting_message,'test') CATCH to okillfile ENDTRY ELSE WAIT WINDOW I'm a sucker NOWAIT ENDIF ;o) G. ___ Post Messages to:

Re: [OFF] test

2014-08-20 Thread Gérard Lochon
- Original Message - From: Koen Piller koen.pil...@gmail.com To: ProFox Email List profox@leafe.com Sent: Wednesday, August 20, 2014 7:05 PM Subject: Re: [OFF] test test failed, error 1878 Yes, an ALTER ego DROPped the thread. ___ Post

Re: Auto Response

2014-08-04 Thread Gérard Lochon
- Original Message - From: Angelito Curimo ebi_...@yahoo.com Thank you for sending your email, this will be replied later, God Bless... Big Bot is watching us ... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: readmethod()

2014-08-04 Thread Gérard Lochon
- Original Message - From: Jean MAURICE jsm.maur...@wanadoo.fr To: profox@leafe.com Sent: Saturday, August 02, 2014 8:12 AM Subject: Re: readmethod() With FoxCharts is shipped ... ... (first because I am colour blind !). Half a chance, Jean. As told us Sammy Jr, you could be

Re: [NF] Screenshots

2014-07-23 Thread Gérard Lochon
I use PicPick http://portableapps.com/apps/graphics_pictures/picpick-portable Gérard. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Copy DBF that is open

2014-07-03 Thread Gérard Lochon
- Original Message - From: Man-wai Chang chan...@gmail.com To: ProFox Email List profox@leafe.com Sent: Thursday, July 03, 2014 5:32 PM Subject: Re: Copy DBF that is open Just try it and you will know the result! :) My bet: the file would be locked when it's opened by Foxpro (shared

Re: Copy DBF that is open

2014-07-03 Thread Gérard Lochon
- Original Message - From: Man-wai Chang chan...@gmail.com Just try it and you will know the result! :) My bet: the file would be locked when it's opened by Foxpro (shared or exclusive). Adding to this, VFP may have bufferized data somewhere in the memory, and your file then won't

Re: Strange VFP Report Behaviour

2014-07-02 Thread Gérard Lochon
- Original Message - From: Laurie Alvey trukke...@gmail.com I'm running a VFP9 SP2 report (REPORTBEHAVIOR = 90) which has a memo field in the detail band. The control is set to stretch with overflow but does not display all the text - there are only 5 lines and the control ends with

Re: Strange Character in Folder Name

2014-07-02 Thread Gérard Lochon
On Mon, Jun 30, 2014 at 2:01 PM, Lew Schwartz lew1...@gmail.com wrote: I'm writing an app for w8.1 and, somehow or other adir() reports a folder name beginning with chr(138). This seems to be causing explorer to become blind to it, so I can't find the folder to fix it. Any ideas? 1252

Re: Is ASCAN() Really Type-Insensitive?

2014-06-26 Thread Gérard Lochon
- Original Message - From: Ken Dibble krdib...@stny.rr.com To: profox@leafe.com Sent: Thursday, June 26, 2014 4:29 PM Subject: Is ASCAN() Really Type-Insensitive? VFP 9 SP 1 My tests seem to indicate that ASCAN() doesn't care if the type of what you're searching for matches the type

Re: VAT Rates

2014-06-13 Thread Gérard Lochon
- Original Message - From: Paul Hill paulroberth...@gmail.com To: ProFox Email List profox@leafe.com Sent: Thursday, June 12, 2014 7:18 PM Subject: Re: VAT Rates On 12 Jun 2014 16:59, Gérard Lochon g-loc...@wanadoo.fr wrote Tha't the only true way, whatever the country. Except

Re: VAT Rates

2014-06-13 Thread Gérard Lochon
- Original Message - From: Rafael Copquin rcopq...@fibertel.com.ar To: profox@leafe.com Sent: Thursday, June 12, 2014 9:33 PM Subject: Re: VAT Rates Oui monsieur, you are right. When we send the monthly tax return to the tax department, we always indicate the true net and the VAT, and

Re: [ADMIN] World Cup discussions

2014-06-12 Thread Gérard Lochon
- Original Message - From: Ed Leafe ed.le...@rackspace.com As has been the practice for the past few World Cups, please add [WC] to the subject of any posts about the event. These messages will be treated similarly to [OT] messages, and will not be sent to the ProFoxTech list. Is

Re: VAT Rates

2014-06-12 Thread Gérard Lochon
- Original Message - From: Rafael Copquin rcopq...@fibertel.com.ar To: profox@leafe.com Sent: Thursday, June 12, 2014 2:57 PM Subject: Re: VAT Rates FWIW in Argentina VAT is 21% We simply calculate VAT as: net * 0.21 = VAT Gross = net + VAT 'OR Gross = net * 1.21 No, your OR

Re: SQL select Group by datetime field value puzzle

2014-06-10 Thread Gérard Lochon
Now that I have the grouping issue solved I need to combine multiple selects into one cursor. I'll start another thread unless I find the answer right away. Joe 1) As mentioned above, this select retuns an error unless expressed with SET ENGINEBEHAVIOUR 70. Is it a good way to implement

Re: Opening PDFs

2014-06-07 Thread Gérard Lochon
- Original Message - From: Graham Brown grah...@compsys.co.uk To: ProFox Email List profox@leafe.com Sent: Friday, June 06, 2014 4:54 PM Subject: Opening PDFs Hi all One of my clients wants to be able to show a pdf document but disable Save/Email/Print/Copy. This is quite a

Re: DBF Utility?

2014-06-03 Thread Gérard Lochon
I know I should not say this, but ... simply open it with Open Office !! Gérard. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Avast picking up VFP9.exe as virus

2014-06-02 Thread Gérard Lochon
- Original Message - From: Laurie Alvey trukke...@gmail.com To: ProFox Email List profox@leafe.com Sent: Monday, June 02, 2014 3:02 PM Subject: Re: Avast picking up VFP9.exe as virus I've got the latest VFP and the latest Avast - so what's different? It's not Abelian commutative !

Re: file contain field is numeric and data has string (Character).

2014-04-14 Thread Gérard Lochon
- Original Message - From: Naushad Ali Ali naushadm...@gmail.com To: profox@leafe.com Sent: Monday, April 14, 2014 2:46 PM Subject: RE: file contain field is numeric and data has string (Character). I WANT TO MAKE A VARIABLE, SO I CAN REPLACE IN OTHER FILE. THANKS You know, Naushad,

Re: Bad getwordnum

2014-04-13 Thread Gérard Lochon
- Original Message - From: Allen pro...@gatwicksoftware.com I just spotted a nasty. GetWordNum. If you have say aa =A,B,C,,,F and ask for GetWordNum(aa,4,,) it gets it wrong. Seems it cannot handle blanks. A pain as I just had some. Instead of using Getwordnum, split the string in

Re: Printing to a file using question marks

2014-04-03 Thread Gérard Lochon
- Original Message - From: Alan Bourke alanpbou...@fastmail.fm Any number of ways ranging from FPUTS() to my preferred method which would be: set textmerge on noshow set textmerge to myfile.txt \this is my first line \this is my last line set textmerge off set textmerge to Hi gang.

Re: how to simulate a ctrl+clic

2014-04-02 Thread Gérard Lochon
- Original Message - From: Jean MAURICE jsm.maur...@wanadoo.fr To: ProFox Email List profox@leafe.com Sent: Wednesday, April 02, 2014 7:11 AM Subject: how to simulate a ctrl+clic Hi, I have to work on all the pupils in a classroom but one or two. So I built a listbox with the name of

Re: Inserting a date

2014-03-25 Thread Gérard Lochon
- Original Message - From: Jean MAURICE jsm.maur...@wanadoo.fr To: profox@leafe.com Sent: Tuesday, March 25, 2014 9:26 PM Subject: Re: Inserting a date That's right ! I did not think about that ... The Foxil Le 25/03/2014 21:04, Fred Taylor a écrit : Won't work if the insert mode is

Re: [OT] Joke

2014-03-25 Thread Gérard Lochon
- Original Message - From: Stephen Russell srussell...@gmail.com To: ProFox Email List profox@leafe.com Sent: Tuesday, March 25, 2014 10:21 PM Subject: [OT] Joke Stamps anyone? The Postal Service created a stamp with a picture of President Obama on it. The Postal Service noticed

Re: 32-bit BASIC

2014-02-25 Thread Gérard Lochon
From: Jean MAURICE jsm.maur...@wanadoo.fr I did a lot of BASIC on HP9830, VIC20 and WANG 2200 + HPIB : it was long long ago !!! I nearly wrote 'once upon a time ...' !! Me too, on HP9835 and Darlay Computer. Old good time ... ___ Post Messages

Re: clear events

2014-01-21 Thread Gérard Lochon
- Original Message - My understanding of clear events, it will clear events after the current method completes Exactly. To answer to Gene : You are still thinking in a procedural way, your program having to do some things, and after that some other things, as a supervisor. VFP

Re: SQL Insert - Solved

2014-01-03 Thread Gérard Lochon
- Original Message - From: Jeff Johnson j...@san-dc.com To: profoxt...@leafe.com Sent: Friday, January 03, 2014 2:29 PM Subject: Re: SQL Insert - Solved Sorry to bother you guys with this one. I should have known. I expected that records inserted in sequence would be queried in the

Re: SQL Insert - Solved

2014-01-03 Thread Gérard Lochon
- Original Message - That makes sense because I am a very old -very- procedural kind of guy! ;^) I know how you feel, that i'm not a younger one ;o) When i started Foxpro, in earlier 2.0 version, it was -for me- an astonishment ; i used hitherto languages such as assembly or Cobol

Re: Happy new year

2013-12-31 Thread Gérard Lochon
Hello to everyone. Our world will not tilt on its axis during year 2014. So, we'll have to carry on with our GIGO. We are neither gods, nor devils, just humans, and sometimes, brethren. Assuming that, i wish you the best from the best of us and you. Gérard.

Re: [NF] Test ....

2013-12-23 Thread Gérard Lochon
From: Dave Crozier da...@flexipol.co.uk Not received any email over the weekend... test to see if we are still on planet Zog! It's the Santa Claus upgrade 8.1 effect ! ;o) Merry CHristmas to all of you. Gérard. ___ Post Messages to:

Re: Is their a way to turn off some of the intellisense?

2013-11-10 Thread Gérard Lochon
- Original Message - From: Michael Savage msavage...@gmail.com To: Foxpro List profox@leafe.com Sent: Sunday, November 10, 2013 12:14 AM Subject: Is their a way to turn off some of the intellisense? I find the popup for the select (SQL) command most annoying. It often covers what I'm

Re: Malware eating PRGs and SPRs

2013-10-02 Thread Gérard Lochon
- Original Message - From: Christof Wollenhaupt christof.wollenha...@foxpert.com a file, it renames the original, saves the new one, deletes the copy and then renames the new one. When the PRG/SPR files is opened with a read lock by another program (usually a virus scanner or a text

Re: Margins disabled in Report Properties - Page Setup

2013-10-01 Thread Gérard Lochon
- Original Message - From: Dave Crozier da...@flexipol.co.uk To: ProFox Email List profox@leafe.com Sent: Tuesday, October 01, 2013 5:34 PM Subject: RE: Margins disabled in Report Properties - Page Setup Have you enabled the whole page to print out on the print options in the report?

Re: [NF] How Can Passworded Zip Files be Dangerous?

2013-09-24 Thread Gérard Lochon
- Original Message - From: Jean Laeremans laeremans.jeanma...@gmail.com To: ProFox Email List profox@leafe.com Sent: Tuesday, September 24, 2013 3:31 PM Subject: Re: [NF] How Can Passworded Zip Files be Dangerous? On Mon, Sep 23, 2013 at 4:13 PM, Paul Hill paulroberth...@gmail.com

Re: [NF] How Can Passworded Zip Files be Dangerous?

2013-09-23 Thread Gérard Lochon
It was far worse than that. BICS - a major European provider - was targeted. The whole infrastructure was in danger ! Estimated costs of the removal of the malware : 5.000.000 E.. Wow ! That that whole infrastructure was a malware ... ;o)

Re: [NF] AI Chatbot

2013-09-21 Thread Gérard Lochon
Do you know basic? A programming language: Beginner's all-purpose instruction code 10 print hello world Command accepted run output: hello world lol! This AI is quite well done, and i would say pervert. When i ask it to tell me if it knows where i live, by examining my first name, it

Re: [OT] 12 years ago

2013-09-11 Thread Gérard Lochon
As far as I know, I cannot change the text style from html to text or vice versa, and it appears to work fine for everything except for profox??? Ballmer's revenge ? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: color codes

2013-09-06 Thread Gérard Lochon
- Original Message - From: Rafael Copquin rcopq...@fibertel.com.ar To: profoxt...@leafe.com Sent: Wednesday, September 04, 2013 8:49 PM Subject: color codes I need to create a table with color codes. I wonder how are the numbers obtained. I do not want to use the RGB function and

Re: [NF] Client Virtualization

2013-08-23 Thread Gérard Lochon
- Original Message - From: Eurico Chagas Filho e28cha...@yahoo.com.br 2013 4:37 PM Subject: [NF] Client Virtualization I was reading about this and it could mean extension of life for VFP. Can somebody shed some light on this ? Any related links from your readings ?

Re: keypress event and on key labels

2013-08-07 Thread Gérard Lochon
- Original Message - From: Rafael Copquin rcopq...@fibertel.com.ar To: profoxt...@leafe.com Sent: Wednesday, July 31, 2013 12:55 AM Subject: keypress event and on key labels I haven't used on key labels since the days of old FoxDOS. However, I am migrating an old FD app to VFP9 and

Re: SELECT (SQL) Date Range Problem

2013-05-03 Thread Gérard Lochon
- Original Message - From: Jean MAURICE jsm.maur...@wanadoo.fr To: profox@leafe.com Sent: Thursday, May 02, 2013 8:45 PM Subject: Re: SELECT (SQL) Date Range Problem I apologize, this list is colour blind .. as I am. So the red is not shown ! Jean, adding to this i previously

Re: SELECT (SQL) Date Range Problem

2013-05-02 Thread Gérard Lochon
- Original Message - I am trying to get aTable of amounts over a 21 day period. I think that the problem is theEnddate: Gluctmp1.date + 20 Even though [Gluctmp1.date + 20] is a valid date, SELECT I get the [unrecognized command] error with this: SELECT Gluctmp1.date,

Re: DELETE - File in use by another

2013-04-18 Thread Gérard Lochon
- Original Message - From: Stephen Weeks stephenwe...@fastmail.fm To: profox@leafe.com Sent: Wednesday, April 17, 2013 10:11 AM Subject: Re: DELETE - File in use by another The only time I have encountered this error message was when the users laptop did not have a drive mapped to the

Re: Empty Datetime()

2013-03-19 Thread Gérard Lochon
- Original Message - From: Jeff Johnson j...@san-dc.com I would expect date() - {//} to be = date(). It probably doesn't because it is an empty date and not a valid date. Not at all. As Lew said, the difference between two dates is not a date but a number. empty date is a valid

Re: VFP Functions that Require EXCLUSIVE

2013-03-15 Thread Gérard Lochon
DROP TABLE ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive:

Re: File Compare Utility

2013-03-10 Thread Gérard Lochon
- Original Message - From: Desmond Lloyd desmond.ll...@gmail.com Need a Windoze utility that will compare the file names and last access date between two folders and identify when it finds matches. Have two sets of engineering data so need to compare the two Any suggestions

Re: bit field in mysql

2013-03-05 Thread Gérard Lochon
From: MANJIT JHA kalasoft...@yahoo.co.in i have a bit field in mysql table in which values are 0 or 1, but when i take data in cursor through sqlexec command in vfp9(sp2) it becomes T for all records regardless of 0/1 in mysql. Hello. What is exactly the content of the request used ?

Re: bit field in mysql

2013-03-05 Thread Gérard Lochon
- Original Message - From: John Weller j...@johnweller.co.uk whereas some should be False? First respond to my previous reply. Without further information, we are able to discuss about the sex of angels using Foxpro as a new layer ... (and we've got background about thatt). :o))

Re: VFP5 question about SUM - Crazy behaviour

2013-02-13 Thread Gérard Lochon
- Original Message - From: José Olavo Cerávolo olav...@yahoo.com To: profox@leafe.com Sent: Wednesday, February 13, 2013 3:38 PM Subject: VFP5 question about SUM - Crazy behaviour Hi All, I am maintaining a software written in VFP 5.0a. Here's some code I wrote for a new function.

Re: VFP5 question about SUM - Crazy behaviour

2013-02-13 Thread Gérard Lochon
From: José Olavo Cerávolo olav...@yahoo.com --- I know you can think i'm just silly, but ... assuming that there is a minus operator within calculation, it is possible to reach a zero result ; so, what is the result if you : select sum (ncost - lnFreight) * nshipqty from msambb where cclass =

Re: SQL Server optimisation

2013-02-12 Thread Gérard Lochon
From: Graham Brown grah...@compsys.co.uk I reckon they are just being a little lazy so instead of choosing the search from a combobox they just leave it set at any field. You could restrict the search using a dictionary of skeletons. For example, if the criteria is SMITH [ formal A(5)] ,

Re: [NF] Attention procrastinators!

2013-01-31 Thread Gérard Lochon
There's a new free version of Courier out, for those of use who will happily spend ages dicking around with their IDE font rather than working. Courier retired in 2000 :o ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Happy New Year

2012-12-31 Thread Gérard Lochon
Midnight is just ticking here, happy new year from Paris, France ! Gérard. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Merry Christmas, Happy Holidays!

2012-12-24 Thread Gérard Lochon
... luck, happiness and prosperity in the New Year ... ... the first one after the end of the old world ! My best wishes to all of you. Gérard. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: [NF] Reoccurring dream about programming

2012-11-22 Thread Gérard Lochon
From: Michael Madigan mmadi10...@yahoo.com Anybody else have that? Microsoft ! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Speed

2012-09-14 Thread Gérard Lochon
From: Michael Madigan mmadi10...@yahoo.com My software is too optimized, I have a gazillion index tags, which gives it more moving parts to fail. Throwing hardware at something isn't a bad idea, but sometimes you can't. Just create another software to optimize your optimizations, and bill

Re: auto increment

2012-09-05 Thread Gérard Lochon
My preferred method is a UDF() that interrogates a table holding one record for each table in the system and it's next primary key. Access the relevant record, lock it for a short period of time whilst incrementing the next sequential record then unlock and return back the PK. This works

Re: auto increment

2012-09-05 Thread Gérard Lochon
Gerard, That is true for ALL the data not just the pointer table so that isn't an issue when DBF's are used because the whole of the DBF structure is available to change as long as the user has access rights. Yes indeed, that's the genetic lack of open systems, but i wanted to

Re: corrupted table and database issues

2012-08-07 Thread Gérard Lochon
Fix it with CM Repair http://www.cmstory.com/index.php?module=Pagestype=userfunc=displaypageid=5lang=en ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: msoutl32.ocx

2012-08-01 Thread Gérard Lochon
From: Jean MAURICE jsm.maur...@wanadoo.fr In fact, the ocx is working fine during run time; it's only in the IDE that I have the problem ... Diffrence between development time and production time often means problem with paths ... Jean, where is located (and regserved) your msoutl32.ocx ?

Re: msoutl32.ocx

2012-08-01 Thread Gérard Lochon
From: Jean MAURICE jsm.maur...@wanadoo.fr in the syswow64 directory ... For what I have looked for until now, I think I am missing or I have an incorrect msoutl32.reg file ... The error is you 'have no license' and not 'unable to find' ... The Foxil PS Gérard, j'ai déjà posé la question sur

Re: [NF] Screen Capture - Tutorial

2012-07-24 Thread Gérard Lochon
http://www.picpick.org/ ___ 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:

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

2012-07-20 Thread Gérard Lochon
- Original Message - From: Ken Dibble krdib...@stny.rr.com To: profox@leafe.com 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

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:

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

Re: [OT] pretty funny

2012-07-18 Thread Gérard Lochon
- Original Message - From: Stephen Russell srussell...@gmail.com To: ProFox Email List profox@leafe.com Sent: Wednesday, July 18, 2012 8:59 PM Subject: [OT] pretty funny https://www.youtube.com/watch?v=HA_gwzx39LQfeature=player_embedded#! I saw it yesterday. Excellent. Based on

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:

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 jsm.maur...@wanadoo.fr To: profox@leafe.com 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 !! Je n'aurais JAMAIS imaginé imbriquer des SELECT

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 a

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 carol...@gmail.com To: 'ProFox Email List' profox@leafe.com 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

  1   2   3   >