Re: On Key, InKey Getting Key Strokes [Resolved]

And if you have an index on lastworked and you want to stay with your 'old era program', try to use SET KEY instead of SET FILTER ... HTH The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: On Key, InKey Getting Key Strokes [Resolved]

I apologize, my answer was for 'empty filter consition' ! The foxil PS I am glad to see that I am not alone stil using @x,y SAY . Le 27/04/2012 07:08, Jean MAURICE a écrit : And if you have an index on lastworked and you want to stay with your 'old era program', try to use SET KEY instead

Re: Empty filter condition.

And if you have an index on lastworked and you want to stay with your 'old era program', try to use SET KEY instead of SET FILTER ... HTH The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Are NESTED LOCATED Allowed?

Just to answer your question : LOCATE without any RANGE will start serach from the beginning of the file. If you want to locate something and then something else 'further', don't forget the REST clause .. It's just in case of ! I haven't understood what you are trying to do ! The Foxil

Re: Are NESTED LOCATED Allowed?

Even if you stay with the 'old' SCAN command, you should use all its possibilities (capabilities ?) : SELECT EDIHDR SCAN FOR SEEK('TARGE'+edihdr.CUSTPO, 'orderhdr') SELECT OrderHdr * if you had a good index, you could have a fine SCAN REST WHILE a lot quicker * than

Re: [OT] A dramatic surprise on a quiet square

Un bon coup de pub !! 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: [OT] A dramatic surprise on a quiet square

bonjour Jean-Marie, je vais avoir un camping-car bientôt ... on ira te voir ! Il y a une gare dans le coin ;-) ? Tu y passes beaucoup de temps ? tu y travailles ? ou c'est juste pour les vacances ? A+ Jean ___ Post Messages to: ProFox@leafe.com

Re: I'm having issues with access and assign

Le 11/04/2012 05:04, Tracy Pearson a écrit : The method lActive_Assign is fired in VFP when the lActive is assigned a new value. Just a detail : I would have write (writen ?) : is assigned a value. The 'new' value can be the same as the 'old' one and _assign is fired. In the _assign method,

Re: Cannot Insert

Jerry pay attention to this point : if you have a primary key, you can do an INSERT BLANK but if you leave this record blank, you can't add another one because you can't have two 'blank' keys. HTH The Foxil ___ Post Messages to: ProFox@leafe.com

Re: [NF]: Referencial Integrity

IMHA, during all the design time, it should belong to your code; allowing you to correct mistakes and bugs. Once design is over and for safety, you should transfer (or copy) it to the database. The Foxil ___ Post Messages to: ProFox@leafe.com

Control-M and VFP

Has anyone already driven VFP from within Control-M ? A customer, in France, has such a thing (as far as I have understood, there are about 80 VFP 'scripts') but he has a lot of problems and is looking for help. In fact I need informations about 'how control-M works'. Thanks in Advance The

Re: Control-M and VFP

ok I ask him ... Thanks The Foxil Le 27/02/2012 17:51, Dave Crozier a écrit : Jean, If you mean the Job Scheduling suite produced by BMC then I have done some work on it but only for the purposes of data transfer as they recently updated it to run on M$ SQL Server, however I may be able to

Re: Control-M and VFP

Hi Tracy, I didn't think of that. This is a great idea. I ask him ... It's such a long time since I used it :-) The Foxil Le 27/02/2012 18:16, Tracy Pearson a écrit : Dave, He might be referring to the keyboard macro's built into VFP IDE and Runtime. Tracy Pearson PowerChurch Software

Re: beginner's question

come to VFP supposed to be dead ? -- Jean MAURICE (the Foxil) Grenoble - France - Europe www.j-maurice.fr www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free

Re: SQL prob

Andrew, I don not thonk 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!employee ; WHERE EMPTY(natno) OR

Re: [OT]: Italian Cruise Liners

So, I Think the Captain of the Costa Concordia was a fan of Churchill : he was one of the first escaping on earth ... The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version

Re: An SQL Select poser.

