Re: Log4VFP or Log4Fox

2023-10-05 Thread Eric Selje
I think that's what most people do, and what my session at SW Fox in a few weeks will address. E On Thu, Oct 5, 2023 at 8:47 AM Alan Bourke wrote: > I just have my own class that I create a global instance of, and that logs > to file under a specified folder structure based on date, like: > >

Re: Log4VFP or Log4Fox

2023-10-05 Thread Alan Bourke
I just have my own class that I create a global instance of, and that logs to file under a specified folder structure based on date, like: app\logs\2023\10\05\app.log Then an append method like: myApp.goLogger.Append("some text") Which updates the log file like: 2023-10-05T14:44:58:some text

FW: SQL Upsize

2023-10-05 Thread Graham Brown
Hi all I am upsizing a Foxpro DBC to SQL 2008 r2. This worked fine with earlier versions of SQL but gives errors to newer versions of SQL. I am using ODBC rather than Native client although it doesn't make any difference to the errors. For one specific table the upsize says 988 rows

RE: FW: SQL Upsize

2023-10-05 Thread Richard Kaye
Are you using the Upsizing Wizard? If so, have you gotten the latest and greatest from Github/VFPX? It’s been updated a few times over the years and one of the changes IIRC was to better handle newer versions of SQL. Well, newer than what was around at the time.  Highly recommended. Using SQL

RE: FW: SQL Upsize

2023-10-05 Thread Graham Brown
Hi Thanks Yes, the database and tables all get created via the upsizing wizard so definitely something to do with the data itself The upsizing wizard has worked in the past probably 2000 to 2005 but won't work in 2008r2. Havent done one of these in a long time. In the upsizing wizard I uncheck

Re: FW: SQL Upsize

2023-10-05 Thread Kurt Wendt
Hey there Graham, Now, I know this is going to be more of a WAG or a total Shot-in-the-Dark, Butt... Also, I will admit - I am not familiar with the exact process you're attempting to do. I did try something similar MANY Years ago, admittedly - back in like 2012. Anyway... So, my question is

Re: FW: SQL Upsize

2023-10-05 Thread Virgil Bierschwale
I use navicat. copy the dbf to csv or txt. use navicat to connect to sql server. and then do a import. I've added about 10GB data to mysql that way and it works pretty good. they have a version for sql server as well. On Thu, Oct 5, 2023 at 11:36 AM Graham Brown wrote: > Hi > Thanks > > Yes,