[NF] INT vs MEDIUMINT vs SMALLINT vs TINYINT

2017-10-27 Thread mbsoftwaresolutions
Ok, in today's "the sky is the limit" (in terms of space), do we really care about 1 or 2 bytes for an integer field type for a primary key? I'm redesigning FabMate Classic to use a MySQL (MariaDB) database backend now because my client is still experiencing problems with the VFP database

RE: [NF] LogMeIn -- Richard

2017-10-27 Thread mbsoftwaresolutions
On 2017-10-27 16:54, Richard Kaye wrote: Pro. I never tried or really needed the Rescue product. I have installations in over 60 locations round the world and need permanent access to all my client locations for support and updates. I'm using LMI, RDP, Teamviewer, SplashDesktop and a few others

RE: [NF] LogMeIn -- Richard

2017-10-27 Thread Richard Kaye
Oh yeah. And too many different VPN clients... Windows, Cisco, Sophos, SonicWall... -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, October 27, 2017 4:55 PM To: profoxt...@leafe.com Subject: RE: [NF] LogMeIn --

RE: [NF] LogMeIn -- Richard

2017-10-27 Thread Richard Kaye
Pro. I never tried or really needed the Rescue product. I have installations in over 60 locations round the world and need permanent access to all my client locations for support and updates. I'm using LMI, RDP, Teamviewer, SplashDesktop and a few others but my preference is still LMI. For

[NF] LogMeIn -- Richard

2017-10-27 Thread mbsoftwaresolutions
What version are you using, Richard? LMI Pro, or LMI Rescue? ___ 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

Re: WG: recno() function in tsql

2017-10-27 Thread Rafael Copquin
That works for dbf tables, but not for SQL Server tables Thanks Rafael Copquin El 27/10/2017 a las 14:40, AndyHC escribió: fwiw this works - (use dbc, remote view, cursor adaptor, w.h.y for line 1  :- SELECT * FROM somewhere WHERE type = "myType" INTO CURSOR tmp SELECT RECNO() as id, *

Re: WG: recno() function in tsql

2017-10-27 Thread AndyHC
fwiw this works - (use dbc, remote view, cursor adaptor, w.h.y for line 1  :- SELECT * FROM somewhere WHERE type = "myType" INTO CURSOR tmp SELECT RECNO() as id, * FROM tmp ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

2017-10-27 Thread Richard Kaye
One thing I find myself doing when using other remote access solutions is logging in to my computer with LMI from the client system just to use its file manager. As long as I can run a browser, of course, which isn't always the case. -- rk -Original Message- From: ProfoxTech

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

2017-10-27 Thread Richard Kaye
If you don't have significant file transfer needs than LMI is less attractive. Having said that I don't think the 2 seat Pro license is so terribly expensive for small businesses. The idea is to get the client to buy and manage that instead of me. It's true that after many years of giving

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

2017-10-27 Thread mbsoftwaresolutions
On 2017-10-27 10:39, Richard Kaye wrote: It's stable and has been for a while now but the UI still blows, Dave.  No drag and drop between host and remote. No diffing or syncing or replication options. It's modal. It's not keyboard friendly at all. No hot keys. And LMI's compression algorithms

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

2017-10-27 Thread mbsoftwaresolutions
On 2017-10-27 10:30, Richard Kaye wrote: It does the job but if you have file transfer needs that are even mildly complex it still pales in comparison to LMI. Agreed...the version my team has doesn't do file transfer, so I had to use my website as an interim spot. Typically I use TeamViewer

Re: VFP, Authorize.net

2017-10-27 Thread Vince Teachout
Thank you all so much! I've forwarded the answers to the person who asked, and I'm sure they'll be able to use them. Thank you! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

2017-10-27 Thread Richard Kaye
It's stable and has been for a while now but the UI still blows, Dave.  No drag and drop between host and remote. No diffing or syncing or replication options. It's modal. It's not keyboard friendly at all. No hot keys. And LMI's compression algorithms are way faster. But as a remote access

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

2017-10-27 Thread Dave Crozier
Richard, The file transfer facility has been radically improved in the latest release. It is now quick and stable. Dave --- This communication and the information it contains is intended for the person or organisation to whom it is

RE: recno() function in tsql

2017-10-27 Thread Richard Kaye
Now we're all really happy you've joined us, wOOdy. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: Friday, October 27, 2017 7:02 AM To: profoxt...@leafe.com Subject: AW: recno() function in tsql ... Old farts stink

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

2017-10-27 Thread Richard Kaye
It does the job but if you have file transfer needs that are even mildly complex it still pales in comparison to LMI. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Friday, October 27, 2017

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

2017-10-27 Thread mbsoftwaresolutions
On 2017-09-19 07:35, Richard Kaye wrote: Several of my clients have settled on Splashtop as an LMI replacement - Used Splashtop last night to remotely support a client. Very nice and simple! ___ Post Messages to:

Re: AW: FoxPro DevCon in Frankfurt

2017-10-27 Thread Thierry Nivelet
eg. licensing issue for so called 'VFP10' https://support.west-wind.com/Thread5120SNVGY.wwt#51N04RTPH Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/ Le 27/10/2017 à 12:50, Ted Roche a écrit : On Fri, Oct 27, 2017 at 5:36 AM, Thierry Nivelet

Re: AW: FoxPro DevCon in Frankfurt

2017-10-27 Thread John Weller
Or in the cloud perhaps? :-) John Weller 01380 723235 079763 93631 Sent from my iPad > On 27 Oct 2017, at 10:36, Thierry Nivelet wrote: > > There are interesting subjects in the VFP world that could draw enough > audience to sustain the conference; it's just a matter

RE: recno() function in tsql

2017-10-27 Thread Jean Laeremans
Rofl On Oct 27, 2017 12:38 PM, "Dave Crozier" wrote: > Fools seldom differ of course > > Dave > > > > --- > This communication and the information it contains is intended for the > person or organisation to

AW: recno() function in tsql

2017-10-27 Thread Jürgen Wondzinski
... Old farts stink alike ... :) wOOdy -Ursprüngliche Nachricht- Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Dave Crozier Gesendet: Freitag, 27. Oktober 2017 12:38 An: ProFox Email List Betreff: RE: recno() function in tsql Fools seldom differ of

