RE: alter column in sql server

2018-09-12 Thread Richard Kaye
For all you Thor users out there, check out the Super Browse tool. 

--

rk

-Original Message-
From: ProfoxTech  On Behalf Of Vince Teachout
Sent: Thursday, September 6, 2018 11:02 AM
To: profoxt...@leafe.com
Subject: Re: alter column in sql server

I wrote a little function that reads in a vfp table, and outputs a SQL Create 
table script.  Would be super simple to either alter it to output
Substr(coriginalname,3) or to edit/replace the field names in the text output 
file.  Do you want it?

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/bn6pr10mb12998e9b7dd26a9491f3be21d2...@bn6pr10mb1299.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: Good old fashioned FTP need from VFP app

2018-09-12 Thread Vince Teachout

On 09/08/18 5:09 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
Got a client need for me to FTP some data of theirs to a 3rd party 
vendor.  Nothing fancy, just regular FTP (not SFTP, not FTP-S). Many 
moons ago I interacted with Robert Abrams VFP class (wow...I think 
that was VFP5 days?!?!?).


What do folks use nowadays for FTP from a VFP app?


Not free, but pretty cheap - I use West Wind's WWIPStuff for both FTP 
and SFTP within VFP.


I've also used TaskManager to fire of WinScp (free) scripts.  I haven't 
done it, but I have no doubt you could accomplish this with the VFP RUN 
command.




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/9c4e5ca0-d44b-4d9d-8c3f-6c00bacd5...@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: alter column in sql server

2018-09-12 Thread Vince Teachout
I wrote a little function that reads in a vfp table, and outputs a SQL 
Create table script.  Would be super simple to either alter it to output 
Substr(coriginalname,3) or to edit/replace the field names in the text 
output file.  Do you want it?


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
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/550d1270-2b3a-ab2f-4745-11e45ef93...@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.