Re: AW: FoxPro DevCon in Frankfurt

[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 écrit :

Hi Dave,

not sure if there will be another VFP DevCon in Germany next year.  Rainer (the 
organizer) is somewhat "frustrated" currently.
The Alaska (XBase++) group has cancelled their part of the conferences (both in 
USA and Germany), which reduces the overall count of attendees.
For hotels and and organzing you need a substancial count of attendees; if you 
fail to reach the break-even, it doesn't make sense to loose money.   It really 
couldn't hurt to spread the word in your local groups...

wOOdy



-Ursprüngliche Nachricht-
Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Dave Crozier
Gesendet: Donnerstag, 26. Oktober 2017 10:10
An: ProFox Email List
Betreff: RE: FoxPro DevCon in Frankfurt

Would love to come Jurgen, if only to re-ignite some old friendships but not 
enough notice to kick the bean counters into passing the capex!

Hope you have a great conference and keep us posted so next year can be 
scheduled in.

Dave





[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/b47bd61f-ca82-fdf0-7097-99a33758b...@foxincloud.com
** 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.

WG: recno() function in tsql

[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 tables with autoincrementing primary keys. In 
this particular case the table I am dealing with has 1 records. The 
primary keys go from 1 to 1.

But i want to select a small set based on a date range (it is a sales table)

I just want the first column of the selected cursor to contain the 
record number and the other columns the rest of the data.

So I should be getting something like this:

RecordNoIDDate   etc

15421   2017-06-15

25422   2017-06-15

35423   2017-06-16

etc

Rafael



El 26/10/2017 a las 12:00, Jürgen Wondzinski escribió:
> In SQL each record has to have a PrimaryKey (Field) for identifying it, since 
> SQL doesn't know of records, it knows about result-sets instead.
>
> The RECNO() in xBase is just the same concept: a unique identifier for the 
> current session, not meant for a longterm relation setting.  If you designed 
> your SQL table without a unique identifier, then you're out of luck :)
>
>
> wOOdy
>
> -Ursprüngliche Nachricht-
> Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Rafael Copquin
> Gesendet: Donnerstag, 26. Oktober 2017 16:34
> An: profox
> Betreff: recno() function in tsql
>
> Is there an equivalent to the VFP recno() function in T-SQL?
>
> I'd like to create the following select statement in T-SQL:
>
> select recno(),otherfields. from database.dbo.table
>
> If there is not, what would be a substitute?
>
> Rafael Copquin
>
>
>
[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/01a301d34f07$8964b400$9c2e1c00$@wondzinski.de
** 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.

AW: recno() function in tsql

[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 foundset.
See this:

https://stackoverflow.com/questions/1310/how-can-i-create-a-temporary-sequence-column-in-my-sql-query-result

wOOdy


-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 tables with autoincrementing primary keys. In
this particular case the table I am dealing with has 1 records. The
primary keys go from 1 to 1.

But i want to select a small set based on a date range (it is a sales table)

I just want the first column of the selected cursor to contain the
record number and the other columns the rest of the data.

So I should be getting something like this:

RecordNoIDDate   etc

15421   2017-06-15

25422   2017-06-15

35423   2017-06-16

etc

Rafael



El 26/10/2017 a las 12:00, Jürgen Wondzinski escribió:
> In SQL each record has to have a PrimaryKey (Field) for identifying it, 
> since SQL doesn't know of records, it knows about result-sets instead.
>
> The RECNO() in xBase is just the same concept: a unique identifier for the 
> current session, not meant for a longterm relation setting.  If you 
> designed your SQL table without a unique identifier, then you're out of 
> luck :)
>
>
> wOOdy
>
> -Ursprüngliche Nachricht-
> Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Rafael 
> Copquin
> Gesendet: Donnerstag, 26. Oktober 2017 16:34
> An: profox
> Betreff: recno() function in tsql
>
> Is there an equivalent to the VFP recno() function in T-SQL?
>
> I'd like to create the following select statement in T-SQL:
>
> select recno(),otherfields. from database.dbo.table
>
> If there is not, what would be a substitute?
>
> Rafael Copquin
>
>
>
[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/01a501d34f07$9f716310$de542930$@wondzinski.de
** 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.

WG: recno() function in tsql

[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 
De: Jürgen Wondzinski  
Fecha: 26/10/2017 12:18 (GMT-03:00) 
A: 'Rafael Copquin'  
Asunto: AW: AW: recno() function in tsql 

Hi Rafael,

ah, you want a freshly generated SEQUENCE number of your foundset. 
See this:

https://stackoverflow.com/questions/1310/how-can-i-create-a-temporary-sequence-column-in-my-sql-query-result

wOOdy


-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 tables with autoincrementing primary keys. In 
this particular case the table I am dealing with has 1 records. The 
primary keys go from 1 to 1.

But i want to select a small set based on a date range (it is a sales table)

I just want the first column of the selected cursor to contain the 
record number and the other columns the rest of the data.

So I should be getting something like this:

RecordNoIDDate   etc

15421   2017-06-15

25422   2017-06-15

35423   2017-06-16

etc

Rafael



El 26/10/2017 a las 12:00, Jürgen Wondzinski escribió:
> In SQL each record has to have a PrimaryKey (Field) for identifying it, since 
> SQL doesn't know of records, it knows about result-sets instead.
>
> The RECNO() in xBase is just the same concept: a unique identifier for the 
> current session, not meant for a longterm relation setting.  If you designed 
> your SQL table without a unique identifier, then you're out of luck :)
>
>
> wOOdy
>
> -Ursprüngliche Nachricht-
> Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Rafael Copquin
> Gesendet: Donnerstag, 26. Oktober 2017 16:34
> An: profox
> Betreff: recno() function in tsql
>
> Is there an equivalent to the VFP recno() function in T-SQL?
>
> I'd like to create the following select statement in T-SQL:
>
> select recno(),otherfields. from database.dbo.table
>
> If there is not, what would be a substitute?
>
> Rafael Copquin
>
>
>
[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/01a701d34f07$bc840390$358c0ab0$@wondzinski.de
** 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: recno() function in tsql

[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 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.

Flexipol Packaging Ltd.
Unit 14 Bentwood Road
Carrs
Industrial Estate
Haslingden
Rossendale
Lancashire
BB4 5HH

Tel:01706-222792
Fax: 01706-224683
www.Flexipol.co.uk
---

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

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jürgen Wondzinski
Sent: 27 October 2017 10:41
To: 'ProFox Email List' 
Subject: WG: recno() function in tsql

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 
De: Jürgen Wondzinski 
Fecha: 26/10/2017 12:18 (GMT-03:00)
A: 'Rafael Copquin' 
Asunto: AW: AW: recno() function in tsql

Hi Rafael,

ah, you want a freshly generated SEQUENCE number of your foundset.
See this:

https://stackoverflow.com/questions/1310/how-can-i-create-a-temporary-sequence-column-in-my-sql-query-result

wOOdy


-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 tables with autoincrementing primary keys. In this 
particular case the table I am dealing with has 1 records. The primary keys 
go from 1 to 1.

But i want to select a small set based on a date range (it is a sales table)

I just want the first column of the selected cursor to contain the record 
number and the other columns the rest of the data.

So I should be getting something like this:

RecordNoIDDate   etc

15421   2017-06-15

25422   2017-06-15

35423   2017-06-16

etc

Rafael



El 26/10/2017 a las 12:00, Jürgen Wondzinski escribió:
> In SQL each record has to have a PrimaryKey (Field) for identifying it, since 
> SQL doesn't know of records, it knows about result-sets instead.
>
> The RECNO() in xBase is just the same concept: a unique identifier for
> the current session, not meant for a longterm relation setting.  If
> you designed your SQL table without a unique identifier, then you're
> out of luck :)
>
>
> wOOdy
>
> -Ursprüngliche Nachricht-
> Von: ProFox [mailto:profox-boun...@leafe.com] Im Auftrag von Rafael
> Copquin
> Gesendet: Donnerstag, 26. Oktober 2017 16:34
> An: profox
> Betreff: recno() function in tsql
>
> Is there an equivalent to the VFP recno() function in T-SQL?
>
> I'd like to create the following select statement in T-SQL:
>
> select recno(),otherfields. from database.dbo.table
>
> If there is not, what would be a substitute?
>
> Rafael Copquin
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listin

AW: recno() function in tsql

[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 
Betreff: Re: recno() function in tsql

I only see Jurgen's statement, noting from you in my current email.  Then
this popped in as I was writing.  "Yes. After I read Woody's example I
checked the SQL help an now see how to use it.tksRafael "

On Thu, Oct 26, 2017 at 3:10 PM, rafael.copquin 
wrote:

>
>
> Look at the example in my earlier reply to WoodyRafael
>
>
> Enviado desde mi dispositivo Samsung
>
> 


___
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/01b001d34f08$000e0d90$002a28b0$@wondzinski.de
** 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: recno() function in tsql

[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 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.

Flexipol Packaging Ltd.
Unit 14 Bentwood Road
Carrs
Industrial Estate
Haslingden
Rossendale
Lancashire
BB4 5HH

Tel:01706-222792
Fax: 01706-224683
www.Flexipol.co.uk
---

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

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jürgen Wondzinski
Sent: 27 October 2017 10:43
To: 'ProFox Email List' 
Subject: AW: recno() function in tsql

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 
Betreff: Re: recno() function in tsql

I only see Jurgen's statement, noting from you in my current email.  Then this 
popped in as I was writing.  "Yes. After I read Woody's example I checked the 
SQL help an now see how to use it.tksRafael "

On Thu, Oct 26, 2017 at 3:10 PM, rafael.copquin 
wrote:

>
>
> Look at the example in my earlier reply to WoodyRafael
>
>
> Enviado desde mi dispositivo Samsung
>
>


___
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/01b001d34f08$000e0d90$002a28b0$@wondzinski.de
** 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.
___
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/18725b8cd2d5d247873a2baf401d4ab2b48c8...@ex2010-a-fpl.fpl.LOCAL
** 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.

AW: recno() function in tsql

[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 earlier

Dave



___
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/01c201d34f09$f4c33490$de499db0$@wondzinski.de
** 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: recno() function in tsql

[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 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.

Flexipol Packaging Ltd.
Unit 14 Bentwood Road
Carrs
Industrial Estate
Haslingden
Rossendale
Lancashire
BB4 5HH

Tel:01706-222792
Fax: 01706-224683
www.Flexipol.co.uk
---

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

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jürgen Wondzinski
Sent: 27 October 2017 10:57
To: 'ProFox Email List' 
Subject: AW: recno() function in tsql

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 earlier

Dave



___
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/01c201d34f09$f4c33490$de499db0$@wondzinski.de
** 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.
___
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/18725b8cd2d5d247873a2baf401d4ab2b48c8...@ex2010-a-fpl.fpl.LOCAL
** 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 10 phone to join VFP in the graveyard

[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 one's gone, and another one's gone...,

___
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/CACW6n4sG2H7Dr==zbax1pjmdr3ekh_l09mumujmdu+dynan...@mail.gmail.com
** 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: FoxPro DevCon in Frankfurt

[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 propose to speak
on one of these topics. Years ago, it worked for me.

-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

___
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/CACW6n4tCecpaJxOw7_SyrXnwpKvrYpWNSeN85_2shQRJKh1L=g...@mail.gmail.com
** 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.

AW: recno() function in tsql

[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 course

Dave


___
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/01d801d34f13$0284b1e0$078e15a0$@wondzinski.de
** 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: recno() function in tsql

[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 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.
>
> Flexipol Packaging Ltd.
> Unit 14 Bentwood Road
> Carrs
> Industrial Estate
> Haslingden
> Rossendale
> Lancashire
> BB4 5HH
>
> Tel:01706-222792
> Fax: 01706-224683
> www.Flexipol.co.uk
> ---
>
> 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
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jürgen
> Wondzinski
> Sent: 27 October 2017 10:57
> To: 'ProFox Email List' 
> Subject: AW: recno() function in tsql
>
> 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 earlier
>
> Dave
>
>
>
[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/CAPqLOBxH68QnG1auWzQg9-svN0LNiNoXpCe=oo+qqicvp33...@mail.gmail.com
** 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: FoxPro DevCon in Frankfurt

[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 of thinking out of the 
> box.
> 
> 


___
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/7f858a75-15a1-47a2-a7e6-fa5bae93c...@jbweller.force9.co.uk
** 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: FoxPro DevCon in Frankfurt

[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
 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 propose to speak
on one of these topics. Years ago, it worked for me.




___
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/c00a69e4-ff26-70a9-08fc-b15457399...@foxincloud.com
** 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] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

[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: 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/cf55a5fdce51f4e13057ae9a9f364...@mbsoftwaresolutions.com
** 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] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

[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 10:10 AM
To: profoxt...@leafe.com
Subject: RE: [NF] Customer asking for (preferably free) unattended remote 
access software so she can access her work machine from home

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: 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/mwhpr10mb17747ac5e044111d7e0bad0ed2...@mwhpr10mb1774.namprd10.prod.outlook.com
** 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: recno() function in tsql

[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 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 course

Dave

___
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/mwhpr10mb17744c35643710c14d22a01bd2...@mwhpr10mb1774.namprd10.prod.outlook.com
** 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] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

[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 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.

Flexipol Packaging Ltd.
Unit 14 Bentwood Road
Carrs
Industrial Estate
Haslingden
Rossendale
Lancashire
BB4 5HH

Tel:01706-222792
Fax: 01706-224683
www.Flexipol.co.uk
---

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

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: 27 October 2017 15:30
To: profox@leafe.com
Subject: RE: [NF] Customer asking for (preferably free) unattended remote 
access software so she can access her work machine from home

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 10:10 AM
To: profoxt...@leafe.com
Subject: RE: [NF] Customer asking for (preferably free) unattended remote 
access software so she can access her work machine from home

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: 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/mwhpr10mb17747ac5e044111d7e0bad0ed2...@mwhpr10mb1774.namprd10.prod.outlook.com
** 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.
___
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/18725b8cd2d5d247873a2baf401d4ab2b48c9...@ex2010-a-fpl.fpl.LOCAL
** 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] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

[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 tool they've done 
a decent job.

--

rk

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Friday, October 27, 2017 10:31 AM
To: profoxt...@leafe.com
Subject: RE: [NF] Customer asking for (preferably free) unattended remote 
access software so she can access her work machine from home

Richard,
The file transfer facility has been radically improved in the latest release. 
It is now quick and stable.

Dave


___
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/mwhpr10mb17748836ded39fd2a6832337d2...@mwhpr10mb1774.namprd10.prod.outlook.com
** 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, Authorize.net

[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 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/f03d13e3-7139-e28a-378e-9e36abe28...@taconic.net
** 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] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

[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 (which is 
GREAT!), but for this client, the MBSS support team uses Splashtop.


___
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/12def1a6df04545174d483ac1f2c9...@mbsoftwaresolutions.com
** 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] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

[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 are way faster. But as a
remote access tool they've done a decent job.




I loved LogMeIn (LMI) but it's costs became too expensive for what I 
wanted to pay.  With TeamViewer, it was a one-shot payment and I'm good 
to go from here out.


___
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/5d74af80e90d9896631af0ddc882d...@mbsoftwaresolutions.com
** 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] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

[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 things away, LMI decided that wasn't 
a sustainable business model and they had the nerve to ask people to start 
paying for their product. This is why I've never like the everything should be 
free mindset. If you have the gall to ask for money after that, you get 
vilified. But until we've got the Star Trek economy, I say you get what you pay 
for.  😊


Teamviewer... Another user experience I find dreadful. But that's just me. 
Multipart forms and toolbars hanging off every edge of the display covering up 
things you want to see... Just get out of my way after I connect and let me get 
my work done! And you think that at some point Teamviewer won't change their 
pricing model? Or force you into an upgrade you don't need because their 
expenses exceed their revenue stream?


Happy Friday!

--

rk

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Friday, October 27, 2017 12:52 PM
To: profoxt...@leafe.com
Subject: RE: [NF] Customer asking for (preferably free) unattended remote 
access software so she can access her work machine from home

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 are way faster. But as a
> remote access tool they've done a decent job.
> 


I loved LogMeIn (LMI) but it's costs became too expensive for what I 
wanted to pay.  With TeamViewer, it was a one-shot payment and I'm good 
to go from here out.

___
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/mwhpr10mb1774ac73b6abf8a008de58a6d2...@mwhpr10mb1774.namprd10.prod.outlook.com
** 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] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

[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 [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Friday, October 27, 2017 12:51 PM
To: profoxt...@leafe.com
Subject: RE: [NF] Customer asking for (preferably free) unattended remote 
access software so she can access her work machine from home

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 (which is 
GREAT!), but for this client, the MBSS support team uses Splashtop.


___
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/mwhpr10mb17742b474f6c2776fa4eab17d2...@mwhpr10mb1774.namprd10.prod.outlook.com
** 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: WG: recno() function in tsql

[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: 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/edba24dc-2ff9-ea76-a1d7-6d91de2a3...@hawthorncottage.com
** 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: WG: recno() function in tsql

[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, * FROM tmp


[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/0c6a0ad0-bb59-ba44-90fb-b13257be8...@yahoo.com.ar
** 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.

[NF] LogMeIn -- Richard

[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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/91e99c95f55b01af5fe861d047793...@mbsoftwaresolutions.com
** 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] LogMeIn -- Richard

[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 ad-hoc 
support on user systems or potential client demos, I've been using GoToMeeting 
for the last few years.

--

rk

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Friday, October 27, 2017 4:51 PM
To: profoxt...@leafe.com
Subject: [NF] LogMeIn -- Richard

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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/mwhpr10mb1774568f6a5f4bb76871afa8d2...@mwhpr10mb1774.namprd10.prod.outlook.com
** 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] LogMeIn -- Richard

[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 -- Richard

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 ad-hoc 
support on user systems or potential client demos, I've been using GoToMeeting 
for the last few years.

--

rk

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Friday, October 27, 2017 4:51 PM
To: profoxt...@leafe.com
Subject: [NF] LogMeIn -- Richard

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
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/mwhpr10mb177467ae2c34ce4a285dfe72d2...@mwhpr10mb1774.namprd10.prod.outlook.com
** 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] LogMeIn -- Richard

[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 but my preference
is still LMI. For ad-hoc support on user systems or potential client
demos, I've been using GoToMeeting for the last few years.



How do you support so many clients with just 2 LMI Pro subscriptions?  1 
license is your main machine, and do you just keep re-assigning the 2nd 
license for the other (target) machine?


___
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/aa9672b4e3db4117822b4037584a6...@mbsoftwaresolutions.com
** 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.

[NF] INT vs MEDIUMINT vs SMALLINT vs TINYINT

[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 (index problems, etc.).  His network guy (as usual) says 
everything on the Windows Server 2016 network is fine and the problems 
only started when they upgraded the client workstations from Win7 to 
Win10.  Whatever.  This thread is about primary key size WHEN YOU KNOW 
THAT THE MAX VALUE WON'T GO OVER (whatever the limit is at each field 
type:  255 for tinyint, etc.)


The OCD part of me wants to define the smallest type possible, whereas 
the "let's set it and never worry about it" part of me says "just make 
everything INT."



Weigh in on your thoughts on which type you'd use.

tia,
--Mike


___
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/643f17b4907e9145bdadd24798792...@mbsoftwaresolutions.com
** 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] INT vs MEDIUMINT vs SMALLINT vs TINYINT

[Wollenhaupt, Christof]

That is largely dependent on the engine you use in MariaDB. Have you
settled on one?

-- 
Christof


--- 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/cal4qjhipvx8se1_z8mtyubo7oawpgqqp+9q9kzuvxmovl5i...@mail.gmail.com
** 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: FoxPro DevCon in Frankfurt

[AndyHC]

I have been vaguely aware of VFP10 / VFP Compiler since a while back but 
I have not really been following the issue.

What is the general opinion of the technical (i.e. non- licensing) aspects?

___
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/65987aa2-9b07-b6fa-26a2-fa539ac0f...@hawthorncottage.com
** 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.