ProFox April 2020

profox@leafe.com

34 participants
23 discussions

[NF] Recommendations on a balance board for standup desk use
by Malcolm Greene 23 Jun '20

23 Jun '20

Any of you stand-up desk users standing on a balance-board type contraption or using a specific mat? I'm at a standup desk 8-12 hours/day and looking to improve the ergonomics of this situation. Thanks! Malcolm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 16

SQL Server Shared Management Objects (SMO)
by Paul Newton 01 May '20

01 May '20

Hi all We have been using the following to get a list of available servers loDMO = CreateObject("sqlSMO.Application") loServerList = loDMO.ListAvailableSQLServers However SQL-DMO was apparently deprecated with SQL Server 2005 and succeeded by SQL-SMO. Has anybody used SQL Server Shared Management Objects in VFP and, if so, can they please give me some pointers on what I need to install and how to implement code to replace that above. Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 13

Test
by Dave Crozier 30 Apr '20

30 Apr '20

Hi guys, Just sending an email for Ed’s benefit so he can hopefully sort out my issues posting to Profox. Hence my absence for nearly 12 months. Missing the interaction with you all and hoping you are all well. If some of you could reply to this message to confirm that I can see your responses even though I can’t see my posts to the group Thanks Dave Crozier Software Development Manager Flexipol Packaging Ltd. ﴾⚆ᨎ⚆﴿ Flexipol® Packaging Ltd T 01706 222 792 E DCrozier(a)flexipol.co.uk W https://www.flexipol.co.uk/ Follow us: Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. 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. Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received. It is the responsibility of the recipient to ensure that they have adequate virus protection. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time Disclaimer The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful. This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/jpeg image/jpeg image/png image/png image/png image/png ---

10 16

Getting list of SQL Servers on a network
by Paul Newton 30 Apr '20

30 Apr '20

