ProFox June 2024

profox@leafe.com

13 participants
10 discussions

Combo box issues
by Joe Yoder 27 Jun '24

27 Jun '24

I am looking for a way to have a combo box display its dropdown programmatically. I want to do this to make it obvious that the user needs to make a choice. I have read that 'thisform.combobox.dropdown()' should do the trick but the form comes up with the proper information in the dropdown which can only be seen after clicking the control. Another less important feature would be a way to control the position of the list of choices when the dropdown is accessed. Any help will be appreciated, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 3

Southwest Fox 2024: Super-saver Deadline Approaches
by Rick Schummer 27 Jun '24

27 Jun '24

Hear that sound? Tick, tick, tick, tick... That's the countdown clock at Geek Gatherings getting closer to the Super-saver deadline for Southwest Fox! June 30th is this Sunday and we thought we would pass along one more reminder just in case you forgot to add it your reminder list or put a yellow sticky note on your monitor. We still need people to register to make the in-person side of the conference happen. Urgent: do not make plane reservations until we announce the decision for the in-person conference, which we expect to make in the coming weeks. The conference takes place September 26-29, 2024 in Scottsdale, Arizona and we really hope you can be there. If you really want to attend in-person, we would hate to see you miss out on a seat in the room (the in-person limit is 40 registrations). Whether you plan to attend in-person or virtually, surely you don't to lose out on the Super-saver discount ($200 for in-person or $100 for virtual). Head over to the registration Web site today: https://geekgatherings.com/Registration If you've already registered, we thank you. Please help us remind fellow developers who have been procrastinating about the looming deadline by sharing this email, spreading it on social media, or posting on a forum how great a previous Southwest Fox or Virtual Fox Fest conference was for you? You can also spread the word by telling others you're going on our Facebook event. Nitty-Gritty Details Check out our list of amazing speakers (https://swfox.net/speakers.aspx) and dig into our sessions (https://swfox.net/sessions.aspx) Follow the news (https://swfox.net/news.aspx) about the conference and our blog (https://swfox.net/blog/) Southwest Fox 2023 Videos We plan to release the videos for the following sessions in early July on our YouTube channel (https://www.youtube.com/@geekgatherings) * Advanced Reporting with Microsoft Excel * ParallelFox 2.0 * Logging: Clear Cut Solutions for Your Apps As an added incentive, if the Early-Bird registrations are good (meaning we are not chewing our fingernails), we will also release these sessions at the same time: * Optimize Your IDE: Take Full Advantage of Thor Tools Part 1 *Team Git: Collaboration Made Easy * Modern Authentication with VFP Contact Us Interested in being a sponsor? Contact our sponsor representative: sponsors(a)geekgatherings.com If you have ideas or suggestions for this year's Southwest Fox, please email them to: info(a)geekgatherings.com If you have a friend who wants to be on our mailing list, please tell them to go to the conference home page and sign up https://swfox.net. Call: 586.254.2530 Please beat the rush so we still have some fingernails left when July begins! We appreciate all the support people have shown for the in-person conference with early registrations. We look forward to getting many more this week as we get closer to make the "in-person go" decision; otherwise, we will be all virtual. If you're planning to attend the virtual conference, please register now as it helps in our decision-making process. Rick White Light Computing, Inc.

1 0

Combobox followup
by Joe Yoder 19 Jun '24

19 Jun '24

Thanks Eric for the input. I think I have correctly made the changes you suggested but the code fails with "Unknown member oComboBox" Here is the code as I have it now: * Procedure to add a ComboBox to the form PROCEDURE AddComboBoxToForm(toForm, nTop, nLeft, cname) LOCAL oComboBox oComboBox = CREATEOBJECT("ComboBox") oComboBox.AddItem("Item 1") oComboBox.AddItem("Item 2") toForm.oComboBox.Top = nTop toForm.oComboBox.Left = nLeft toForm.oComboBox.Visible = .T. toForm.AddObject(cname, "oComboBox") ENDPROC For some reason I need to go to the archive to get any responses to my post so this will appear as a new thread. Thanks again, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 4

Re: VFP 8, ODBC connection to Azure SQL Server Pausing
by Philip Borkholder 18 Jun '24

