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

2013-11-11 Thread Jean MAURICE
and what about deleting corresponding lines in the table Foxcode ? You will have the name and the directory of this table in Tools\properties tab Files line 'foxcode'. Please copy it (with VFP closed) elsewhere before working on it ! The Foxil ___

Re: Foxpro/DOS not a dbf file error

2013-11-10 Thread Jean MAURICE
You are right ! Thanks The Foxil Le 10/11/2013 16:13, Laurie Alvey a écrit : I make 0x1904 = 6404 - 8404 is 0xD420. Unless I'm going crazy. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Foxpro/DOS not a dbf file error

2013-11-10 Thread Jean MAURICE
You are right ! ;-) The Foxil Le 10/11/2013 17:01, John R. Sowden a écrit : On 11/10/2013 07:47 AM, Jean MAURICE wrote: You are right ! Thanks The Foxil Le 10/11/2013 16:13, Laurie Alvey a écrit : I make 0x1904 = 6404 - 8404 is 0xD420. Unless I'm going crazy. all the hex math aside

Re: Foxpro/DOS not a dbf file error

2013-11-09 Thread Jean MAURICE
May be it is due to a wrong record number in theheader of the file. I don't rememberin wich bytes it is (and it is in a 'reverse mode' ?) and try to add 1 to it (or minus 1). When the computer freeze, may be the 'last' record was added but it has no time to update the header. HTH The Foxil

Re: Foxpro/DOS not a dbf file error

2013-11-09 Thread Jean MAURICE
Collapse imageTable Header Record Structure Byte offset Description 0 *File type:* 0x02 FoxBASE / dBase II 0x03 FoxBASE+ / FoxPro /dBase III PLUS / dBase IV, no memo 0x30 Visual FoxPro 0x31 Visual FoxPro, autoincrement enabled 0x32 Visual FoxPro, Varchar, Varbinary, or

Re: Foxpro/DOS not a dbf file error

2013-11-09 Thread Jean MAURICE
03 0D 0B 09 04 19 00 00-21 01 4B 00 00 00 00 00 03 : foxpro dbf without memo 0D 0B 09 : last update november, 9th 2013 04 19 00 00 : number of records : 4868 Try to write 05 or 03 instead of 04 in byte n° 4 (beginning with 0) HTH The Foxil ___

Re: Foxpro/DOS not a dbf file error

2013-11-09 Thread Jean MAURICE
I am glad to see that 'old science' is still alive ! 04 19 00 00 : number of records : 4868 I made a mistake, 19 is hexadecimal so number of records should be 8404 ... Regards The Foxil ___ Post Messages to: ProFox@leafe.com Subscription

Re: Why would this be faster in IDE?

2013-09-04 Thread Jean MAURICE
Hi Michael, I have such a problem in building view but not with IDE. Sometimes, it takes about 1 minute to built etwa 300 views more often it takes 15 seconds per view. I am unable to detect what can slow the process. The only thing I can see is that the Hard Drive is working a lot. I believe

Re: color codes

2013-09-04 Thread Jean MAURICE
may be this can help you : |m.nRed = *Bitand*(0xFF, m.nRGB) m.nGreen = *Bitand*(0xFF, *Bitrshift*(m.nRGB,8)) m.nBlue = *Bitand*(0xFF, *Bitrshift*(m.nRGB,16)) |The Foxil --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

Re: FPDOS browse issue

2013-08-27 Thread Jean MAURICE
Rafael, I do remember that SQL is present on FPDOS but not JOIN !!! So you must write the relation in the WHERE clause. Best regards The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Foxpro 2.6 DOS/dosemu/ubuntu issues

2013-08-25 Thread Jean MAURICE
Hi John, I am very interested by your work so please go on asking question on this list ! I worked a year (in 1999) with FPU2.6 managing a 'big' (600Mo !!) database with more than 100 users. Client had a small FPU app and I 'expanded' it to a large one. He was very happy but went bankrupcy a

Re: VFP9: Document Management

2013-08-16 Thread Jean MAURICE
Hi Desmond, to create PDF, I use Cesar Chalom's Foxypreviewer To view PDF in a form, I use the olecontrol webbrowser dans gallery\_webview with ._web.navigate(your PDf file) If I succeeded to do it, it must be easy ;-) The Foxil ___ Post

Re: VFP9: Document Management

