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

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

Re: alter column in sql server

2018-09-06 Thread Rafael Copquin
fe.com/download/stru2postgreSQL.PRG > http://leafe.com/download/stru2mysql_2.prg > > -Kevin > > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche > Sent: Thursday, September 06, 2018 10:34 AM > To: profox@leafe.com > Subject: Re:

RE: alter column in sql server

2018-09-06 Thread Kevin J Cully
: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: Thursday, September 06, 2018 10:34 AM To: profox@leafe.com Subject: Re: alter column in sql server Why not write the script in VFP and then cut-and-paste it into the SQL Server? Use AFIELDS to get the fieldlist, TEXTMERGE to write

Re: alter column in sql server

2018-09-06 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

Re: alter column in sql server

2018-09-06 Thread Stephen Russell
I made a simple table,st_ex, with ST columns and then here is the change script to strip the ST off: /* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/ BEGIN TRANSACTION SET QUOTED_IDENTIFIER

Re: alter column in sql server

2018-09-06 Thread Ted Roche
Why not write the script in VFP and then cut-and-paste it into the SQL Server? Use AFIELDS to get the fieldlist, TEXTMERGE to write the script. Easy, peasy. On Thu, Sep 6, 2018 at 10:28 AM Rafael Copquin wrote: > I need to import a DBF table into SQL Server > However, all the fields in the DBF