ProFox May 2021

profox@leafe.com

16 participants
17 discussions

looking for a multi-user alternative to view gmail emails
by Ken McGinnis 16 Dec '21

16 Dec '21

looking for a multi-user alternative (to MS Exchange) to view gmail emails For more than 10 years I have been using a gmail account for users to send support questions. I had that gmail account linked (somehow) to MS Exchange hosted by Rackspace. This was recommended by someone on this list. It has been working for >10 years and I have long-since forgotten how I set all that stuff up. Now Rackspace no longer supports Exchange 2007 and the Outlook 2007 client that we use to access exchange and see the emails that came into gmail. Hope that makes sense. I think it should be simple to have imap and/or POP in the gmail account activated (which it/they is/areprofox(a)leafe.com) It seems like Exchange should be able to 'poll' the gmail server and download the email (hope that makes sense). Somehow the people at Rackspace don't know what I am talking about?? the support person today says I need to set up MX records in gmail so gmail will send to exchange? that does not make any sense to me. I admit that I may not be the youngest person on this list, but I am still alive and I love VFP and most of the support issues. Anyone out there know what I am missing? Thx in advance Ken -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

7 12

[NF] Desktop Development in the roaring 20s
by Stephen Russell 16 Jun '21

16 Jun '21

Most of the group will remember Robert Green. https://channel9.msdn.com/Shows/Visual-Studio-Toolbox/Choices-in-Desktop-De… An easy quick session that explains various opportunities available today. The statement Apps are Apps is so true. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

10 18

RE: Formset goofy
by Jürgen Wondzinski 27 May '21

27 May '21

Think of FormSets as a predecessor for Pageframes. It was the 2.x way of switching several Pages/Forms into the users workspace. Thus for todays UI I would recommend using a single form with embedded Pageframe. wOOdy

1 0

Formset goofy
by Joe Yoder 27 May '21

27 May '21

I have been working with two forms in a formset for the first time. All has worked out well as the two forms are simply two perspectives on the underlying data. I switch between them by turning visible on and off. One of the forms somehow got set to max width in the development environment. This is a nuisance to work with but I didn't bother to fix it until this morning. My fix was to scroll to the right bound of the screen and drag the right side of the screen to the left as far as I could and then repeat. This made it much easier to switch between the forms. In the same session I deleted a series of controls from form2 and replaced them with new ones. When I built the formset form 1 no longer has any controls showing up either in the form designer or when running the form. I Investigated and at least some of the form1 controls are still in the ,SCX. Actually I checked details in the Properties of the Formset for the missing form and discovered the Left setting was -1946 while the same setting for the present form was 8. Setting the negative value to 8 restored the missing controls. I'm quessing I inadvertently garbed the whole form rather than the right bound when I was making the screen narrower. Now my question is - is there a one click solution in the UI to correct this situation or is manual editing of the properties the best approach? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

Form designer rules?
by Joe Yoder 26 May '21

26 May '21

I want to use an sql select statement as the row source for a combo box.. - When I set the row source type to 3-SQL and enter the row source as "select space distinct from map into cursor T1" attempting to run the form results in "Program error Unrecognized command verb" - If I set the row source type to 2-Alias and the row source to T1 and put the SQL select statement into the init method of the control the Combo box populates properly. I would have expected that the system would be smart enough to run the SQl statement before trying to use it's output. Is there something else I need to call perhaps in the form init method? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 9

BONUS: $50 JOHNSON & JOHNSON Gift Card Opportunity
by Johnson & Johnson Opinion Requested 24 May '21

24 May '21

