Search results for query: *

Hey all. I am working on a project for a friend of mine and I have hit a road block. I want to take a text file separated by commas or tabs, and import it into a table. Should be simple but the last field could be up to 500 characters long. It would be great if I could import it into two...

I get a Run-Time error '430' "Class does not support Automation or does not support expected interface"

Hi all, I don't know anything really about VB, but I am trying to use some programs written by someone else and they are not working correctly. Specifically, it seems like the exe files will only work on the OS that it was created on. I have a Win2k computer that will run an exe, but once...

Is there a way to use a query statement like this..? SELECT LEFT(ZIPCODE,5), COUNT(*) FROM MYTABLE GROUP BY LEFT(ZIPCODE,5) I've also tried this.. lcMyzip=left(zipcode,5) SELECT &lcMyzip, count(*) from mytable group by &lcMyzip I'm running VFP 6 and it says that the SQL column ' ' does not...

I need to make one record, out of multiple records based on a key code. Here's a sample: mytable CODE NAME1 ADDRESS1 CITYSTZIP1 001 Mike 1234 Main Anytown,US 99999 001 John 1234 Street AnyWhere,CA 12343 001 Dan 1234 First Mytown,UT, 22222 003 Steve 999 Main...

I used my home pc for about 90% of the development. I used the apps daily on incoming client data. There was no formal agreement.

Hey everyone, I am planning on quitting my current job, but during my employment, I have developed a few apps that were used to streamline common data tasks using Visual Foxpro. I was in no way hired as a programmer. My job title is Department Manager. I knew nothing four years ago and have...

I had a table in my project that I no longer needed so I deleted it. I then took out all code referring to it in my form and rebuilt the app. However, "Error instantiating object, mytable.dbf" still comes up. Any ideas? Thanks a bunch

This is probably a dumb question, but I have a field that contains keycodes of A,B,C,D, etc. Anything over Z gets AB,AC,AD. My question is how to use set order to correctly so that the order is A,B,C,D, and not A,AB,AC,AD,B,C,D like I am getting now. I have exact set ON. Thanks a lot in...

Hi all. I was wondering if there is an easy way to write a table to a text file the looks like a label. ex: MYTABLE.DBF name ADDRESS CITY,STATEZIP Mr. Jones 1111 Main New York, NY 11111 I need to put all records in mytable.dbf into text file like so: Mr. Jones 1111 Main New...