Re: AW: FoxPro DevCon in Frankfurt

2017-10-27 Thread Ted Roche
On Fri, Oct 27, 2017 at 5:36 AM, Thierry Nivelet wrote: > There are interesting subjects in the VFP world that could draw enough > audience to sustain the conference; it's just a matter of thinking out of > the box. > Out of which box are you thinking? Perhaps you should

Re: [NF] Windows 10 phone to join VFP in the graveyard

2017-10-27 Thread Ted Roche
On Fri, Oct 27, 2017 at 1:05 AM, Paul Hemans wrote: > Add the Kinect to the list. Most people would equate it with gaming, it was > more than just that it industrial applications. Well it used to. > http://fox.wikis.com/wc.dll?Wiki~MicrosoftBandWagon~Wiki And another

RE: recno() function in tsql

2017-10-27 Thread Dave Crozier
Fools seldom differ of course Dave --- 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

AW: recno() function in tsql

2017-10-27 Thread Jürgen Wondzinski
Yep. Great minds think alike :) wOOdy -Ursprüngliche Nachricht- Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Dave Crozier Gesendet: Freitag, 27. Oktober 2017 11:42 An: ProFox Email List Betreff: RE: recno() function in tsql Same solution as I posted

RE: recno() function in tsql

2017-10-27 Thread Dave Crozier
;-) Dave --- 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

AW: recno() function in tsql

2017-10-27 Thread Jürgen Wondzinski
Somehow Rafael replied to my private email address, not to ProFox. I forwarded the relevant parts now to the list :) -Ursprüngliche Nachricht- Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Stephen Russell Gesendet: Donnerstag, 26. Oktober 2017 22:15 An: ProFox Email List

RE: recno() function in tsql

2017-10-27 Thread Dave Crozier
Same solution as I posted earlier Dave --- 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

WG: recno() function in tsql

2017-10-27 Thread Jürgen Wondzinski
Von: rafael.copquin [mailto:rafael.copq...@gmail.com] Gesendet: Donnerstag, 26. Oktober 2017 22:09 An: Jürgen Wondzinski Betreff: RE: AW: AW: recno() function in tsql That's it. Thank you Rafael Enviado desde mi dispositivo Samsung Mensaje original

AW: recno() function in tsql

2017-10-27 Thread Jürgen Wondzinski
-Ursprüngliche Nachricht- Von: Jürgen Wondzinski [mailto:juer...@wondzinski.de] Gesendet: Donnerstag, 26. Oktober 2017 17:19 An: 'Rafael Copquin' Betreff: AW: AW: recno() function in tsql Hi Rafael, ah, you want a freshly generated SEQUENCE number of your

WG: recno() function in tsql

2017-10-27 Thread Jürgen Wondzinski
-Ursprüngliche Nachricht- Von: Rafael Copquin [mailto:rafael.copq...@gmail.com] Gesendet: Donnerstag, 26. Oktober 2017 17:09 An: Jürgen Wondzinski Betreff: Re: AW: recno() function in tsql Hi Woody It's been a long time! Welcome back! FYI, I always build all my

Re: AW: FoxPro DevCon in Frankfurt

2017-10-27 Thread Thierry Nivelet
There are interesting subjects in the VFP world that could draw enough audience to sustain the conference; it's just a matter of thinking out of the box. Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/ Le 26/10/2017 à 11:17, Jürgen Wondzinski a

Re: VFP, Authorize.net

2017-10-27 Thread Thierry Nivelet
Hi Vince, Based on the API doc (https://developer.authorize.net/api/reference/) you can do all transactions from VFP using West-Wind Internet Client tools. All transactions go to the same end point (https://apitest.authorize.net/xml/v1/request.api for testing), which makes it fairly easier.