BONUS: $50 JOHNSON & JOHNSON Gift Card Opportunity http://smartsirenx.us/if7Dm_lK7pY8iqHI4Rv9PEEUMplGM58AUoMVPnOb_hDAlg3E http://smartsirenx.us/Gon8dSFaqgKYQ20M3htJlAhglnTdfVkIH2zXqTykAusQx5wS pinions and usage of online dating services also differ widely. A 2005 study of data collected by the Pew Internet & American Life Project found that individuals are more likely to use an online dating service if they use the Internet for a greater number of tasks, and less likely to use such a service if they are trusting of others. It is possible that the mode of online dating resonates with some participants' conceptual orientation towards the process of finding a romantic partner. That is, online dating sites use the conceptual framework of a "marketplace metaphor" to help people find potential matches, with layouts and functionalities that make it easy to quickly browse and select profiles in a manner similar to how one might browse an online store. Under this metaphor, members of a given service can both "shop" for potential relationship partners and "sell" themselves in hopes of finding a successful match. Attitudes towards online dating improved visibly between 2005 and 2015, the Pew Research Center found. In particular, the number of people who thought that online dating was a good way to meet people rose from 44% in 2005 to 59% in 2015 whereas those who believed that people to used online dating services were desperate fell from 29% to 23% during the same period. Although only a negligible number of people dated online in 2005, that rose to 11% in 2013 and then 15% in 2015. In particular, the number of American adults who had used an online dating site went from 9% in 2013 to 12% in 2015 while those who used an online dating software application on their mobile phones jumped from 3% to 9% during the same period. This increase was driven mainly by people aged 18 to 24, for whom usage almost tripled. At the same time, usage among those between the ages of 55 and 64 doubled. People in their mid-30s to mid-50s all saw noticeable increases in usage, but people aged 25 to 34 saw no change. Nevertheless, only one in three had actually gone out on a date with someone they met online. About one in five, especially women, at 30%, compared to 16% for men, asked for help with their online profile. Only five out of a hundred said they were married to or in a committed long-term relationship with someone they met online. For comparison, 88% of Americans who were with their current spouse or partner for no more than five years said their met their mates offline. Online daters may have more liberal social attitudes compared to the general population in the United States. According to a 2015 study by the Pew Research Center, people who had used online dating services had a higher opinion of such services than those who had not. 80% of the users said that online dating sites are a good way to meet potential partners, compared to 55% of non-users. In addition, online daters felt that online dating is easier more efficient than other methods (61%), and gives access to a larger pool of potential partners (62%), compared to 44% and 50% of non-users, respectively. Meanwhile, 60% of non-users thought that online dating was a more dangerous way of meeting people and 24% deemed people who dated online were desperate, compared to 45% and 16% of online daters, respectively. Nevertheless, a similar number of online daters (31%) and non-users (32%) agreed that online dating kept people from settling down. In all, there was little difference among the sexes with regards to their opinions on online dating. Safety was, however, the exception, with 53% of women and only 38% of men expressin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Virtual Fox Fest 2021 (Oct): Call for Speakers
by Rick Schummer 21 May '21

21 May '21

We're excited to offer you Virtual Fox Fest 2021 (October), a three-day online conference presenting the latest in Microsoft Visual FoxPro development techniques and interoperability with other technologies. This conference provides a venue for VFP developers to come together virtually to learn more about how our fellow developers are using and extending VFP. For details about Virtual Fox Fest, please see https://virtualfoxfest.com. The conference is going to be on October 14th, 20th, and 26th, 2021. We've issued the Call for Speakers (https://virtualfoxfest.com/CallForSpeakers.aspx) for Virtual Fox Fest. If you are interested in presenting, please read the document referenced in that page and consider submitting sessions. Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

Navigating structure using list boxes?
by Joe Yoder 21 May '21

21 May '21

I am an infrequent user of VFP and have never mastered the GUI. I need to allow a user to choose storage locations from the structure below for several fields on a screen where the possible choices are in a structure several layers deep. Is there a control to handle this or a simple way to roll my own? This is a simple representation of the locations to chose from.: Shop/Cabinet/Shelf1 Shop/Cabinet/ Drawer1 Shop/Bench/Shelf1 Office/Bench/Drawer1 Office/Cabinet/ Drawer1 Office/Cabinet/Shelf1 Office/Bench/Shelf1 Office/Bench/Drawer1 Trailer/Bench/Drawer1 Trailer/Cabinet/ Drawer1 Trailer/Cabinet/Shelf1 TrailerBench/Shelf1 Trailer/Bench/Drawer1 Even though the Drawers and Shelves appear to repeat they are all different and can add up to 150 choices for a location in my office. I clearly do not want to scroll through the entire list to make a choice. Any help would be appreciated. Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 3

Searching classes and forms for something specific
by Tracy Pearson 20 May '21

20 May '21

Is there a search tool out there that can search for criteria such as the following: The Column.Sparse is set to False. That same Column has a TextBox baseclass in it. I have already slowly parsed most instances of the Sparse property in my search. I know I can write something that can search for this specific query as well. I'm curious if there is a tool to help in the future. Thank you, Tracy

5 6

<> "" vs. NOT EMPTY(field1) in SQL and the former is better than the latter
by MB Software Solutions, LLC 12 May '21

12 May '21

In case you weren't aware that NOT EMPTY appears to be unable to use Rushmore optimization... There is a regular index on the order.srep field. I added the SETs to emulate the environment per legacy code. The results are why I changed the original author's NOT EMPTY(field1) SQL to field1 <> "" instead: CLEAR OPEN DATABASE c:\temp\test SHARED SET ANSI OFF SET EXACT OFF SET NEAR ON LOCAL lcOpt as String ? SYS(3054,12,"lcOpt") SELECT distinct srep FROM test!order WHERE srep <> "" INTO CURSOR crap #IF .F. Results: SELECT distinct srep FROM test!order WHERE srep <> "" INTO CURSOR crap Using index tag Srep to rushmore optimize table order Rushmore optimization level for table order: partial #ENDIF SELECT distinct srep FROM test!order WHERE NOT EMPTY(srep) INTO CURSOR crap #IF .F. Results: SELECT distinct srep FROM test!order WHERE NOT EMPTY(srep) INTO CURSOR crap Rushmore optimization level for table order: none #ENDIF -- Michael J. Babcock, MCP Fox/VFP dev since 1997 Developer of FabNet estimating software - mbsoftwaresolutions.com

1 1

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox May 2021