Hi all Using code examples from the internet I have tried three different ways of getting a list of SQL Servers on the network: NetServerEnum (Win32 API) SQLBrowseConnect (ODBC32) SmoApplication.EnumAvailableSqlServers None of the methods returns anything and I am beginning to suspect that this is because I am using a VPN connection. Does that seem likely? Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Re: [NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April
by Eric Selje 29 Apr '20

29 Apr '20

Quick question as I think about this tutorial. Would the emphasis be on how to create an app from scratch with X#, or should I create a To-Do List in VFP first and then convert that? E On Mon, Apr 27, 2020 at 8:27 AM Eric Selje <Eric(a)saltydogllc.com> wrote: > I think Visual Studio is now their preferred option as well. Let me see > what I can put together. Maybe I'll use Rick Strahl's To-Do app as a basis. > > E > > > On Sat, Apr 25, 2020 at 9:18 AM Alan Bourke <alanpbourke(a)fastmail.fm> > wrote: > >> Thanks. >> >> Well, I'm used to things like: >> https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=a… >> >> Personally I would be interested in it from within Visual Studio however >> if the native IDE is a better option then that's fine. >> >> Really it would be something like a little to-do list, Visual Foxpro >> syntax, data in DBF files, using indexes etc. >> >> I spent quite a while one day trying to figure out how to just open a DBF >> file with it and gave up. There is a lot of assumed knowledge. >> >> -- >> Alan Bourke >> alanpbourke (at) fastmail (dot) fm >> [excessive quoting removed by server]

3 4

GoFish problem
by Paul Newton 29 Apr '20

29 Apr '20

Hi all I have been happily using GoFish (4.3) for years but today when I tried to run it (in VFP9 SP2) the cursor changes to that circular one which appears when Fox is busy and GoFish refuses to load. Fox also displays eventually as Not Responding. Any ideas/suggestions? Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

10 24

[NF] X# Live 30 April and weekly from now
by Johan Nel 29 Apr '20

29 Apr '20

We have scheduled another online event, this time using Zoom. During this meeting we will look at the XSharp Runtime State. Topic: Exploring XSharp Runtime State Time: Apr 30, 2020 04:00 PM Amsterdam, Berlin, Rome, Stockholm, Vienna We plan for 30 minutes, but our schedule allows to extend that when needed. Join Zoom Meeting https://us02web.zoom.us/j/83219835339 Meeting ID: 832 1983 5339 Please note that if you do not have Zoom installed you will be invited to download an exe. Even though the name may look like a Virus, it is not. We are not sure why zoom generates file names like that: Zoom_o42a8sofizku_643cd2774e61398f.exe You can also choose to join the meeting in your browser, so you do not have to install anything Next week (May 7, same time) we will look into new features inside the X# language. An invitation will be published here. Johan Nel George, South Africa.

1 0

[ADMIN] Upgraded server
by Ed Leafe 27 Apr '20

27 Apr '20

Over the weekend I upgraded the mail server from Ubuntu 18.04 to 20.04, and there have been some issues with mis-matched versions and libraries. If you have tried to send a message in the last few days, please check the archive (https://leafe.com/archives) to verify that it was posted. I *think* I have all the kinks worked out, but please let me know off-list about any problems you run into. — Ed

1 0

AddObject/BindEvent Question
by Paul H. Tarver 27 Apr '20

27 Apr '20

I'm probably missing something obvious here or being thickheaded about this, but here's my situation: I have a standard lookup button class I use all the time that I drop onto a form, set several properties, do a simple query to create a picklist and then it uses CREATEOBJECT to create a simple form from my class library, then it uses ADDOBJECT to add a Grid from the class library and Select/Cancel buttons to the form. After creating the grid, I loop through the fields in the picklist and setup the columns in the grid. I use BINDEVENT to provide the functionality to the click event of each button and the dblclick event of the grid columns. This class has worked perfectly for many years and is easy to use and include whenever I want a simple look up for a single selection from the picklist by the user. However, today I was trying to add some functionality to the class by adding a checkbox in the first column of the grid to allow users to make multiple selections from the picklist. Adding a 'Sel' field to the query and setting the resulting cursor to READWRITE was easy enough. Displaying the checkbox in the generated grid was also easy. I set the readonly propery for the grid, the column and the checkbox to .f. and everything displays correctly but no matter what I do, when I click on the checkbox, nothing happens. I've confirmed the cursor is readwrite at runtime. I've monitored readonly properties all the way to the moment the .show() method is called to display the picklist form and they all are .f. until after the .show() method executes. I've traced the code for all the parent elements and can find no other place where any readonly properties are being set to .t. My question is this: If I'm using ADDOBJECTS and BINDEVENT commands to create this picklist form, do I need to create a procedure specifically for the CLICK event of the checkbox to issue a DODEFAULT() command and then bind that to the Click Event manually or will the checkbox just automatically use the base CLICK event code from the parent class? I haven't worked with ADDOBJECTS and BINDEVENT commands often (the last time was probably when I wrote the original code for the picklist class I'm trying to modify) and I'm not sure this makes sense, but after a couple of hours failure, I decided to give up and ask for help. Thanks in advance! Paul H. Tarver --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

[NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April
by Johan Nel 25 Apr '20

25 Apr '20

Hope this is of interest to some. Today we have released a new installer for XSharp Bandol 2.4 to our FOX subscribers. This build contains several fixes to issues reported by our customers and also support for most of the SQL..() functions for the FoxPro dialect. The what's new document describing all the changes can be found here: https://www.xsharp.info/component/rsfiles/download?path=general%252FReadme%… On Thursday April 23 at 16:00 Amsterdam time Robert will do a short online demo of some of the new features in this build. You can follow this event online or with Microsoft Teams <https://teams.microsoft.com/l/meetup-join/19%3ameeting_NTk3NWE4NDgtNDgyNy00…> . https://teams.microsoft.com/l/meetup-join/19%3ameeting_NTk3NWE4NDgtNDgyNy00… The recording of the event will be uploaded to our YouTube channel afterwards. A public build for version 2.4 is scheduled for next week. Johan Nel --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 5

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox April 2020