2013-08-16 Thread Jean MAURICE
Le 16/08/2013 18:04, Dave Crozier a écrit : Sorry Jean, I Missed out your first name. the keyboard buffer gobbled it up! Dave It doesn't matter my name is also a first name and I am used to be called by both ! The Foxil ___ Post Messages to:

Re: VFP9 Document Management

2013-08-16 Thread Jean MAURICE
Le 16/08/2013 19:05, Desmond Lloyd a écrit : Was thinking of placing a collection of documents in a folder identified by a particular order number, or location identified by the user. You can use easily long file name, so you can add informations such as client's name to the name of each pdf

I don't want the alias name in drags and drops

2013-08-12 Thread Jean MAURICE
Hi all, I have to build about 50 forms to input datas in parameter tables that have only few fields. When I drad and drop the table from the database manager into the form, I get a grid that will allow the user to browse the table. It's ok. I then drag and drop the list of fields in to the

Re: I don't want the alias name in drags and drops

2013-08-12 Thread Jean MAURICE
Hi Frank, I found one for report but not for forms. It's why I asked the question ! The Foxil Le 12/08/2013 14:25, Frank Cazabon a écrit : I think there was a setting in the Options dialog that controls if the alias is added on or not, but I could be wrong Frank.

Re: FoxPro v1.02 database problem following computer crash

2013-08-07 Thread Jean MAURICE
proAction or did you buy it. In another words have you the source files of it ? The foxil -- Jean MAURICE Grenoble - France - Europe www.j-maurice.fr www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: Colours

2013-06-22 Thread Jean MAURICE
Hi Sytze, IMHO, when you write colorchoice=RGB(255,0,0) colorchoice contains the same 'big number' as the one given by Getcolor(). You do not need to convert the number to RGB style (and then back to the big number) unless you want to show the three 'basic' colors. The Foxil

Re: Email from foxpro

2013-06-05 Thread Jean MAURICE
José, you can try VFPWinsock, an opensource project driven by a french MVP Francis FAURE. I use it for a long time and it works like a charm. As the code is given, I think it is easily understandable although I can translate main things to you ... http://www.vfpwinsock.com/ In french,

Re: Ideas on how to proceed to get unique set of rows (no keys)

2013-06-04 Thread Jean MAURICE
Le 30/05/2013 23:51, Tracy Pearson a écrit : In VFP, you pull them in to separate cursors, then UNION them together. In my humble opinion, UNION will only give unique lines. If you want all the lines (so with all duplicate lines) you must write UNION ALL The Foxil

Re: Ideas on how to proceed to get unique set of rows (no keys)

2013-06-04 Thread Jean MAURICE
It's what I want to say : it's ok to UNION the cursors created from the CSV files. No need to SELECT DISTINCT afterwards ... The Foxil Le 04/06/2013 17:30, MB Software Solutions, LLC a écrit : On 6/4/2013 11:23 AM, Jean MAURICE wrote: Le 30/05/2013 23:51, Tracy Pearson a écrit : In VFP, you

Re: Dot Matrix Printing from VFP

2013-06-04 Thread Jean MAURICE
As a foxil (still working sometimes with DOS !), I see a problem using ??? and a report at the same time because you can't be sure of what VFP/windows sends to the printer when it initializes the report printout (you can send your NLQ command and then VFP sends the DRAFT command) : wether you

Re: [NF] I hope they treat their patients better than their data

2013-05-20 Thread Jean MAURICE
Le 20/05/2013 07:50, Pete Theisen a écrit : 100K medical mistake deaths per year. Ban doctors not guns. Perhaps a lot of ill people die but cured of their illness, doctors say ;-) I hope this is understandable in english ! The Foxil ___ Post

Re: [NF] I hope they treat their patients better than their data

2013-05-20 Thread Jean MAURICE
Le 20/05/2013 08:13, Pete Theisen a écrit : died healthy That's it ! The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Access windows file attributes from VFP

2013-05-15 Thread Jean MAURICE
As I am a good boy, I uploaded a first try on Ed's download page ... The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Global TextBox Change on a Form During Runtime...

2013-05-14 Thread Jean MAURICE
ThisForm.setall() ? HTH The Foxil ___ 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: Access windows file attributes from VFP

2013-05-14 Thread Jean MAURICE
something like : DECLARE INTEGER GetFileAttributes in win32api string @ FUNCTION file_int_properties _GetFileAttributes LPARAMETERS lpFileName AS string LOCAL m.lnAttributs, lcAttributs lnAttributs= GetFileAttributes(@m.lpFileName) IF m.lnAttributs=-1 RETURN ''

