RE: VFP and VSS Database does not exist

I've used VSS on W10 with no problem while using VFP's project integration. My best guess is this is a VSS pathing/auth issue. Since you say it works at your client location but not yours, I'd compare the INIs and look for clues there. Also, can you connect to your local repo using the VSS clie

Opinions on Servers

Hi All Just a general question ... If you was choosing a server which would run a vfp application using standard dbfs as fast as possible for around 30 users (connected via remote desktop). What server would you choose to get the best performance? Is it CPU's , Hard Drive Configuration, Memor

Re: Problem with APPEND FROM TYPE DELIMITED

Hi Paul, I created a 60 col table (all character type) and append that line. The 58th col correctly has the word 'LEITH' So for me, it is behaving as expected. I have uploaded both the files to https://we.tl/t-txhbr0rAAM Ajit On 23/11/2020 16:14, Paul Newton wrote: Hi all I have a CSV file (

RE: Problem with APPEND FROM TYPE DELIMITED

Hi Paul, cmd = "CREATE CURSOR mytable (" FOR ii = 1 TO 66 cmd = cmd + "F" + TRANSFORM(ii) + " c(10)" IF ii < 66 cmd = cmd + "," ENDIF NEXT cmd = cmd + ")" &cmd. Select MyTable APPEND FROM MyFile.CSV TYPE DELIMITED BROWSE LAS

Re: Problem with APPEND FROM TYPE DELIMITED

What's the structure of your DBF, notably the definition of the 58th field? On Mon, Nov 23, 2020 at 9:14 PM Paul Newton wrote: > > I have a CSV file (MyFile.CSV) with a single line that looks like this: > FIN005,,06/11/2020,06/11/2020,06/11/2020,T116434,C,,,N,,,8300,,-15,,-3,,,H,S,1,,

RE: VFP and VSS Database does not exist

On that note, I know some code exists to get all the history from VSS into a git repo. Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Monday, November 23, 2020 8:28 AM To: profoxt...@leafe.com Subject: RE: VFP and VSS Databa

RE: VFP and VSS Database does not exist

Hi Martin, wow. Somebody stil uses the real VSS? Dude... Why not at least use VAULT from SourceGear.com? It's free for SingleUsers, and replaces VSS perfectly. It also integrates the very same in VFP. They even had some conversion / import tools for VSS, if I remember correctly. wOOdy

Re: Problem with APPEND FROM TYPE DELIMITED

Sure Paul. On 23/11/2020 17:27, Paul Newton wrote: Thanks Ajit Can I send you my table and CSV? Paul -Original Message- From: ProfoxTech On Behalf Of Ajit Abraham Sent: 23 November 2020 14:14 To: profoxt...@leafe.com Subject: Re: Problem with APPEND FROM TYPE DELIMITED Sent by an e

RE: Opinions on Servers

Hi Chris, We get away with 1 CPU core per server in a VM to get good performance accessing DBFs on a different VM. More CPU cores may help by allowing the server to spread out on additional cores. We don't see a lot of CPU usage per VM. The bottle neck appears to be IO access to the DBFs. With tha

RE: Opinions on Servers

Thanks Tracy So, you would typically have the clients RDP'ing into one server to run the .exe in turn accessing the dbf's on another VM acting as a file server? How are the physical drives configured, is there any redundancy if anything fails or you using some VM magic? Thanks Chris. -Or

RE: Opinions on Servers

Hi Chris, We own the hardware and it is at a co-host location that has redundant internet trunks. There's a SAN, and several hosts (Blade servers). All the VMs reside on the SAN, and they are instantiated on one of the hosts. There's a separate "performance storage" with SSDs in the SAN, and that

Problem with APPEND FROM TYPE DELIMITED

Hi all I have a CSV file (MyFile.CSV) with a single line that looks like this: FIN005,,06/11/2020,06/11/2020,06/11/2020,T116434,C,,,N,,,8300,,-15,,-3,,,H,S,1LEITH You can verify for yourselves that LEITH is the 58th column. I have a table (MyTable.DBF) with 66

RE: Problem with APPEND FROM TYPE DELIMITED

Thanks Tracy I know that SA_JOB is the 58th field in the table FIELD(58) returns SA_JOB Paul -Original Message- From: ProfoxTech On Behalf Of Tracy Pearson Sent: 23 November 2020 14:19 To: profoxt...@leafe.com Subject: RE: Problem with APPEND FROM TYPE DELIMITED Sent by an external se

RE: [SUSPECTED SPAM] Re: Problem with APPEND FROM TYPE DELIMITED

Thanks Man-wai Field 58 is SA_JOB C(8) Paul -Original Message- From: ProfoxTech On Behalf Of Man-wai Chang Sent: 23 November 2020 14:19 To: profoxt...@leafe.com Subject: [SUSPECTED SPAM] Re: Problem with APPEND FROM TYPE DELIMITED Sent by an external sender

RE: Problem with APPEND FROM TYPE DELIMITED

Thanks Ajit Can I send you my table and CSV? Paul -Original Message- From: ProfoxTech On Behalf Of Ajit Abraham Sent: 23 November 2020 14:14 To: profoxt...@leafe.com Subject: Re: Problem with APPEND FROM TYPE DELIMITED Sent by an external sender -- Hi Paul

RE: Problem with APPEND FROM TYPE DELIMITED - SOLVED

Hi all The problem was that one of the preceding fields was a memo field, so CSV column 58 was ending up in table field 59 (which happened to be a logical field so could not accept "LEITH". Many thanks everybody Paul Newton -Original Message- From: ProfoxTech On Behalf Of Ajit Abraha

Re: Problem with APPEND FROM TYPE DELIMITED

Are you taking into account that there's a memo field in there, into which with CSV you can't import ? -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailma

Re: Problem with APPEND FROM TYPE DELIMITED

Having said that it works for me with or without the memo field in the DBF. Although field(58) only returns sa_job if you remove the memo field from the DBF. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.co