You can try something like SELECT aa.account, aa.reference, aa.date, aa.value ; FROM yourtable aa ; WHERE aa.value 0 AND ; aa.account+aa.reference+DTOS(aa.date)IN ; SELECT ab.account+ab.reference+DTOS(ab.date) ; FROM yourtable ab WHERE ab.value 0) ; INTO CURSOR myresult ; UNION ; SELECT

Re: An SQL Select poser.

Paul, it seems very clever and a lot more simple than my solution. Best regards The Foxil Le 30/01/2012 15:21, Paul Newton a écrit : Alan How about Selecting Sum(Value) As n1, Sum(Abs(Value)) As n2 Having Abs(n1) # Abs(n2) Paul Newton ___

Re: Two DBC's with the same file name

Le 24/01/2012 17:40, Jeff Johnson a écrit : Please don't suggest that I change the file name. But what about using an alias ? USE dbc1!filename AS filename1 IN 0 USE dbc2!filename AS filename2 IN 0 ? USED(filename1) ? USED(filename2) The foxil

Re: Keep the old files or replace?

using new field type as integer ... The Foxil BYTW : happy new year to all of you ! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Vfp and counter

Gérard, tu es génial A+ 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: RGB for Tan

And what about using the VFP function GETCOLOR() ? The Foxil I'd suggest you let the client choose exactly the color they want: Google RGB color picker and pick any one of the millions of web sites that have an online color widget and let the client go to town picking out exactly the color

Re: RGB for Tan

All my form are based on a base class I built some years ago. In the load event of this class, I open a file which contains all the parameters of the forms and I seek the key corresponding to the current form and the current user. Main parameters are position of the top right corner, the height

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

Your thought is not so bad : Air France (the world famous company that ran Concorde !) want to buy TGV to shuttle from Paris CDG to Lyon (2h) or Geneva (2.30h) or Brussels (2h). They think that a rail link between these airports should be more efficient than planes. In Switzerland all main

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

And the European too ... The Foxil Le 30/11/2011 00:30, Dan Covill a écrit : Now explain again to me the benefits of the US transportation system. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

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

mauvais esprit !! Dis donc, tu te lèves tôt !! Jean Le 30/11/2011 06:09, Gérard Lochon a écrit : So you multiply by 3 the risk of loosing your luggage ... :o))) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: [NF] Neutrino race

They have done a second batch of tests this last week. And the neutrinos are still going quicker than light !!! The foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this

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

In France, the store can refuse if you pay by giving more than 50 coins (whatever are the coins values). Eh I didn't know that !! ;-) Jean à Grenoble The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: [NF] VFP - Python - Dabo

Le 03/10/2011 21:46, Eurico Chagas Filho a écrit : I feel that VFP is wounded, nobody is learning it anymore... That's not true ! The foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

Re: [NF] Neutrino race

I live about 100 miles from the Large Hadron. I remember (but it is long ago) that the neutrinos go through the earth ... In another place in the nearby (Mont-Blanc tunnel) there is a 'space neutrino detector' (?) with about 4000m of rocks above it ... they don't care ;-) The foxil

Re: [NF] Neutrino race

http://press.web.cern.ch/Press/PressReleases/Releases1999/PR14.99FGranSasso.html just under the picture, it is said : they have no mass, they are 'uncatchable' (?), they run at light speed and they don't interact with any material ... The Foxil ___

Re: [NF] Neutrino race

if you go down the paper, there is a button : 'english version' ! The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: SQL: Find min record (vs. value) in a group

I Vassilis, I would like to add that your command is a good way to avoid the SET ENGINEBEHAVIOR 70 when you want fields that are not used for the agregate functions ... Best regards The Foxil ___ Post Messages to: ProFox@leafe.com Subscription

Re: rename file

Hi Georges, can you verify this point (in VFP9 SP2) : RENAME (without the clause FILE !) does a MOVE so the second path must be the same that the first one if you want to do a 'true' rename Best regards, The Foxil. ___ Post Messages to:

Re: No table is open

IF !FILE(lcFile) First of all, I'll write something much simplier : IF !FILE(m.lcfile) As you have done in the USE command Second : if you are on VFP9, I'll write SELECT 0 TRY USE (m.lcfile) EXCLUSIVE ALIAS tmpf I'll avoid using 'tmp' CATCH USE (m.lcfile) ALIAS tmpf =

