ProFox October 2017

profox@leafe.com

53 participants
61 discussions

RE: recno() function in tsql
by Jürgen Wondzinski 29 Oct '17

29 Oct '17

Rafael, as soon as you got your SQL-Query from the Server it will be in a cursor at your VFP client. Therefor that cursor indeed has a recno(), and that's what Andy is talking about. Thus Andy's solution is totally useful, as long as you need that result only at the VFP side. wOOdy -----Ursprüngliche Nachricht----- Von: ProFox [mailto:profox-bounces@leafe.com] Im Auftrag von Rafael Copquin Gesendet: Freitag, 27. Oktober 2017 20:49 An: profox(a)leafe.com Betreff: Re: WG: recno() function in tsql 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 >

1 0

WG: recno() function in tsql
by Jürgen Wondzinski 27 Oct '17

27 Oct '17

-----Ursprüngliche Nachricht----- Von: Rafael Copquin [mailto:rafael.copquin@gmail.com] Gesendet: Donnerstag, 26. Oktober 2017 17:09 An: Jürgen Wondzinski <juergen(a)wondzinski.de> 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 10000 records. The primary keys go from 1 to 10000. 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: RecordNo ID Date etc 1 5421 2017-06-15 2 5422 2017-06-15 3 5423 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-bounces@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]

3 2

[NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home
by mbsoftwaresolutions＠mbsoftwaresolutions.com 27 Oct '17

27 Oct '17

Customer is a small business and NOT tech savvy at all (so don't suggest "UltraVNC configured oh so cool!"). I warned her you get what you pay for many times, but said I'd research it. I use TeamViewer and it's great for me but overkill for her. TV has a free license but the wording appears to be such that it's for accessing your personal home computer from work (not the other direction). LogMeIn (as we've noted here) kept jacking up prices, and they have no more free version. I've got a question into gotomypc.com to see if unattended access is an option for their product (although it's not free either). I have no problem telling a client that free isn't possible but I did say I'd check first. GotoMyPC's pricing isn't bad for the single user if she can use it in unattended access mode: https://get.gotomypc.com/plansandpricing Other suggestions based on your experience? Found this too, reviewing alternatives to LMI: https://www.pcworld.com/article/2091801/5-alternatives-to-logmein-free-for-… tia! --Mike

10 27

VFP, Authorize.net
by Vince Teachout 27 Oct '17

27 Oct '17

A friend of mine sent the following question, and I don't know the answer. Does anyone know off the top of their head? "I have a VFP question if you do not mind. I have a client with an old custom app in VFP 7 and 9. They process credit cards using Authorize.net. Authorize.net is pushing everyone to a new API and I am tasked with migrating the client’s apps so they can use this new API (https://developer.authorize.net/api/reference/index.html) Currently they use HTTP Posts to send in the CC info. Anyway, my question is this. Authorize offers a development kit and example code using C#. Therefore it should be .Net compliant and wouldn’t that mean I could use the same in a VFP application?"

6 7

[NF] Windows 10 phone to join VFP in the graveyard
by mbsoftwaresolutions＠mbsoftwaresolutions.com 27 Oct '17

27 Oct '17

http://www.businessinsider.com/microsoft-windows-10-mobile-what-comes-next-… "Of course we'll continue to support the platform.. bug fixes, security updates, etc. But building new features/hw aren't the focus. 😟" https://twitter.com/joebelfiore/status/917071399541391360

5 5

Re: recno() function in tsql
by rafael.copquin 27 Oct '17

27 Oct '17

Look at the example in my earlier reply to WoodyRafael Enviado desde mi dispositivo Samsung -------- Mensaje original -------- De: Stephen Russell <srussell705(a)gmail.com> Fecha: 26/10/2017 12:37 (GMT-03:00) A: ProFox Email List <profox(a)leafe.com> Asunto: Re: recno() function in tsql I haven't thought of the term recno() in decades. It is a temporary pointer to a specific row but why would you not use your PKey as an identifier? On Thu, Oct 26, 2017 at 10:00 AM, Jürgen Wondzinski <juergen(a)wondzinski.de> wrote: > 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-bounces@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(a)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/CAJidMYLqnGsXhUUdkspCR5S9YonCwGtYDRF… ** 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.

4 3

AW: recno() function in tsql
by Jürgen Wondzinski 27 Oct '17

27 Oct '17

-----Ursprüngliche Nachricht----- Von: Jürgen Wondzinski [mailto:juergen@wondzinski.de] Gesendet: Donnerstag, 26. Oktober 2017 17:19 An: 'Rafael Copquin' <rafael.copquin(a)gmail.com> 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/13100000/how-can-i-create-a-temporary-s… wOOdy -----Ursprüngliche Nachricht----- Von: Rafael Copquin [mailto:rafael.copquin@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 10000 records. The primary keys go from 1 to 10000. 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: RecordNo ID Date etc 1 5421 2017-06-15 2 5422 2017-06-15 3 5423 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-bounces@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]

1 0

RE: recno() function in tsql
by rafael.copquin 26 Oct '17

26 Oct '17

Yes. After I read Woody's example I checked the SQL help an now see how to use it.tksRafael Enviado desde mi dispositivo Samsung -------- Mensaje original -------- De: Dave Crozier <DaveC(a)Flexipol.co.uk> Fecha: 26/10/2017 12:12 (GMT-03:00) A: ProFox Email List <profox(a)leafe.com> Asunto: RE: recno() function in tsql Rafael, Jurgen is correct but there is a "pseudo" way to do it if you simply want a unique row number to be generated if that helps. Use Row(Number) with the OVER(...) segmentation construct Select Row_NUMBER() over (Partition by <...unique field..> order by <field>) as Row#, <Field1> as <Alias1>, From <Database>.dbo.<Table> Where ... etc. This will generate you a unique row number by TSQL. What good it will do you depends on how you can relate it back to your VFP tables of course. I use this to generate a unique row number in temporary tables that I can use in Functions that are called within Stored Procedures where a unique record identifier is required but only whilst processing the data. 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-bounces@leafe.com] On Behalf Of Rafael Copquin Sent: 26 October 2017 15:34 To: profox <profox(a)leafe.com> Subject: 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 --- Este correo electrónico ha sido comprobado en busca de virus por AVG. http://www.avg.com _______________________________________________ Post Messages to: ProFox(a)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/e97e84c8-0757-2ade-1110-3bbef9854897… ** 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(a)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/18725B8CD2D5D247873A2BAF401D4AB2B48C… ** 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.

1 0

[NF] Tech buzzwords
by mbsoftwaresolutions＠mbsoftwaresolutions.com 26 Oct '17

26 Oct '17

Charlie's recent post made me think of some buzzwords in Tech over the years that just made a person either laugh, cringe, roll-their-eyes, or some combination thereof. I thought it'd be fun to list some tech buzzwords over the years in this thread. The CIO at my gig from 1999-2002 loved to use the word "synergy." Charlie's post about horrible results also made me think of this: https://cdn.shopify.com/s/files/1/0535/6917/products/planningdemotivator.jp… Love those despair.com demotivational posters!! I recall them at GLGDW back in 2002/2003. Another buzzword was "paradigm" which always make me think of the Reebok Terrible Terry Tate ads from years ago. Still hilarious today. https://www.youtube.com/watch?v=_DOm_RiklE4

3 2

recno() function in tsql
by Rafael Copquin 26 Oct '17

26 Oct '17

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 --- Este correo electrónico ha sido comprobado en busca de virus por AVG. http://www.avg.com

4 3

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox October 2017