Re: Access windows file attributes from VFP

2013-05-14 Thread Jean MAURICE
I'll translate it in 'english' and I'll upload it on the download page ... Be patient for 2 or 3 days ... The Foxil Le 14/05/2013 18:56, Joe Yoder a écrit : Thanks Jean for sharing your code! ___ Post Messages to: ProFox@leafe.com Subscription

Re: [NF] MS to Release Windows 8.1

2013-05-13 Thread Jean MAURICE
or a 'souvenir' of BLUE screen of death ? :-) ;-) The Foxil ___ 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

Re: Printing from Preview Window

2013-05-07 Thread Jean MAURICE
Hi Jeff, you should have a look at Cesar Chalom's foxypreviewer : it's wonderful and easy to use ... http://foxypreviewer.codeplex.com/ The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: SELECT (SQL) Date Range Problem

2013-05-02 Thread Jean MAURICE
in red, the clauses you can erase The Foxil Le 02/05/2013 20:24, Charles Hart Enzer, M.D., FAACP a écrit : SCAN ALL GOTO M_Recno SUM Cnt_stri.cnt_day ; NEXT 21; WHILE NOT EOF() ; TO SUM_21 REPLACE Cnt_Stri.CNT_21 WITH SUM_21

Re: SELECT (SQL) Date Range Problem

2013-05-02 Thread Jean MAURICE
I apologize, this list is colour blind .. as I am. So the red is not shown ! You can erase 'While not EOF()' in the sum command and the 'loop' just before the ENDSCAN The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: primary or unique index

2013-04-24 Thread Jean MAURICE
Hi Gary, I am afraid not to understand your real problem. If you want to have a 'unique' (discriminant ?) index , you can build a primary key. But if you already have a primary key (on trans_id for example), a candidate index will be ok. You must be aware of one thing (that annoy me A LOT) :

Re: primary or unique index

2013-04-24 Thread Jean MAURICE
Le 24/04/2013 21:51, Ted Roche a écrit : INDEX ON STR(StudentID,12)+STR(classID,12)+STR(sessYear,12)+STR(sessionID,12) TAG NoDupes CANDIDATE And what about using BINTOC() instead of STR(). STR() does a binary-ASCII translation; BINTOC() is 'straight' : nearly a CAST command ! The Foxil

Re: normalization

2013-04-22 Thread Jean MAURICE
Le 22/04/2013 17:54, Gary Jeurink a écrit : I made an intermediate table spots (classID, studentID, clientID) my two cents : just add a date field 'day' in this table and insert one line per student per classe and per day. You'll be able to count the number of days in each class for each

Re: DELETE - File in use by another

2013-04-16 Thread Jean MAURICE
Le 17/04/2013 05:25, Mike Copeland a écrit : select dbfname go top in dbfname locate for xyz scan while !eof('dbfname') delete if xyz in dbfname ends Mike, I think you write it too fast !! SELECT dbfname LOCATE FOR xyz SCAN REST FOR xyz DELETE ENDSCAN but this

Re: Activte Command Button via Hotkey

2013-04-08 Thread Jean MAURICE
seen in caption property : To assign an access key to a control, include a backslash and a less-than sign (\) in the caption immediately preceding the character you want to designate as the access key. A user can then press ALT and the specified character to move focus to that control. If the

Re: [OT] 50 of the Most Beautiful Women Ever

2013-04-07 Thread Jean MAURICE
Happily, there some french girls ! If I find a picture of Brigitte BARDOT nowadays, I'll send it to you. How can I say : it's day and night ? The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: FoxRibbon and FoxScheduler

2013-04-07 Thread Jean MAURICE
Le 07/04/2013 23:50, Michael Savage a écrit : In Canada, the second language available to me was French... and I didn't learn that one either. Shame on you !! The Foxil ... in France ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Unbearable Lightness/Heaviness of Arrays

2013-04-04 Thread Jean MAURICE
Hi Ken, on a sideway, you should look at the collection class : it allows to have a lot of informations in memory : - this information can be 'indexed' and retrieved with the index - each element can be an 'object' with a complicated structure; it's far more interesting than having only

Re: Screen Res. Design Monitor Sizes...