Re: Mulitple Table Browses in the in the Same FORM

Have you tried BROWSE ... NOWAIT ? The Foxil Le 25/06/2011 17:28, william tormey a écrit : VFP 5.0 Browse says: Foxpro allows you to have several browse windows open at the same time. I have bunch of separate tables holding cumulatively some sixty flags, most of of which are real time

Re: Error Condition 109

Hi Sytze, in older days, i used to add a field 'owner' to each table. This field is normally empty if the record is 'free' and contains the operator's code if it used by one operator. it's something like : * locking a record IF RLOCK() REPLACE mytable.owner WIH operator.code UNLOCK ENDIF

Re: Field type

TYPE() or VARTYPE() ? The Foxil (old age too !!) Le 15/06/2011 07:59, Sytze de Boer a écrit : Old age or what I need to know if the field in a table is logical or character Something like If fieldtype(16)=L blah endif Is there such an option ?

Re: I'd like to post to profox list

Bonjour Thierry, bienvenue sur cette liste où j'ai trouvé énormément d'aide au début où je m'essayai à l'orienté objet avec VFP6. Il y a 2 types d'abonnement à la liste : le complet où tu auras énormément de message [OT] off topic, quelques messages pas très sympathiques pour les français

Re: Fox-In-Cloud - VFP gets to run on the Cloud

Thierry, Foxincloud's developer, is a friend of mine. He is 55 and he developped Foxincloud alone (may I say as a masterpiece if it is understandable) for about 3 years. I sent him your mails and he answers that price are going to be recalculated (reduced ?) because one thing he did'nt wait

Re: Questions from a client regarding VFP9

, VFP is THE tool for them : you can begin very simply (Do you understand : no start treshold ?) and go very far with the same tool working on simple machines and being easy to learn. my two cents ... The Foxil -- Jean MAURICE Grenoble - France - Europe www.j-maurice.fr www.atoutfox.org

Re: Res: [OT] time lapse animation

German. I think that Belgium has no government for more than one year because the flemish part doesn't want to share with the french part ! Au revoir, à bientôt ! -- Jean MAURICE Grenoble - France - Europe www.j-maurice.fr www.atoutfox.org www.aedtf.org Le 25/04/2011 14:49, Eurico Chagas Filho

Re: Horizontal scrolling in a text box

properties : - textrtf contains the text with all the RTF codes - text contains pure text only without any code This is from my memory and must be verified. -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages

Re: Rushmore

. It is logp.update_local_datas() As we need a loader for the exe, I have a loader for the static datas. I hope it helps ... Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: [OT] I hope this doesn't become a trend

Hi Nicolas, I beg your pardon but what is a 'shower' ? The Foxil ... in France ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: [OT] Pronouncing the name: Georges Lemaître

can you hear that ? -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org --- StripMime Report -- processed MIME parts --- multipart/mixed text/plain (text body -- kept) audio/wav --- ___ Post Messages to: ProFox@leafe.com

Re: [OT] Ride the Train

. -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.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

Re: [OT] Urban Train Systems

YES ! Pete Theisen a écrit : Hi Everybody! Anybody have an urban train system they like? -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: [OT] Urban Train Systems

http://www.semitag.com/ for Grenoble http://www.tpg.ch/fr/index.php for Geneve (Switzerland) www.ratpf.fr for Paris http://www.tcl.fr/ for Lyon I'll give you somme more this evening ... What is your need ? Why such a sudden interest ?? -- Jean MAURICE Grenoble - France - Europe

Re: VFP9 - truncating numbers

? STR( 845092370570, 14, 0) -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http

Re: SQL help

and then filter it with the WHERE. I hope I am clear ! -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list

Re: VFP9 - Auto resizeing forms

I like Markus Winhard's mwResize control. + 1 -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version

Re: VFP9-Interactive change event

(for example) -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.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

Re: [OT] I guess we will have to trust Google on this one.

. One day, he returned to save his country . BTW, arabic caracters should be right-justified BTW bis : Michael is lucky : Guantanamo is closed -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages

Re: [OT] Hail to the chief

other country that is gushing over the election of an illegal alien Kenyan. Spain, president ? You really have low cognitive skills. A+ jml -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org --- StripMime Report -- processed MIME parts --- multipart