18 Jun '24

Thanks everyone, I'm going to try some of this. Ted, I always thought we needed a connection before using the SQLSETPROP(). Thankyou for the advice on 0 for default! This should help. -Philip ---------- Original Message ---------- From: Ted Roche <tedroche(a)gmail.com> To: profoxtech(a)leafe.com Subject: Re: VFP 8, ODBC connection to Azure SQL Server Pausing Date: Tue, 18 Jun 2024 17:19:43 -0400 IIRC* SQLSetProp() accepts a handle number as its first parameter; sending a 0 sets the default/global setting. See: https://hackfox.github.io/section4/s4g399.html ** * This year on April 1st (no foolin') was the 30th anniversary of the release of HackFox3! (and it's been nearly 20 years since I was actively developing in VFP, but I did co-author the VFP Distributed certification exam and LEARNED that stuff!) ** This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. On Tue, Jun 18, 2024 at 2:24 PM Philip Borkholder <plborker(a)netzero.net> wrote: > Hi Tracy, > The SQLSETPROP() works once there is a connection I believe. > SQLSTRINGCONNECT() also returns a negative 1 however, the ODBC Login > screen pops up before that return. > I'm trying to figure out a way to hide/stop that annoying ODBC SQL Login > prompt. :-) > > I think I'm going to see if the ConnectTimeOut can be added in the > connection string. > > Thank you, > > ---------- Original Message ---------- > From: "Tracy Pearson" <tracy(a)powerchurch.com> > To: profoxtech(a)leafe.com > Subject: RE: VFP 8, ODBC connection to Azure SQL Server Pausing > Date: Tue, 18 Jun 2024 10:18:04 -0400 > > I haven't worked with Azure SQL. > > You could set some setting with SQLSETPROP() Function > Look at ConnectTimeOut and DispLogin settings. > > The SQLConnect function returns a -1 when the connection isn't created. > > HTH, > Tracy > > > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Philip > Borkholder > Sent: Tuesday, June 18, 2024 9:34 AM > To: profoxtech(a)leafe.com > Subject: VFP 8, ODBC connection to Azure SQL Server Pausing > > Hello, > > I have been having issues with MS Azure SQL Server going to a "pause state" > at night after no activity. > Then when I try to connect with : > > lnConnection = SQLSTRINGCONNECT(lcConnString,.T.) > > > Because the Azure SQL Server is paused, the SQLSTRINGCONNECT() times out > and > prompts with the ODBC failed to connect and SQL Server login prompt. > > This is annoying when I don't want that to pop up because the end user will > not know what to do. > All the help online just says an Azure SQL Server resumes once an attempt > to > connect is made... > > Does anyone have any experience with this? > > Is it a timeout issue that we can set in our connection string? > Is there a setting on the Azure SQL server we need to set to not allow it > to > pause? > > Thanks for any guidance, > > Philip Borkholder > Bison Tech Plus > Vicksburg, MI > > > [excessive quoting removed by server]

1 0

RE: VFP 8, ODBC connection to Azure SQL Server Pausing
by Philip Borkholder 18 Jun '24

18 Jun '24

Hi Tracy, The SQLSETPROP() works once there is a connection I believe. SQLSTRINGCONNECT() also returns a negative 1 however, the ODBC Login screen pops up before that return. I'm trying to figure out a way to hide/stop that annoying ODBC SQL Login prompt. :-) I think I'm going to see if the ConnectTimeOut can be added in the connection string. Thank you, ---------- Original Message ---------- From: "Tracy Pearson" <tracy(a)powerchurch.com> To: profoxtech(a)leafe.com Subject: RE: VFP 8, ODBC connection to Azure SQL Server Pausing Date: Tue, 18 Jun 2024 10:18:04 -0400 I haven't worked with Azure SQL. You could set some setting with SQLSETPROP() Function Look at ConnectTimeOut and DispLogin settings. The SQLConnect function returns a -1 when the connection isn't created. HTH, Tracy -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Philip Borkholder Sent: Tuesday, June 18, 2024 9:34 AM To: profoxtech(a)leafe.com Subject: VFP 8, ODBC connection to Azure SQL Server Pausing Hello, I have been having issues with MS Azure SQL Server going to a "pause state" at night after no activity. Then when I try to connect with : lnConnection = SQLSTRINGCONNECT(lcConnString,.T.) Because the Azure SQL Server is paused, the SQLSTRINGCONNECT() times out and prompts with the ODBC failed to connect and SQL Server login prompt. This is annoying when I don't want that to pop up because the end user will not know what to do. All the help online just says an Azure SQL Server resumes once an attempt to connect is made... Does anyone have any experience with this? Is it a timeout issue that we can set in our connection string? Is there a setting on the Azure SQL server we need to set to not allow it to pause? Thanks for any guidance, Philip Borkholder Bison Tech Plus Vicksburg, MI [excessive quoting removed by server]