2013-03-20 Thread Jean MAURICE
Le 19/03/2013 21:27, Kurt a écrit : OK - Jean - this is Strange. When I replied to your Direct e-mail, that you sent to my work e-mail, My reply was Rejected with an Error message claiming Service Refused. ... I have 2 adresses; can you try both ? jsm.maurice arobase wanadoo and contact

Re: Screen Res. Design Monitor Sizes...

2013-03-17 Thread Jean MAURICE
I apologize ! no joined file in Profox ! I send you the .zip privately The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Screen Res. Design Monitor Sizes...

2013-03-16 Thread Jean MAURICE
Hi Kurt, first attempt : I have added 3 classes to a new vcx and a file into the zip but I have NOT tested them (I'll do it tomorrow ...). I have just added two lines (or 3 ?) to mwresize.resizecontainer and mwresize.resizecontrol to allow limiting the increase ratio. The main thing to

Re: VFP Functions that Require EXCLUSIVE

2013-03-15 Thread Jean MAURICE
N°1 : PACK The Foxil ___ 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: VFP Functions that Require EXCLUSIVE

2013-03-15 Thread Jean MAURICE
n°2 : INDEX The Foxil ___ 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: Screen Res. Design Monitor Sizes...

2013-03-13 Thread Jean MAURICE
Hi Kurt, I'll write some english comments in the code I added and I'll send it to you perhaps at the end of this week ... Be patient ! The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Screen Res. Design Monitor Sizes...

2013-03-12 Thread Jean MAURICE
Hi Kurt, I was away from home ... you can't use mwresize as it is to modify the size of the menu. But you can 'easily' modify it as I have done to add my own calculations ... Best Regards The Foxil ___ Post Messages to: ProFox@leafe.com

Re: Screen Res. Design Monitor Sizes...

2013-03-11 Thread Jean MAURICE
In my very humble opinion : 'standard' menu font, size, ... are defined by the MS Windows parameters. But they can be overrided by the FONT, FONTSIZE, CHARSET and STYLE clauses in the DEFINE MENU (and define pad, ...). You can try to play with ... BUT : it supposed that you work with a .mpr

Re: Screen Res. Design Monitor Sizes...

2013-03-06 Thread Jean MAURICE
I use mwresize a lot. Here are my 2 cents : 1) It does 95% of the work. I have 'installed' it in my baseclass for form. 2) I don't think it can 'magnify' beautifully a 600*400 designed screen to a 1700*1400. There some 'problems' of accuracy (that depends also of the fonts you use). I have

Re: Screen Res. Design Monitor Sizes...

