Re: Happy Anniversary!
ouaouh so old ? and still working ? Some of you remember that I am a railway fan and a ... fossile in computer programming. Last week, I have benn hired by SNCF (the French National Railways) to maintain an app built in 1991 with ... Pascal. In fact there is a new app being built but it is very late ... as our trains are ! I wish a long life to Profox, the best thing that happened in my professional life. The Foxil J. MAURICE Grenoble France Europe Le 17/08/2019 à 16:35, Ed Leafe a écrit : OK, it's a bit late, but it just occurred to me that we just passed the 20th anniversary of the ProFox list! I posted the first message on July 22, 1999. So break out the bubbly! https://leafe.com/archives/msg/1 -- Ed Leafe [excessive quoting removed by server] ___ 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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/16470b6c-4d8a-62f0-2445-30cc0034f...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] AtoutFox, Lyon, France
Hi Johan I listened to Fabrice speeches on X# in Lyon (France) last friday. It was very interesting even if I didn't understand all what he said (I am 64 and more a specialist of DOS than Windows ;-) ). But I think it will open a door to 'modern programming' ! Some of us are going to try to compile their VFP app with the tools shown by Fabrice. It will be somehow difficult for me but as I work a lot with bits it will be interesting to test the 'compatibility'. If you agree, I can transmit on Profox all the posts sent to www.atoutfox.org As a side note, about 10 years ago, half people of AtouFox leaved because they said 'VFP is dead'. They spent a lot of time and money switching to other languages. The other half staid with VFP ... and now we can say that they were right ! 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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/83d1bb16-409c-a407-a693-53e2416ed...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Filtering Oddity
+1 The Foxil Le 15/05/2019 à 20:39, juer...@wondzinski.de a écrit : We don't talk about endusers, we are the experts. Experts are using data directly and edit directly in a browse. PAH!! wOOdy ___ 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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/81064321-c2fa-27d2-0909-d6457e184...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Filtering Oddity
Le 15/05/2019 à 20:36, Koen Piller a écrit : Woody And where is set filter in this respect? Browse is not for end users, with a grid you are better of. Koen NO ! having begun with Fox Dos, I am very easy with command lines, on key label, browse, ... a lot more easy than using the mouse ! And using a grid means that you have built a form : an extra work that can be easily avoided with the command window !! 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: https://leafe.com/archives This message: https://leafe.com/archives/byMID/9852cb2a-d4b2-44b6-7189-176916296...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Numbering Scheme
so to improve this solution : print the time and then add the sequential number as milliseconds such as : 172543.124 : the ticket has been printed at 17h25m43s and is the 124th ... The Foxil Le 11/10/2018 à 17:12, Frank Cazabon a écrit : That may work! Frank. Frank Cazabon On 11/10/2018 10:59 AM, Vassilis Aggelakos wrote: Try to put the real number between two 1 single digit other numbers. For example 3452 --> 3=dummy 45 = real sequence 2--> dummy. No math needed, just this little trick! Hope this helps. On Thu, Oct 11, 2018 at 5:55 PM Alan Bourke wrote: Do you care more about competitors overestimating or underestimating the amount of business being done? -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/b3ce60bd-469c-41ed-b3ce-9cce42704...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Appending from a Cursor
Hi Gene, 'append from' appends data from a file on the disk and a cursor is not a file ! Can you try this : APPEND FROM (DBF(m.alimport)) 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/8115740b-ec64-cb50-8810-f07643106...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Thread Start Test
HI Gene, I can read your post so your are wrong BUT it's very rare I can read original post. In most cases, I only read responses. Happily they include the original question ! The Foxil Le 27/03/2018 à 00:36, Gene Wirchenko a écrit : Hello: I do not appear to be able to originate threads on ProFox. If you are reading this, I am wrong. Sincerely, Gene Wirchenko [excessive quoting removed by server] ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/94a386dd-30e8-b527-674c-aae84d325...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: String Reference to Object
Hi Gene, have you tried WITH (m.reference) .referredto = etc ENDWITH ? 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/94f71b4d-fbbc-a474-7fc2-6a72f4b38...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyone watch the liftoff yesterday?
it was surprising to hear Bowie in the space. I think it's the best improvment made by Mr Musk : allowing sound waves travelling through the 'vacuum' ;-) 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/9f20dca9-015a-626e-c91f-f8d0610e3...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Trashed class library
On Mon, Jan 29, 2018 at 9:05 AM, Laurie Alvey wrote: Mmm. I didn't get the original post. Laurie Mine was in gmail spam folder I have the same problem but for some time now : I do not receive original messages and they are not in the spam folder. But all answers are ok. And sometimes the original message appears. What can be the différence between an original and an answer ? 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/8210ce6b-f07d-d6bc-d7bf-662446e6b...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: hellooo-o
a long time ago, I read this joke : "Knock, knock." "Who's there?" very long pause…. "Java." Have a nice week-end ! The Foxil Le 13/01/2018 à 14:23, AndyHC a écrit : Knock knock! Is there anybody there? [excessive quoting removed by server] ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4986458b-d075-c7a2-e3df-1190f4102...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: hellooo-o
I am here too ! The Foxil Le 13/01/2018 à 14:23, AndyHC a écrit : Knock knock! Is there anybody there? ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ef735e07-7e16-1ca6-e36c-267121b25...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Reactivated old FOXil
I happy to see you again Woody !! By the way I am the only one Foxil ... The Foxil In Grenoble - France PS for some times I don't receive the first mail of a post but only those beginning with 'Re:'. I mean 4 posts on 5 are correct (sad news, Trigger design) but I didn't receive the original post from Woody). Le 19/10/2017 14:25, Jean Laeremans a écrit : ROFL. Welcome back wOOdy !! On Oct 19, 2017 2:22 PM, "Dave Crozier" wrote: Peter Oooh Matron! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Peter Cushing Sent: 19 October 2017 12:36 To: profox@leafe.com Subject: Re: Reactivated old FOXil On 19/10/2017 11:59, Jürgen Wondzinski wrote: Hi all Yes, that old wOOdy FOXil is still alive and kicking :) After several years of silence and self-maintenance, I thought it couldn't hurt to take a look at ProFox again. Now let's see how often I manage to chime in here :) wOOdy Got the message at 11.59 You can't beat a bit of morning wood ;-) Peter This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960 [excessive quoting removed by server] ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/59e8a02f@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Re: [FW] Programming language life expectancy
So, I think I am beginning with Alzheimer ! The Foxil Le 01/09/2017 20:44, Laurie Alvey a écrit : Yeah, the one "with the enormous memory" was the Commodore 64 (64K)! Laurie On 1 September 2017 at 18:44, Ted Roche wrote: "The VIC-20 had 5 KB of RAM, of which only 3.5 KB remained available on startup (exactly 3583 bytes)." https://en.wikipedia.org/wiki/Commodore_VIC-20 On Fri, Sep 1, 2017 at 1:04 PM, Laurie Alvey wrote: Didn't everyone at least dabble with BASIC? I started out with a Commodore VIC20 which (I believe), had 3.2 kB of RAM. ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/59a9b3b5.9020...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Re: [FW] Programming language life expectancy
Hi Laurie, I had a Vic20 and I think it was the first microcomputer to have 64koctets of memory. It was based on a 6502 microprocessor. I spent a lot of nights with it before meeting my future wife ! The Foxil Le 01/09/2017 19:04, Laurie Alvey a écrit : Didn't everyone at least dabble with BASIC? I started out with a Commodore VIC20 which (I believe), had 3.2 kB of RAM. Laurie ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/59a994ce.50...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[OT] Re: [FW] Programming language life expectancy
These last few days, I am smiling when I read Profox : I thought I was the only 'Foxil' still working with Foxpro DOS (I have an app working on a Compaq PC that is 23 years old !) and I am an 'expert' of FORTRAN : when I was in university it was one the few languages available (with COBOL and a little later C). I still work with FORTRAN : one of my client is EDF (French national Electricity Delivery). They where building simulations with 'R' (A new language easy to use but slow). As a test, I translate one of them to FORTRAN : running time went from 20 minutes to less than 3 seconds (on a multicore machine with FORTRAN MPI). Since then, I translate a lot and they began to build large simulations (one hour of FORTRAN !). I have two drawbacks : - I can't 'teach' the new scientists that working with integer is a lot quicker than working with real numbers - the FORTRAN exe run in a 'dos window' within Windows XP and I have no access to the energy saver parameters. So, after 15 minutes, the PC goes to stand by mode because Windows is not able to detect that a 'DOS' exe is running. So I bought a 'rotating fan', fixed the mouse on it so it moves continously right and left and ... windows stay 'alive' !! 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/59a81f8d.2050...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP Icon issue
you can try : right clic on the icon (the one on the desktop), properties, select icon (in french : changer d'icône). The first suggestion should be the good one. 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/599e9a21.2060...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [FIC] Problems with Adapted code
Le 24/07/2017 16:57, mbsoftwaresoluti...@mbsoftwaresolutions.com a écrit : Should I use the WWWC forum instead? NO ! I only read Profox and I want to be 'aware' of FIC ! The [FIC] prefix is sufficient for those who want to filter this part of the list ... 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/59760bf2.4010...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP and Gmail
Hi Rafael, I think we have all the same problem. Here in France, a standard is 100 mails per hour. What I have done is a 'slave app' sending one email each 40 seconds. The main app fills a table with all datas needed to send the email : @, text, files to join, etc. It tooks a very short time and the user has control again. And each 40s, the slave look in the table if there is a mail to send and if yes send it. I have not done a "test if email is well sent" (bad adress, ...), they are received in the standard 'outlook'. 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/59369d13.8010...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: "Record is not available" error in FPW 2.6
IMHO, if you have a RLOCK() / UNLOCK you don't need the FLUSH command. I remember, but it is far, that the fact to lock a rcord forces the 'flush'. Can someone agree or disagree ? 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/59316ea7.4050...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: is there a proper way in FPW 2.6 to add a line to the end of a memo?
Hi Michael, in fact each time you modify a memo field, its previous space is marked as 'unused' and a new space is created on the HDD. I think that the only way to avoid the size to grow is to PACK MEMO the table at the end of the update (or perhaps during the update if the size'grow (is it understandable ?) may reach the HDD size). 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/59030ddb.9060...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL sum
BIG ERROR ! you MUST NOT have m as local alias. Choose another letter !! 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/58f8bb1e.2000...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL sum
Hi Tom, what do you want to have as a result if your datas are 1 A 10 1 B 20 1 A 30 If you want 1 A 40 1 B 20 you can write SELECT stock_id, location, SUM(quantity) as mysum FROM mytable GROUP BY stock_id, location INTO but in this case (and except with VFP) you can't have a 'quantity' field in the result. If you want as a result 1 A 10 40 1 B 20 20 1 A 30 40 (so in each line of your table you have the total number of the current id in the location) you can write SELECT stock_id, location, quantity, (SELECT SUM(quantity) FROM mytable s WHERE m.stock_id = s.stock_id AND m.location = s.location) as mysum FROM mytable m INTO Note : I haven't check syntax so may be you must adjust the command ! Is this help ? 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/58f8b7e0.5070...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Printing native VFP reports to other types (like XLSX, PDF, DOCX, etc.)
You can try Foxypreviewer : http://weblogs.foxite.com/vfpimaging/2010/09/29/foxypreviewer-features-settings-dialog/ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/58cad0db.2090...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: 3 days no posts....
I am here too ... but I am working in ... FORTRAN for a client. I am maintening (surveying ?) a VFP app whose author retired. It manages bicycle private renter (people who rent bicycle). The biggest client has 1 machines and he lives in the biggest naturist camp in Europe ! To see who he is : http://www.cyclonat.com 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/588a112e.8060...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: API to find the size of an entire folder structure?
Why not create a recursive function with ADIR() ? 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/579cb776.1030...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Need GetFocus() for FP 2.6 @Get.
Hi Wayne, after the READ, there is no more 'event' you can work with (I mean there are no more active GET). So, yes, _curobj can only be set in functions (clauses ?) called from a @GET command. I remember that you can also set the first GET to be active in the READ statement but I don't remember the name of the clause. If you want to build only one procedure to 'manage' the active GETs, I think you can write your code in the VALID clause of the READ. As long as the valid returns .F., the READ stay active and _curobj is valid. The Foxil --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/485929873.13303.1464789984862.JavaMail.www@wwinf1e08 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Problem with GROUP BY
Le 20/02/2016 21:28, mbsoftwaresoluti...@mbsoftwaresolutions.com a écrit : I've often thought: the order of your GROUPING doesn't matterdoes it? Either way, it's the same distinct combination. No if you have'nt an order by clause : by default the order is the one given by the group by (I hope it's understandable !) 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/56c8cdd9.3070...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Problem with GROUP BY
1) if you work with VFP9, try SET ENGINEBEHAVIOR 70before the SELECT. If it solves the problem you'll have to change the command. Can you try it ? 2) you have no alias in the field's names so do not write one in the group by clause so it's "group by release_no" 3) I am not sure 100% but if you have a group by it's should be automatically ordered without the need of the order by clause. 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/56c8c0b1.3060...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Gig at NASA?
Hey, it's my youth !! I began to work with HP9810, HP9820 and HP9830 'microcomputer'. Then I built a clock with Intel 4004 microprocessor. It was only 230Khz and yes only one accumulator. I learnt Fortran a little further by reading a book "computer programming, techniques analysis and ?" whose authors were 3 'VALLEE' people (3 guys whose name was VALLEE). And I am still programming in FORTRAN ! 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/56334192.9060...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [OT] Combs for a Man?
1) yes 2) 60 We never know : may be we will meet a young and beautiful girl ? 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5627ebd9.2080...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Problem with COPY and RENAME
can you try to write FILE(lcexportpath+lcimage) without parenthesis around lcexportpath and COPY FILE (lcexportpath + lcimage) TO (lcexportpath + UPPER(ALLTRIM(doc_url)) ) And I also use ADIR()>0 instead of FILE ! 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/55d417a0.3050...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: BITRSHIFT(n,1) v n/2
Hi Laurie, read in help : Integer *Numeric* value with no decimals For example, a line number in an order. 4 bytes -2147483647 to 2147483647 But I don't think that CAST would throw an error in case of overflow. If bit n° 31 (the 'most left' one) is 1 then the value is considered to be negative. Reading the help, I 'discovered' that 'integer' doesn't exist in memory (only a field type). May be it's the reason taht there is no difference in the computation ... The Foxil --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/55ba293a.1020...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: BITRSHIFT(n,1) v n/2
Hi Darren, I confirm your values ! It's not useful to compute with BITRSHIFT as I do for ...a long time. But it prooves something : VFP is very quick 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/55ba27a5.5050...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: BITRSHIFT(n,1) v n/2
Hi Laurie, I do think that BITRSHIFT is a lot quicker than /2. BITRSHIFT can be done with only one machine cycle (clock tic); the division is a lot more complex. BUT ! this is true only if K is an integer (k = CAST(8E9 AS integer)). Otherwise you must add add the conversion time between numeric and integer. You can also add a third test : k * .5 sould be faster than k /2 The Foxil Old enough to know how microprocessors work ! ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/55b8ca33.8060...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Best way to do one-way synchronized approach?
there is another solution not so efficient that the one you want but a lot more simpler. The first time a table is needed for lookup, you download it in the datasession n°1 (for example). I do this using a class with a child class for each table. Using pemstatus( ,5) I can chek if the child class has been instanciated and the table downloaded. When you need the table in another datasession, you use the clause NOREQUERY 1 of the command USE : NOREQUERY [nDataSessionNumber] Specifies that data from a remote SQL view is not downloaded again. NOREQUERY is available only for SQL views and is typically used when you open a SQL view again by including the AGAIN clause. Including the NOREQUERY clause increases performance for large data sets because the data does not need to be downloaded again. nDataSessionNumber can be included to specify that data for a remote SQL view in a specific data session isn't downloaded again. If nDataSessionNumber is omitted, data isn't downloaded for the view open in the current data session. HTH The Foxil --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/55a96259.30...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: PACK AND ALL THAT
Another way is to reuse the deleted records. In few words : to delete a record, I transform the (integer) key value to the negative one (mykey = -ABS(mykey)). When I have a record to add, I lookfor the first record with a negative key. If FOUND() I replace the data and the key with the new ones; if not, I add the record. My primary key is "mykey FOR mykey>0" 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/55728e9e.7070...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Decimal numbers on a French keyboard
Hi Paul,
if you want I call your guy ... I'am french !!
I have seen disturbances (problems) with OpenOffice where the '.' on the numeric
keypad gives a ',' but, IMHO, it's normal. What is not normal is that OpenOffice
can't 'analyse' the value.
In my VFP apps I have
SET POINT TO ','
SET SEPARATOR TO '.'
You must take care that some 'external products' as Foxypreviewer change these
settings without reseting them.
HTH
The Foxil
Le 28/05/2015 16:08, Paul Hill a écrit :
Hi Gang,
Had a call today from a guy in France that said the 'point' on the
numeric keypad doesn't work correctly when entering numbers.
The currency format France use is "9 999,99".
The 'point' key on a French keyboard is a period ("."). It makes
sense that this would not work correctly as I they are entering
".99" which does not evaluate correctly.
Here is the weird thing. If I change my regional settings to French
and open Excel the point key returns a comma! Is Excel doing
something special?
This is in a C# app but I see the same issue in VFP.
Any ideas?
___
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: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/55672852.9020...@wanadoo.fr
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL puzzle
Tracy, the best way to be sure is to write INNER, LEFT OUTER or RIGHT OUTER in each query !! 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/555a439c.8050...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL puzzle
Joe, I wouldn't leave fields ddate and cCategory without 'Cat.' and if you are under VFP9, I'll write SELECT led.iCat_Id, cat.ddate, Led.iCat_Id, cat.cCategory ; FROM cat INNER JOIN led ON cat.icat_id = led.icat_id ; INTO CURSOR myresult You can detect if the same icat_id belongs to more than one line in cat with SELECT icat_id, COUNT(*) AS nb FROM cat ; GROUP BY icat_id HAVING COUNT(*) > 1 ; INTO CURSOR plus1 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/555a3774.4030...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP9: Form Data Environment
my two cents : at the beginning, I used the 'visual data environment' until one day a 'table object' became sized 0,0 and I was unable to reinitialize it to a normal size. So I came back to what I like a lot : code. In fact, sometimes I open the dataenvironment, put a table on it, drag the object to the form to have a grid and then delete the table and the dataenvironment ! I open tables and views, instanciate data-acces classes in the load event (but I don't write 'close tables all' in the unload event !). It's easier for me to understand the 'data structure' reading a lot of code than looking at a visual map. It's also easier to find a table, a field, ... with the 'research tool'. Apart this, nearly all my forms are in a private dataenvironment (I allow the user to open each form more then once (ie in my school management system, he/she can work on three or four pupils at the same time)). and nowadays, I am testing one thing : I have a lot of 'parameter tables' ie : holydays dates, prices, types of meals, . I build a class, instanciated as a global object in the init of the app so in the datasession 1; this class opens 'parameter views' only when it is needed (so if I need a 'meal price', it opens the view if it is not opened; the view is not systematically opened in the init (is this understandable ?)). The cursors generated are in the datasession n°1. And in the load event of a form with a private dataenvironment I write : goparam.viewtest_open() && opens the view if it is not in the datasession 1 otherwise do nothing USE viewtest NOREQUERY 1 && 'copy' the cursor in the form's datasession It is supposed to be very fast (no requery just a copy aof the cursor) ... and it seems to work well ... 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/7f95.8000...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Posting from My New Job
Hi Kurt, when I looked to the french word 'indispensable', my French-English dictionary gave me 'essential' ;-) 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5537bd2a.4060...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Posting from My New Job
Le 22/04/2015 16:44, Ed Leafe a écrit : Always glad to hear that ProFox is still a valuable resource! I am looking for a word stronger than 'valuable' : perhaps 'essential' ? 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5537b847.6090...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Data Dictionary questions
I wonder one thing : I have NEVER had problems with longfield names. Is'nt it because of the space in the name that you have your problem ? 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/552eb677.7030...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Data Dictionary questions
Joe, have a look at AFIELDS() and COPY STRUCTURE EXTENDED ... 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/552e376c.2020...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: copy objects
There is NO un_Addproperty but you can find a function named REMOVEPROPERTY() ;-) There is also a method named .removeobject() 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/552dfb74.7000...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: copy objects
Hi Rafael, you must care of one thing : when you write "oClient = _screen.oClient", you are NOT copying one object to the other. You are only duplicating its adress. So if you modify a poperty of oClient, the modification will appear in _screen.OClient 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/552d65e9.2040...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: record position
Rafael, I didn't understand what "showing the position as a page" is, but if you create an index and you SEEK the company, you can BROWSE the result and you will see a 'page' ! Note : there are the command SEEK and a function SEEK(); I prefer the second one perhaps in the BROWSE, the 'right record' wil be displayed not in the middle of the browse window, you can then put some SKIP -5, SKIP 5 to àcure this issue. 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5510fa2c.4030...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Foxpro DOS - How to build an APP
Hi Kevin, another Foxil ? :-) ;-) The Foxil Le 19/03/2015 14:39, Kevin Cully a écrit : I have a new client that has a Foxpro 2.0 for DOS app that they've been running for decades. They've had some fits and starts on upgrading it to Visual Foxpro. I hope I'll be able to finish the upgrade. ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/550ad956.9050...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Mwresize
Hi William, as I am an old foxer, I began to design form in 800*600 and with mwresize they match screen resolution automatically but it is not always beautiful : things can become too big. Si I have modified Markus'class to limit the 'growing ratio'. What I have done is built a form class with the mwresize in it; I added two properties to the form to manage "max horizontal ratio" and "max vertical ratio" and instead of 'droping' mwresize on each form, they are based on this form class. It was easy to do. In fact, this form class is more complicated : it is linked to a table where I record coordonates, backcolor, ... so when the user modify the position and the size on the form, he get the same coordonates the next time he opens it. It is also linked to another table where I store all the texts that are used in the form : it was supposed to facilitate the 'multilanguage' but I never use it !! I can try to simplified my class leaving only the mwresize and send it to profox ... 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54fa9305.20...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Scanning through the tables in a database
Hi Joe, you can use ADBOBJECT() to get all the tables of a database in an array as in the example given in the help : * Open sample testdata database OPEN DATABASE (HOME(2) + 'Data\testdata') * Function call with cSetting for table names =ADBOBJECTS(gaTables, "TABLE") * Displays array gaTables created by ADBOBJECTS( ) function DISPLAY MEMORY LIKE gaTables In fact, ADBOBJECT will give you the number of element found : lnnbtable = ADBOBJECT(gatables, "TABLE") FOR lnindice = 1 TO m.lnnbtables USE (gatables(m.lnindice,1)) ? gatables(m.lnindice,1)+ STR(RECCOUNT(),8) USE NEXT 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54f38361.8000...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: shared memory
Hi Thierry,
why looking for so far when it is so near !
But I have an issue : with this program:
SET PATH TO C:\VFP\VFP9\INTERNET\LEAFE\CTOXML\ ADDITIVE
SET PROCEDURE TO C:\VFP\VFP9\INTERNET\LEAFE\CTOXML\ABOOP.PRG,
C:\VFP\VFP9\INTERNET\LEAFE\CTOXML\AB.PRG
loobj = CREATEOBJECT("test")
lcresult = ""
DO ab
lcresult = cXMLofObject(m.loobj)
STRTOFILE(m.lcresult, "test_xml.xml")
MODIFY FILE test_xml.xml NOWAIT
DEFINE CLASS test AS custom && jme 27/01/2015
*
toto = "toto"
tata = "tata"
tutu = -2
titi = .T.
ENDDEFINE && test
I have this 'short' answer :
<#o#><#c#>Test<#cl#>c:\vfp\vfp9\internet\leafe\ctoxml\ctxml.fxp
But don't hurry, I'll not be able to work on it before next week ...
Jean
___
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: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/54c8fcf6.70...@wanadoo.fr
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: shared memory
Hi Kevin, it gives an error on the 'controls' property that can't be 'evaluate' because it is a collection. If you allow me, I'll 'improve' it ! I will also add recursivity because a property can be a pointer to another class. But, as it is for my own 'pleasure', priority is low and it will take me some times ... The Foxil Le 27/01/2015 21:34, Kevin Cully a écrit : Hey Jean, I wrote that class, so I guess I'm to blame! :D Is it giving you an error? Can you paste in some code on how you are calling it? ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54c88f8c.60...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
shared memory
I would like to test transmission of datas between two exe with shared memory (CreateFileMapping, OpenFileMapping, MapViewOfFile, UnmapViewOfFile). I can do it work with strings (I can send a string and I can receive it in the second exe). But now, I want to improve it : I would like to transmit 'objects' (things that are called 'structure' in C) like DEFINE CLASS test AS custom toto = "toto" tata = "tata" tutu = -2 titi = .T. ENDDEFINE && test XML seems to be my friend for that. I found on Ed's download page "ctxml.prg" that works with object built with SCATTER NAME but not with an instance of the 'test' class above. 1) has anyone already done this and can give me help and ... encouragement ;-) 2) is there a tool that can translate properties of classes to XML and vice-versa ? 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54c7f2f1.6020...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: boy, I'm rusty
First, mstate is not RTRIMMED ! And you could write less code, and more efficient, and more readable, with USE us_cities ALIAS cities ORDER TAG cities IN 0 SELECT 0 USE h-1b_fy14_q4 ALIAS mastfile SCAN ALL FOR ; SEEK(RTRIM(mastfile.lca_case12)+ ; RTRIM(mastfile.lca_case13)) mlat = n3 mlng = n4 ENDSCAN RETURN 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54bfdb06.7090...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: using select in a case
Tracy, you are right : lookup moves the record pointer. There is a parameter in INDEXSEEK to say 'no move of record pointer'. LOOKUP returns a field value; INDEXSEEK a logical The Foxil Le 20/01/2015 15:55, Tracy Pearson a écrit : Dave, I don't think I've ever used the LOOKUP() function. Reading the help states it DOES move the record pointer. Even moves the related child tables records. Tracy Pearson PowerChurch Software [excessive quoting removed by server] ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54be6e28.8080...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: using select in a case
from where ? when ? train number ?!!? ;-) Jean à Grenoble Le 20/01/2015 15:12, Allen a écrit : Thanks Jean Maurice Al PS I will be taking to your favourite transport next week. Train to Paris and back. ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54be63d8@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: using select in a case
Hi Allen, I think that LOOKUP() can solve your issue ... 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54be61a7.9050...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Filtering
What about building a class based on container ? With one field for the number formatted WITH ..., one for the 'comment' and a spinner for priority ... If you have more than one phone number to deal with and you don't want to build a child table, you can store them in a memo field : one line per number, 20 chars for the number, 20 chars for the comment and 3 for the priority. The coding-decoding process being a method of the container ... 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5465973f.2010...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL select
Le 11/11/2014 01:39, Ted Roche a écrit : select * from example where linkcode in (select linkcode from example group by linkcode having count(*)>1 ) 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 ... 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5461b71d.6090...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL select
Hi Sytze, you should buy Tamar Granor's book about SQL ... Your query could be something like SELECT * FROM rotables ; WHERE linkcode IN ; (SELECT linkcode FROM (SELECT linkcode, COUNT(*) AS nb FROM rotables ; GROUP BY 1 HAVING COUNT(*)>1) ; ) ; ORDER BY linkcode INTO TABLE (myfile) I can't test it so ... 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54614903.7050...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Problem with Missing CDX
Le 07/11/2014 08:40, John R. Sowden a écrit : FP/DOS lives for a few more years, Congratulations ! 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/545c8696.7000...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Formatted Browse Window
Is it a simple 'BROWSE' command or it has a lot of parameters like BROWSE FIELDS toto:40:H="sample" FORMAT myformat PREFERENCE .. ? 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5459b80d.5020...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Strange Framework Behavior
Le 04/11/2014 16:08, Jeff Johnson a écrit : I can't imagine why someone would do that other than simulating free tables while using DBC's. IMHO, when you open a table belonging to a database, the database is automatically open. So you can use long field name, ... For fun, as you seem to have the sources, comment all the CLOSE DATABASES ALL and see what happen ! 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5458ef1f.3070...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL MIN() et VFP MIN()
Yes. For years I have written CAST(O AS Integer) AS disponible in the SQL query followed by a REPLACE ALL after the query. The Foxil Le 29/10/2014 16:21, Bill Anderson a écrit : Jean If you take out the Disponible field does the query work and produce accurate results? Bill Anderson ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54510d62.6090...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL MIN() et VFP MIN()
today, the simplest way to solve the issueis the ICASEgiven by Paul Hill. 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5450f6aa.1080...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL MIN() et VFP MIN()
Hi Bill, this is not an error ! cantine_services and cantine_salles are linked together (it's a school restaurant, pupils are dispached in 4 groups that eat in 2 rooms) but tarifs_cantine is independant (it's the cost of different menus) and I want a 'cartesian product' (?) : on line per tarif and per group. The global problem is : meals are good and (due to the efficiency of my app ;-) ) not so expensive. The restaurant is sometimes overcrowded and we must stop registration when the max is reached. I hope you understand. The Foxil Le 29/10/2014 14:50, Bill Anderson a écrit : Jean, I think issue is a flaw in the JOIN. I don't see how ta ties to the rest of the join. FROM cantine_services sv ; INNER JOIN cantine_salles sal ON sv.salle = sal.clef, ; tarifs_cantine ta ; WHERE ta.anscol = lcannee INTO CURSOR I don't see how tarif_cantine (ta) ties to the other tables unless this is a shorthand that I'm unaware of. ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5450f62f.9090...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL MIN() et VFP MIN()
Hi Bill : unknown alias ta !
The Foxil
Le 28/10/2014 22:08, Bill Anderson a écrit :
Jean,
That should fail. The column names would not be available to be used in the
SELECT portion of the clause. If you use the HAVING clause as part of the
join, the column names are available to be used.
Replace the Disponible field with this and see if it works:
CAST(EVALUATE("MIN(sal.capacite, sv.capacite, ta.capacite, ta.maxjour)") AS
Integer) AS disponible
Bill Anderson
___
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: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/5450c3fa.6060...@wanadoo.fr
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL MIN() et VFP MIN()
a little more :
writing the table name instead of local alias avoid the syntax error but the
result is wrong.
SELECT DISTINCT ta.codtarif AS tarif, ;
sv.clef AS clefserv, sv.salle, sv.capacite AS servdispo, sv.libelle AS
service, ;
sal.capacite AS salledispo, sal.libelle AS nomsalle, ;
ta.capacite AS maxtarif, ta.maxjour AS maxjour, ta.libelle AS
libeltarif, ;
CAST(EVALUATE("MIN(cantine_services.capacite,
cantine_salles.capacite, tarifs_cantine.capacite)") AS Integer) AS disponible ;
FROM cantine_services sv ;
INNER JOIN cantine_salles sal ON sv.salle = sal.clef, ;
tarifs_cantine ta ;
WHERE ta.anscol = lcannee INTO CURSOR dispo READWRITE
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: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/544ffe54.3070...@wanadoo.fr
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL MIN() et VFP MIN()
Hi Bill,
it failed !
here is a small SQL query :
SELECT DISTINCT ta.codtarif AS tarif, ;
sv.clef AS clefserv, sv.salle, sv.capacite AS servdispo, sv.libelle AS
service, ;
sal.capacite AS salledispo, sal.libelle AS nomsalle, ;
ta.capacite AS maxtarif, ta.maxjour AS maxjour, ta.libelle AS libeltarif, ;
CAST(EVALUATE("MIN(servdispo, salledispo, maxtarif, maxjour)") AS
Integer) AS disponible ;
FROM cantine_services sv ;
INNER JOIN cantine_salles sal ON sv.salle = sal.clef, ;
tarifs_cantine ta ;
WHERE ta.anscol = "W" INTO CURSOR dispo READWRITE
in fact, inside the EVALUATE, the columns servdispo, salledispo, ... are unknown
as are sv.capacite, sal.capacite ...
The foxil
Le 28/10/2014 21:12, Bill Anderson a écrit :
Jean,
First, this... (VFP 9 specific)
USE ADDBS(HOME(1)) + [Browser.DBF] SHARED NOUPDATE
SELECT CAST(EVALUATE([MIN(1, 2, 3, 4)]) AS N(7, 2)) AS MinimumTest FROM
Browser INTO CURSOR Test
That shows how to use the VFP MIN() function in a SQL Select while
formatting the MinimumTest field.
So in theory, replace those 4 numbers with your calculations and you're all
set. But be careful of NULLs... I'd think about wrapping these 4 numbers
with EVL(< subquery >, 0) or even EVL(< subquery >, 10**10) depending on
what you want to do with the result when (if?) the subquery returns a NULL.
Bill Anderson
On Tue, Oct 28, 2014 at 12:22 PM, Paul Hill
wrote:
On 28 October 2014 17:17, Jean MAURICE wrote:
I have a curious issue !
In a SQL query, I get 4 numeric fields from 4 tables (with subqueries). I
want a fifth field containing the minimum value of the 4 fields (of the
current line). But when I write MIN(), even in an EVALUATE command, SQL
thinks it is a SQL MIN().
Is there a way to compute this minimum WITHOUT creating an external
function
?
Could you use the ICASE function?
SELECT amount = ICASE( ;
f1>f2 AND f1>f3 AND f1>f4, f1, ;
f2>f3 AND f2>f4 AND f2>f1, f2, ;
f3>f4 AND f3>f1 AND f3>f2, f3, ;
f4>f1 AND f4>f2 AND f4>f3, f4) ;
FROM results
Ugh!
In SQL Server you could do:
SELECT MAX(amount) FROM
(
SELECT amount = MAX(amount) FROM table1
UNION ALL
SELECT amount = MAX(amount) FROM table2
UNION ALL
SELECT amount = MAX(amount) FROM table3
UNION ALL
SELECT amount = MAX(amount) FROM table4
) AS results
Don't think VFP supports this syntax.
Dammit! Stephen just posted the same thing :-)
--
Paul
[excessive quoting removed by server]
___
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: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/544ffda7.4050...@wanadoo.fr
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL MIN() et VFP MIN()
I try it at once(I already tried with EVALUATE alone but it failed) The Foxil Le 28/10/2014 21:12, Bill Anderson a écrit : Jean, First, this... (VFP 9 specific) USE ADDBS(HOME(1)) + [Browser.DBF] SHARED NOUPDATE SELECT CAST(EVALUATE([MIN(1, 2, 3, 4)]) AS N(7, 2)) AS MinimumTest FROM Browser INTO CURSOR Test That shows how to use the VFP MIN() function in a SQL Select while formatting the MinimumTest field. So in theory, replace those 4 numbers with your calculations and you're all set. But be careful of NULLs... I'd think about wrapping these 4 numbers with EVL(< subquery >, 0) or even EVL(< subquery >, 10**10) depending on what you want to do with the result when (if?) the subquery returns a NULL. Bill Anderson ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/544ffb7d.7010...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL MIN() et VFP MIN()
Hi Stephen, I am getting a single cursor with a lot of columns; 4 of them are numeric and one more is '000.00 AS minimum' 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/544feafa@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
SQL MIN() et VFP MIN()
I have a curious issue ! In a SQL query, I get 4 numeric fields from 4 tables (with subqueries). I want a fifth field containing the minimum value of the 4 fields (of the current line). But when I write MIN(), even in an EVALUATE command, SQL thinks it is a SQL MIN(). Is there a way to compute this minimum WITHOUT creating an external function ? Nowadays, I just add a REPLACE ALL after the REQUERY() but I wonder if we can do better. Thanks in advance 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/544fcfa8.9010...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL
Le 17/09/2014 09:41, Laurie Alvey a écrit : Actually you don't need to specify INNER, the keyword JOIN by itself is implicitly an INNER JOIN. You only need the full syntax when you're using an OUTER JOIN (FULL, LEFT, or RIGHT). Laurie That's true but when you read your query some years later, it's easier to remember what it does when 'inner' is written !! Another point : it's better to use local aliases in your query at least for the human being reading it : Select h.date, h.invnum, h.prodcode, h.qty, s.name ; From winhist h Inner join winstocks s on h.prodcode = s.prodcode Where h.date > repdate 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54194592.70...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Aborting a report preview after one hour
Hi everybody, I am working with a customer app written with VFP8. We had a 'bug' preventing us to do the night backup : someone has left his app opened in a report preview before leaving. So the tables were opened ... Have we a way to abort the report preview window after a timer (one hour for example) ? Thanks in advance 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54118023.8030...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
using FOPEN, FGET, FPUT with an USB port
I was able to connect a display, or a balance to a fox app when I worked under DOS ... but now I must do the same thing with WIN7 or WIN8 and VFP8 and a USB port. Can someone give me the first steps to do ? I would like to use again FOPEN ... but how can we tell FOPEN that we want to work with USB ? Thanks in advance 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/540f1dba@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] A New Chapter
In my first years of computing, a long time ago, IBM stood for It's Better Manual ... Sorry Ed ! Th 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/53f7944d.5060...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: bottom of memo field
>I thought the same thing at first until I read that ADDITIVE clause. Still applies to bloat concern?? Yes ! In fact, VFP doesn't manage 'not sequential segments' (or blocs). All the memo content must be contiguous in the .fpt file. So when size increase, VFP must 'disable' the actual blocs and create new ones with the right size. I don't think either that VFP is able to decrease size of a memo without rewriting it but I never cheked that ! 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/53e8eaed.5010...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: readmethod()
Le 04/08/2014 13:52, Gérard Lochon a écrit : PS : tu reste à gamberger tout l'été au lieu d'aller te ressourcer ? En fait, j'ai déjà pris des 'vacances' en juin et je repars faire du train en Suisse en Septembre ! Ma femme est en congé depuis la semaine dernière mais on reste à Grenoble ou dans notre maison de campagne. J'ai un peu de travail (je reprend une appli d'Aumeric de gestion de cantine ...) et je découvre Foxcharts pour me détendre ! Entre ça et regarder la pluie qui tombe ! D'ailleurs je n'aime pas regarder la pluie qui tombe, je me sens tout de suite plus vieux ... Bonne journée Jean ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/53df78eb.7080...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: readmethod()
Hi Koen, I'll give a try ... but I have already done my fourteen cut and paste Thanks 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/53dcdf2c.7000...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: readmethod()
Hi Ted, Thanks for your answer. I am playing with FoxCharts and VFP. I have built a form with 14 pages (and it's growing !) and in each page there is a graph. Each graph is built only once in the activate event of the page. With FoxCharts is shipped Visual FoxCharts Designer that allows you to built or modify a graph at run time and can store the properties of the graph in the cliptext. I thought that I could allow my user to modify the graph (first because I am colour blind !). I built a table with one line per page and 3 memos : initial for my programm, modified for the modified properties and previous for the previous modified graph. User can choose the one he want. Just to avoid doing 14 cut and paste from activate to initial, I was digging readmethod ! 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/53dc8155.6010...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
readmethod()
Hi everybody, has anyone worked with readmethod() ? I would like to store in a table some methods of a form. Readmethod is supposed to work only during design time but in fact it seems to work also during run time but only form some objects : it works for form and pageframe but not for a page. If you have some infos ... Regards 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/53dc1473.3000...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL select Group by datetime field value puzzle
here is what I tried : CREATE TABLE essaisql FREE (recnum I, val N(12,6)) FOR i = 1 TO 1 INSERT INTO essaisql VALUES(i, 1000* RAND()) NEXT && i = 1 TO 1 BROWSE x = 500 SELECT INT(recnum/x) AS periode, SUM(val) AS somme, AVG(val) AS moyenne ; FROM essaisql GROUP BY periode ORDER BY periode INTO CURSOR resultat BROWSE FIELDS per = periode*x, somme, moyenne 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5395a93b.9090...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL select Group by datetime field value puzzle
Hi Joe, if you have one record per second, why not grouping on 'RECNO()' instead of the datetime field ? 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5395a75b.1040...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP6: Procedure File Blues
Le 21/04/2014 21:13, Tracy Pearson a écrit : Since this is VFP 6, I'm not sure what tool is available to you for searching your code for a "SET PROC" line. Hi Desmond, you can download the textsearch utility from Ed'site 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5355dcfb.40...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: how to simulate a ctrl+clic
Hi Gene, that's right and I already use this features in some places. But as I started again with a grid ... Thanks anyway. 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/533db6ce.8040...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: how to simulate a ctrl+clic
Hi Paul, selecting all the pupils is not the problem. The issue I want to avoid is : the operator has deselected 2 pupils and when he/she want to deselect the third one he/she forgets the CTRL Key and then all pupils are deselected and he/she must redo the work ... it's not a big problem but just an annoying one ! I am going to use a grid instead of the listbox Best Regards 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/533cefd8.3090...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: how to simulate a ctrl+clic
Hi Ted, I tried the MOUSE command but with no success (in english it seems to be 'cyclic redundancy'). So I am going to use a grid ... Thanks 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/533c15d1.5020...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
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 all the pupils (about 35). In the init of the listbox, I 'select' all the lines. If I ctrl+clic on a pupil, it becomes unselected and selected again if I redo the ctrl-clic. It's exactly what I want. It works great. But if I forgot to press the CTRL key (and it will happen very often), all the pupils become unselected at the same time and it is unbearable. I didn't find a mean to 'simulate' the CTRL key in the click event or the mousedown event ! Have you an idea ? TIA 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/533b9be8.6070...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
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 in overstrike, data would be overwritten. Fred On Tue, Mar 25, 2014 at 12:52 PM, Jean MAURICE wrote: I think the best way to do this is to do a 'good old' KEYBOARD DTOC(date()) In the F5 key ... The Foxil [excessive quoting removed by server] ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5331e689.1090...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Inserting a date
I think the best way to do this is to do a 'good old' KEYBOARD DTOC(date()) In the F5 key ... 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5331de95.2080...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Happy Pi day
Le 14/03/2014 15:33, Stephen Russell a écrit : https://www.youtube.com/watch?v=jG7vhMMXagQ she tried to write something in French ... but she was wrong ! "Ceci n'est pas PI" est mieux ! 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/53232377.3090...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: 32-bit BASIC
Hi Ted, 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 ...' !! I would have been happy to try freebasic but nowadays I have a 64 bits machine !! The Foxil Le 21/02/2014 19:40, Ted Roche a écrit : Gene: BASIC was my first computer language, mid-'70s, PDP-4 and a Commodore VIC-20. Used it for many years before I went pro, writing BASIC on WANG 2200 microcomputers. You may want to try FreeBASIC, which claims high compatibility and the ability to compile 32-bit executables: http://www.freebasic.net/ ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5307b74a.8070...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Openoffice
Le 03/02/2014 18:13, Rafael Copquin a écrit : Hi Jean Maurice You can send it to me and I shall try to translate it, if it is not too long Rafael Copquin Hi Rafael, it's so old I forgot I already put the library on the web. You can download it here : http://www.atoutfox.org/articles.asp?ACTION=FCONSULTER&ID=000490 AtoutFox is the french Fox community... 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/52f07ab6.6070...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Openoffice
Laurie, long time ago, I began to buid a library to interface VFP with Open Office. If you can read simple French, I can send it to you as 'it is'. I you can't, you'll have to wait some days that I write some english comment. When I built it, it was OpenOffice 2 (!), I don't know if it still works, but I can give a try this evening ... 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/52efcbec.9000...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Invalid Group By
and I think that in some very rare cases, complex SQL queries results with VFP9 differ from the same queries in VFP6 even if enginebehavior is set to 70. But I have no example to show. 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/52ceb884.4050...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Help with pcAnywhere
I use teamviewer but I never tried to stop the remote desktop or even the host !! It is free for a 'private usage' : http://www.teamviewer.com The Foxil PS Happy Christmas to all of you ! ___ 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/52b9b158.9010...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Finite State Machine
I think I do ! In fact I am not sure with the translation. When you have a lot of 'states' and a lot of conditions, you built an array. With one line per state and one column per condition. In each cell of this array, you get the index of the next state you must go and the name of the procedure you must execute. Is that what you are dealing with ? 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/52b2826d.6070...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [OT] For you train enthusiasts
it's such a success that some other are 'birthing' (is that clear ?) in Europe : www.kaeserberg.ch www.miniworld-lyon.com/ Best Regards 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/528f962c.3040...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Windows POP Email Client Recommendations
and what about using .. VFP ? with Winsock it works really good (in fact I only send messages (mailing campaigns) and I never try to receive them ...) and you have acces to each 'parameter' ! Francis Faure, a MVP, built a class around Winsock and I have built classes around it. 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: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5284fc02.9060...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