4 3

VFP 8, ODBC connection to Azure SQL Server Pausing
by Philip Borkholder 18 Jun '24

18 Jun '24

Hello, I have been having issues with MS Azure SQL Server going to a "pause state" at night after no activity. Then when I try to connect with : lnConnection = SQLSTRINGCONNECT(lcConnString,.T.) Because the Azure SQL Server is paused, the SQLSTRINGCONNECT() times out and prompts with the ODBC failed to connect and SQL Server login prompt. This is annoying when I don't want that to pop up because the end user will not know what to do. All the help online just says an Azure SQL Server resumes once an attempt to connect is made... Does anyone have any experience with this? Is it a timeout issue that we can set in our connection string? Is there a setting on the Azure SQL server we need to set to not allow it to pause? Thanks for any guidance, Philip Borkholder Bison Tech Plus Vicksburg, MI

3 2

Programatically generated Combo boxes
by Joe Yoder 17 Jun '24

17 Jun '24

I have been trying to come up with simple code to let me generate and configure ComboBoxes in code. I have succeeded in creating one combo and controlling its top and left properties by passing parameters but when I try to pass in a name things don't work. Here is the procedures code in a file named Try: * Procedure to create a form PROCEDURE CreateForm PUBLIC oForm oForm = CREATEOBJECT("Form") oForm.Caption = "My Form" oForm.Show() ENDPROC * Procedure to add a ComboBox to the form PROCEDURE AddComboBoxToForm(toForm, nTop, nLeft, cname) LOCAL oComboBox oComboBox = CREATEOBJECT("ComboBox") oComboBox.AddItem("Item 1") oComboBox.AddItem("Item 2") * toForm.AddObject("oComboBox", (cname)) toForm.oComboBox.name = cname toForm.oComboBox.Top = nTop toForm.oComboBox.Left = nLeft toForm.oComboBox.Visible = .T. ENDPROC The code that calls it in a file named Joe follows: * Call the procedures from the first file DO try && load the procedures * Create a form CreateForm() * Add a ComboBox to the form at position (40, 40) AddComboBoxToForm(oForm, 40, 40, "oComboBox1") * Add a second ComboBox to the form at position (80, 80) AddComboBoxToForm(oForm, 80, 80, "oComboBox2") I have been working with CoPilot to generate the code but it keep telling me that I need to create a custom class using the visual tools. I would appreciate a second opinion from real experts! Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

ODBC / VFPA / 64 Bit
by Chris Davis 12 Jun '24

12 Jun '24

Hi All Does the 64Bit VFPA imply that if not already a 64Bit ODBC driver could be provided? Are their any alternatives, we have tried the paid for DevArt one but get mixed results. TIA Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

Southwest Fox 2024: Registration opens!
by Rick Schummer 04 Jun '24

04 Jun '24