2013-03-06 Thread Jean MAURICE
When I have to resize a container after the form is initialized I write : ThisForm.MWRESIZE1.savecontainer( thisform.mynewcontainer) * the line above is supposed to memorize the initial dimensions of the container * and now, I resize the container ThisForm.MWRESIZE1.resizecontainer(

Re: A VERY Strange Error!

2013-02-25 Thread Jean MAURICE
When all has been done and you have lost all your form : open the 'temp' directory' the one of VFP, you will see a recent 'duo' of tmp files (I can't remember if they have the same name but I am sure that you can 'recognize' them. The 'shortest' one must be renamed to myform.scx; the biggest to

Re: 64-bit DEFINE CLASS

2013-02-15 Thread Jean MAURICE
Can you try replacing createobject with NEWOBJECT() without the set procedure to ? loClass = NEWOBJECT(MyClass, makeclass.prg)'MyClass' is the class defined in MakeClass.prg To see if it is a problem with PATh or with the class.init method() HTH The Foxil

Re: VFP5 question about SUM - Crazy behaviour

2013-02-13 Thread Jean MAURICE
Le 13/02/2013 15:38, José Olavo Cerávolo a écrit : insert into Msambb values (CLASS, , SELECTED CLASS, 0, 0, 3, 0, 0, lnBox, lnBoxDisc) Hi José, the normal syntax for insert into is : insert into Msambb (field1, field2, field3, field4, , field10 ) ; values (CLASS, , SELECTED CLASS, 0,

Re: Print Table Structure

2013-02-06 Thread Jean MAURICE
For the table structure : SELECT matable LIST STRUCTURE TO PRINTER or TO FILE matable.str For indexes : LIST STATUS TO FILE matable.sta HTH The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: [NF] What Developers Want

2013-02-06 Thread Jean MAURICE
Le 06/02/2013 12:17, Ed Leafe a écrit : just get everyone to learn English Ed, you have made a small mistake, you should have written just get everyone to learn American :-P The Foxil ___ Post Messages to: ProFox@leafe.com Subscription

Re: clear events Issue

2013-01-31 Thread Jean MAURICE
Hi Gene, it's the way it works : you can not 'interrupt' the execution of a method or event. When you execute CLEAR EVENTS, the 'event' is just added at the top of the event stack ... and unstacked at the end of the current method You have a 'if' to test if the app must end, put the

Re: Using LostFocus Instead of Valid

2013-01-31 Thread Jean MAURICE
Back in the day, all we had was VALID and it was good... or not good... You could also return a numerical value : 0 was 'false', 1 go to the next control in the tab order, 2 two controls further -1 go to the previous control etc ... The Foxil

Re: Using LostFocus Instead of Valid

2013-01-30 Thread Jean MAURICE
Hi Gene, The Valid method is here only to say I am allowed to leave the current object or not. As you have seen, you should not have another 'sequence' in it. Once Valid returns .T., the Lostfocus method is here to compute what to do when you leave the current object. I have never have

Re: [NF] Who on this list is a train nut?

2013-01-24 Thread Jean MAURICE
This spring I will be laying some track for an O Scale railroad around my garden. Nothing like a full size train, but just as time consuming. I see full size cabooses for sale once in a while but my wife won't go for it. Hi Nicholas, if you are going to build a train outside, I do think it's G

Re: [NF] Who on this list is a train nut?

2013-01-24 Thread Jean MAURICE
In fact, the 'real' driver is on her side. All the driving she has done (and that I have done too) is 'illegal' and able only because we know the driver and because he is confident. Driving a passenger train is very easy when all is ok. The main difficulty is obeing (to obey) the signals and

Re: [NF] Who on this list is a train nut?

2013-01-19 Thread Jean MAURICE
Hey, it's wonderful !! What is amazing is that he built the car ! here in France, it's 'easy' to buy an old one. The most complicated is to carry it to your home and to have enough room for it (it's 24m long in Europe). I haven't understood all what he said but near the end he said you must

Re: SQL Response to Forms

2013-01-17 Thread Jean MAURICE
I cross my finger for you ! Hoping that you have the same meaning in the USA !! Good Luck and if your next work is with VFP, tell the interviewer that you belong to the largest Fox community in the world ! The Foxil In France (btw, France is in Europe ;-) )

Re: FINGER TROUBLE

2013-01-13 Thread Jean MAURICE
I wrote some improvements to the TS utility some years ago ... and I don't use it anymore !!! In fact, the 'search tools' (source search tools ?) of VFP is more simple to use and allows the user to go straight to the source code when he clicks on a line in the result. The Foxil

Re: [OT] Nice song (nice lyrics too if you know some French)

2012-12-27 Thread Jean MAURICE
Hi Ricardo, I can't read spanish but this song has been recorded in 1980 It has been a great success may be last year ... ! The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

Re: Private data session

2012-12-21 Thread Jean MAURICE
Hi Kent, your method seems to be correct; Perhaps a detail is wrong. Here are my 2 cents : when you call your object method, write, in your form, something like Local lnsessionsid AS number lnsessionid = ThisForm.DataSessionId = Myobject.mymethod( m.lnsessionid) I have had some 'strange

Re: GETFILE() Multiple Files

2012-12-18 Thread Jean MAURICE
Look in the help for ADIR() SYS(2000) LOCFILE() perhaps you'll find what you need ... The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: [OT] French socialists veer a little to capitalism

2012-11-06 Thread Jean MAURICE
Hey ! Among you, who knows where is France ? Who cares of it ?? Jean-Marie, you must not answer ;-) The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this

Re: Speed

2012-09-12 Thread Jean MAURICE
Le 12/09/2012 05:17, Fred Taylor a écrit : You do have an index tag on DATE in all the tables, right? Fred PUBLIC gcworkplan =SYS(3092, optimisation.txt) =SYS(3054, 12, gcworkplan) your query goes here =SYS(3054, 0) =SYS(3092, ) Run this program and open the file optimisation.txt to see what

Re: Speed

2012-09-12 Thread Jean MAURICE
Le 12/09/2012 07:44, Fred Taylor a écrit : Internally, I don't think there's a difference, it's just syntax. oh, it's just a good habit to have ! First, if, one day, you want to upload your database towards Oracle, Sql Server, ... The Foxil ___ Post

Re: Speed

2012-09-12 Thread Jean MAURICE
If the fact that more than one user is on the app slows the query, can you try to open the tables exclusively or to FLOCK() them just to see what happens ? Another way should be to build a COM object staying on the server and doing all the heavy queries and creating cursors or returning XML

Re: Speed

2012-09-11 Thread Jean MAURICE
Le 12/09/2012 04:36, John Harvey a écrit : You might try using a statement like ...where (Date=?startdate and date=?enddate) Going further : BETWEEN(date, start, end) is a VFP function, not a SQL clause. You should write WHERE date BETWEEN start AND end The Foxil

Re: [OT] Traingasm

2012-08-05 Thread Jean MAURICE
Oh I understand him ! I participated to a renewal of a steam locomotive in years 1975 - 1980. It was a 5 years hard work for 6-10 people. And after 3 failures, I remember it's first 'Tchou' as if it was yesterday ... Best regards The Foxil ___

Re: msoutl32.ocx

2012-08-01 Thread Jean MAURICE
Le 31/07/2012 11:03, Dave Crozier a écrit : Don't forget to regsvr32 it It's done. At least I hope ! I have built a batch file (Do you remember those old .bat files ???!!) and I ran it as administrator ... In fact, the ocx is working fine during run time; it's only in the IDE that I have the

Re: msoutl32.ocx

2012-08-01 Thread Jean MAURICE
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 Atoutfox, ce qui m'amène à penser à ce

Re: msoutl32.ocx

2012-08-01 Thread Jean MAURICE
I am supposed to be in holydays ... and I have only my own computer WIN7-64 ... and a 16Kb ADSL link Jean Le 01/08/2012 16:48, Gérard Lochon a écrit : From: Jean MAURICEjsm.maur...@wanadoo.fr . Have you tried to test it on another computer, a clean one without any side effect ?

Re: Any one put an app in a cloud?

2012-08-01 Thread Jean MAURICE
Eh Thierry, on dort ? presque 24h pour réagir ! ;-) To all : I was wondering why Thierry took so long to react ! Jean ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this

