Recent content by wawalter

That worked. Thanks! APPEND FROM file.txt DELIMITED WITH "" WITH CHARACTER "|"

Thanks for the reply Dave. There can also be commas in some of the fields (I should have mentioned that) which I think would cause problems with this solution. That's why tabs or pipes worked well, until now, because they never show up in the data.

Hi, I'm having some trouble append a text file into a dbf using VFP 7. I have tried outputting the file with tab or | and using append from file.txt delim with tab and delim with character | and I get the same problem for both. If a field begins with a " it strips the quotes and moves the...

I have a VFP 7 dll I have been using in a C# app and it has worked fine. I just got a new computer which is Win7 64 bit and now when the C# program calls the DLL it immediately crashes. I compile the C# program in x86 mode which allows VFPOLEDB to work and I can compile the DLL in VFP by...

Hi, I am just trying to figure out some basics with WCF and I've hit a snag. I went through a tutorial and created a client-server on my local machine. Now, I want to move the service exe (called service.exe) to a different computer and connect to that. I started the exe on the remote...

I tried using the using, but apparently the Excel object doesn't implement IDispose so I don't think I can use that method. I thought I'd try only creating one excel object and doing save as then clearing the excel sheet instead of creating a new excel object everytime through the loop. Maybe...

Hello, I need to create about 1,000 excel files. It works fine through about 300 or so then I get the following error: Not enough memory to run Microsoft Office Excel I then have to reboot my computer and run another 300 or so then repeat. Just closing the application doesn't fix the error...

Hello, I am trying to read in a large text file (2-6 gig), parse what I need and write it out to a smaller text file which is about 20% of the size of the original. The problem is in this read/write and amount of memory the program uses just keeps growing and growing until with a 4 gig or...

Thanks, it does exist in VFP 7, so I'll give it a try. I also found that adding err.raise after I write to the error log will raise the error to the C# program in a generic form, but at least the error is logged and my C# program knows there is an error. Thanks again, Bill

Hello, I have created a DLL in VFP7 that I call from a C# application. Normally it works fine. The problem I'm having is when there is an error in the DLL, the message returned to C# is meaningless. Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT)) I set up an "on error"...

Thanks for the suggestions. I'd like to avoid SQL server if possible. This is what I normally do, but this job needs to turn around fast and I've found the download from SQL Server can be pretty slow. As far as using the editor, I'd rather not have the manual step of splitting the file before...

Hello, I am trying to load large text files in to a dbf. I was using the native fox file functions and it worked file until I hit the 2 gig limit. So, after reading this, I switched to use FileSystemObject (FSO), but I'm having a problem. I use substr to split each line and keep only the...

Hello, I just stumbled on this and I was having the same problem. I was using the native fox file functions and it worked file until I hit the 2 gig limit. So, after reading this, I switched to use FSO, but I'm having a problem. I use substr to split each line and keep only the parts I want...

blounty, What happens if I am iterating through objects and try to access the shipNumber or colour properties that aren't part of the spaceobject class that the collection was built on? Are they still accessible or would I have to cast the object to its actual class? Thanks, Bill

That is pretty much what I ended up doing. I made a copy of my original List<> and changed the data source to point to that. I was afraid I'd lose the data bindings ability to make changes to the original list but it my copy must be a reference to the original because any changes I make on the...