We have officially opened registration for Southwest Fox 2024! The highly acclaimed developer conference is September 26-29, 2024. Southwest Fox is a hybrid conference: in-person and virtual. The in-person event will be held at the Hampton Inn & Suites Phoenix-Scottsdale, the same location as last year, in the Phoenix suburb of Scottsdale. The virtual event will use the RingCentral platform (the same platform we use for Virtual Fox Fest). All sessions will be presented in a single room and will be streamed to the virtual event and recorded. This year we plan to add a second screen so people can see the presentations easier from the back of the room. The in-person conference room is small, so we have to limit registrations for the in-person event to the first 40 people who register. Those who are not in the first 40 will be added to a wait list or can decide to register for the virtual event. The virtual side of Southwest Fox can handle an unlimited number of attendees. If you really want to attend in-person, we suggest you register as soon as practical. Super-Saver Registration for in-person, which saves you $200 (or $100 for virtual), is available only through June 30th, so don't wait. Head over to the registration Web site today: https://geekgatherings.com/Registration. You'll have to select either the in-person event or the virtual event. Registration fees start at $599 for in-person and $349 for virtual. More details are available on the conference's registration page. Important hotel details: We have a limited number of rooms at the hotel for those attending in-person. We will send you the link once we process your registration. Flights Please do NOT book your flights yet. Our hotel contract gives us some flexibility to see how registration is going before we're absolutely committed. We'll let you know when it's time to book. Here is what you can expect from Southwest Fox: * Terrific selection of sessions from great presenters. * A total of 15 regular conference topics to pack your days with learning opportunities and inspiration. * Half-days on Thursday and Sunday for a more relaxed schedule and to make it easier for the virtual attendees. * Lunch Friday and Saturday for all in-person attendees. The conference website has been updated with this year's information and includes: * News about the sessions and speakers. * The general schedule. * Specifics about the conference hotel. * The conference blog where you can find our thoughts and perspectives. * The link to our X (Twitter) feed. * Opportunities for conference sponsorship. * Ways you can help us promote the conference. Contact Us * Interested in being a sponsor? Contact our sponsor representative: sponsors(a)geekgatherings.com * If you have ideas or suggestions for this year's Southwest Fox, please email them to: info(a)geekgatherings.com. * If you have a friend who wants to be on our mailing list, please tell them to go to the conference home page and sign up: https://swfox.net Make sure to share the news about the conference to all your developer friends. We appreciate any help with marketing and word of mouth is one of the best ways to spread the news about our conference. Rick Schummer White Light Computing, Inc.

1 0

ProFox List Statistics for May 2024
by List Administrator Account 01 Jun '24

01 Jun '24

================================================== ProFox List Statistics May 2024 ================================================== Subscriber Count at End of Month: ProFox: 306 ProFoxTech: 184 ================================================== Total Posts: 10 (Down 66.67% from April 2024) Total [OT] Posts: 0 (Unchanged from April 2024) Total [NF] Posts: 0 (Unchanged from April 2024) Daily Message Counts for May 2024 ------------------------------------------------ DOW Date Count --- ---- ----- W 1 - 1 M 20 - 1 T 21 - 1 S 26 - 3 T 28 - 4 Message Counts By Day of Week for May 2024 ------------------------------------------------ DOW Count --- ----- Sun - 3 Mon - 1 Tue - 5 Wed - 1 Distinct Posters to the List (changes relative to April 2024) ------------------------------------------------ Non-OT messages: 7 (Down 58.82%) OT messages: 0 (Unchanged) NF messages: 0 (Unchanged) Total number: 7 (Down 58.82%) Top 7 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 4 Ken Watkins 2. 1 List Administrator Account 3. 1 MB Software Solutions, LLC 4. 1 Kevin Cully 5. 1 Richard Quilhot 6. 1 Tracy Pearson 7. 1 Alan Bourke Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 0 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ Top 7 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 4 Ken Watkins 2. 1 List Administrator Account 3. 1 MB Software Solutions, LLC 4. 1 Kevin Cully 5. 1 Richard Quilhot 6. 1 Tracy Pearson 7. 1 Alan Bourke Top 3 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 4 Ken Watkins 2. 1 List Administrator Account 3. 1 MB Software Solutions, LLC Top 5 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 3 Re[2]: Network issue 2. 3 Network issue 3. 2 Anybody else get this junk mail with the Fox icon? 4. 1 ProFox List Statistics for April 2024 5. 1 Re[4]: Network issue Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 5 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 3 Re[2]: Network issue 2. 3 Network issue 3. 2 Anybody else get this junk mail with the Fox icon? 4. 1 ProFox List Statistics for April 2024 5. 1 Re[4]: Network issue

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox June 2024