msoutl32.ocx

2012-07-30 Thread Jean MAURICE
I am adding some points to an 'old' app written in 1999 with VFP6. In fact I work with VFP9 SP2 on a WIN7-64 machine. Two forms run well but I am unable to open them because they have an activex named msoutl32.ocx in it. This activex show something like the 'windows explorer'. When I try to

Re: SYS(3054)

2012-07-25 Thread Jean MAURICE
Have a look at SYS(3092, myquery.txt) The foxil ___ 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: SQL Grouping Problem...

2012-07-18 Thread Jean MAURICE
You are working with VFP9 ? Try to write SET ENGINEBEHAVIOR 70 before your query SQL in VFP9 is a lot more 'standard' than before and, now and normally, you must have all non aggregate fields in the group by clause ... hth The Foxil ___ Post

Re: [OT] was test for array

2012-07-15 Thread Jean MAURICE
Grenoble airport : 05°20'01E 45°21'38N Home : 05°21'38E 45°21'11N See you soon ;-) The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: test for array

2012-07-12 Thread Jean MAURICE
May be you can try Grenoble's airport (St Etienne de St Geoirs) : the runway is 3.2 km long ... and you can have a beer in my home just near it ! The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

[OT] was test for array

2012-07-12 Thread Jean MAURICE
Well, my 'second home' is very near the runway (may be 2km of the west end (ther is only one or two planes a day ...)). But the 4 tramway lines (5 next year) are about 45km away. I tried to find the position of the airport but neither with google maps neither with IGN, I could find it. The

Re: [OT] was test for array

2012-07-12 Thread Jean MAURICE
There is a french foxer who likes flying ... we can plan a meeting ! The foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: VFP9: Outputing to PDF

2012-07-11 Thread Jean MAURICE
and you can try Foxypreviewer of Cesar CHALOM . It has a lot of features including save to PDF .. The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

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

2012-07-10 Thread Jean MAURICE
oh my god !! Je n'aurais JAMAIS imaginé imbriquer des SELECT dans la clause FROM I would never dare use a SELECT in a FROM clause of a SELECT statement being itself in a FROM clause of a 'upper' SELECT !!! The Foxil Jean à Grenoble ___ Post

Re: [OT] - Do you like trains ?

2012-07-04 Thread Jean MAURICE
eh that is wonderful ! I belong to a club like this one but 20 times smaller ! We have only 3 steam engines (and they are small (040)) and may be 100m long track ! The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Sending E-mails from VFP