Re: [NF] Phoenix New Light Rail Kiosk

a couple of days ago. This is an actual photo of one of the stops where you buy your tickets. -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com

Re: What am I missing (newbee)

editbox each time a character is typed. Try to use the keypress event instead -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman

Re: What am I missing (newbee)

how did you know? May I say that Christof is the best VFP specialist in the World ? At least one of the best !! -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription

Re: [Fwd: RE: URGENT - Job Requirement - Visual FoxPro Developer - Baton Rouge, LA - Amedysis]

May be they do speak 'french' ? I try !! I think this job offer has been sent on Profox may be one month ago ... -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription

Re: Who still using visual foxpro do developer they software?

screen so we can see who must be 'teached' more (understandable ?) or who is drunk or In fact the only drawback of DOS is LAN : it is difficult to make computers speak to each others when some tasks must be of high priority. Long life to FOX !!! -- Jean MAURICE Grenoble - France - Europe

Re: Who still using visual foxpro do developer they software?

. BYTW, I am 54 perhaps too much to change way ... -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version

Re: Newbee - working with a programmatically created text box

That's very clever ! Dave Crozier a écrit : In the VFP_Classes.prg make the first statement a return: * VFP_Classes.prg Return -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com

Re: Newbee - working with a programmatically created text box

' is very important. -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.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

Re: Newbee - working with a programmatically created text box

, beginning with RETURN, you can do DO myclasses VFP will search for myclasses.prg, executing it so finding return and doing nothing BUT now myclasses.prg is in the VFP's list I have already been here so I can find all what is there And that's clever !! Am I clear ? -- Jean MAURICE Grenoble

Re: VFP index corruption

Jean, have you got RECNO() in your index expressions ? another jean ! -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo

Re: Carriage Returnn on a Text File

, c001numped + |) ENDSCAN FCLOSE(m.lnFileHandle) Second, I do think that you can do the same thing using the COPY command (see the help for correct syntax ...) USE AT001 IN 0 ORDER I001C02 SELECT AT001 COPY TO ('Interf2008.txt') FIELDS c001numped TYPE DELIMITED WITH | -- Jean MAURICE Grenoble

Re: Set Main on a form

properties : window_type (better MODAL for the beginning) and show_window (as first level form for the first form). -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance

Re: index column Unique or empty

something like INDEX ON yourfield CANDIDATE FOR !EMPTY(yourfield) ? I have field which can be empty else it must be unique. Can I create such a index which will throw an error. Ajoy Khaund -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org

Re: [OT] Champenois Family

I do agree ! But after I have seen Mr Obama saying 'bonjour' to a french journalist, I think that the situation is going better and better ! The Foxil -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages

Re: [OT] Idiot Californians approve Bullet Train development

Jerry Wolper a écrit : How much more of a mess would New York be without public transit? The voice of wisdom. I should have known that a trains thread would bring Jean back. It's good to hear from you again. -Jerry Wolper [EMAIL PROTECTED] Thanks Jerry ! The Foxil. -- Jean

Re: [OT] Idiot Californians approve Bullet Train development

Michael Madigan a écrit : Oops I thought you were talking about Belgium Jean. I apologize to Jean Maurice No offense ! Jean of Belgium is a great foxer ... too ! It's a shame that he loves speedcars ;-) -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org

Re: [OT] Idiot Californians approve Bullet Train development

I have missed something I guess : Arnold is a Rrepublican isn't he ? a famous example of the right wing ? and HE is an idiot By the way, you forgot to say something : the bullet train is based on a FRENCH technology ! The Foxil -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org

Re: [OT] Idiot Californians approve Bullet Train development

merci Cécile ! Mais on n'est pas les seuls : SIEMENS en Allemagne, BOMBARDIER au Canada ... et les Japonais ! Cecil Champenois a écrit : Well, at least le français savoir faire des trains. Cecil The Foxil -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org

Re: [OT] Idiot Californians approve Bullet Train development

financial execs could we help with their BMW payments? Larry Miller -- Jean MAURICE Grenoble - France - Europe www.atoutfox.org www.aedtf.org ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT

<    1   2   3