2012-06-30 Thread Jean MAURICE
Hi Kurt, In the orignal text there are NO asterisks. I do not know where they come from !! The Foxil Le 29/06/2012 22:13, Kurt Wendt a écrit : Hello Jean, Thanks for your input again! I just download the procedure file an example. Just curious, in your code below - you have an Asterisks in

Re: Sending E-mails from VFP

2012-06-30 Thread Jean MAURICE
Le 30/06/2012 11:13, Fred Taylor a écrit : Were those parts bold in your text? Some editors treated a leading/trailing * like an HTML bold tag. YES ! Thanks a lot. The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Sending E-mails from VFP

2012-06-29 Thread Jean MAURICE
I have done that nearly for free and with nearly no difficulty. Because I have it, I use XFRX to build PDFs but I think that Cesar CHALOM has done a free pdf export : FoxyPreviewer. To send emails, I use a library built by Francis FAURE (based on Rick STRAHL classes ?) :

Re: Sending E-mails from VFP

2012-06-29 Thread Jean MAURICE
Here is an example of vfpwinsock (http://www.vfpwinsock.com) |*SET* *PROCEDURE* *TO* VFPwinsock o=*CREATEOBJECT*(_VFP_Winsock_Send_Mail_) o.SMTP_HOST = _smtp.Serveur.com_ o.*FROM* = _mon_em...@serveur.com_ o.FROM_NAME = _Mon Nom_ o.*TO* = _ton_em...@serveur.com_ o.Subject = _Hello World_

Re: Repair vcx

2012-06-27 Thread Jean MAURICE
Try to have a look to all the recent .tmp files in the VFP tmp directory. You can try to open them with a USE the one to open being the smaller one of each name hth The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: VFP9 SP2 + W7-64 + toolbar

2012-05-29 Thread Jean MAURICE
This is a private joke : I am a Railway Fan ! Merci Gérard ! The Foxil Le 29/05/2012 14:27, Gérard Lochon a écrit : From: Jean MAURICEjsm.maur...@wanadoo.fr So Aero is not for tomorrow neither after-tomorrow ;-) He prefers Rail - o ... :o))) Gérard.

VFP9 SP2 + W7-64 + toolbar

2012-05-28 Thread Jean MAURICE
I have a strange problem : I have an app that works on WIN XP and on one PC WITH W7-64. In a modal form, I instanciate a toolbar. Under XP, I can access this toolbar, I can move it, resize it ... but not under win7. When I try to 'reach' it, I hear the ding as when we try to 'escape' from a

Re: VFP9 SP2 + W7-64 + toolbar

2012-05-28 Thread Jean MAURICE
Hi Dave, it works if I set the showwindow property to 'in desktop'. It gives a strange result in the IDE but it's ok with an exe. There is a drawback ! moving the toolbar is VERY slow ! Thanks The Foxil Le 28/05/2012 10:31, Dave Crozier a écrit : Is the form designated as top form? I came

Re: VFP9 SP2 + W7-64 + toolbar

2012-05-28 Thread Jean MAURICE
Thanks Dave. The Foxil Le 28/05/2012 15:54, Dave Crozier a écrit : Jean, I found exactly the same thing (slowness of moving) and haven't been able to solve it as of yet but it's on the list for later this week. I'll keep you posted. Dave ___

Re: VFP9 SP2 + W7-64 + toolbar

2012-05-28 Thread Jean MAURICE
In fact, I have the problem only with the PC + WIN7-64 ... The Foxil ___ 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

Re: VFP9 SP2 + W7-64 + toolbar

2012-05-28 Thread Jean MAURICE
Tracy, I am old and a fan of DOS. I work under Windows because I can't avoid it. So Aero is not for tomorrow neither after-tomorrow ;-) The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: General Design Question

2012-05-21 Thread Jean MAURICE
one thing and a big question ! I am building a school management system. Problem in french schools is that computers are old and LAN slow. VFP is able to work with more than one Database. So I have a 'common database' on the server and a local database on each station. The local database

Re: General Design Question

2012-05-21 Thread Jean MAURICE
Thanks Tracy and Stephen : I'll stay on the right way and ask for data when needed ... The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Button click without focus

2012-05-11 Thread Jean MAURICE
What about writing your code in the gotfocus() event with a RETURN .F. at the end of it ? It's untested The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this

<    1   2   3   >