Recent content by virgo

Zim, What are sub cursors? Why did you make that statement about iif() and sql? Is there a special iif function? Also, after I get all this information out, then I need to append it to specific places in another database. Also, the 33 hours got involved with Access because people 'said that...

I actually put in several questions on this. You and Pete answered one of the other threads. I got some ideas from that and IT IS DONE. Thank you.

This is a duplexed membership card. On the same side of legal sized card stock is the address and the actual membership card. So, sort of like this address name picture add1 name add2...

Yes, There was an original 'label' written that would deal with all of the problems in the report. This does not work now. So, what I am doing is just setting up the membership cards. They read fine when there is an address1, address2, and an address3. I have not as yet 'ditched' that...

I also need to be able to delete just an address line if it is not present. When I try to do this, it deletes the entire address. I can't just delete a line.

I have to use the same report with a series of 4 datafiles. It worked fine with the first datafile. It can't 'find' the data from the second, third, and fourth datafiles. These are FoxPro dbf files. I have looked at them in FoxPro. They are fine. This report was set up in Crystal 5. (I...

A little bit more on what the problem is. I separate the 4 files as to whether they are members or subscribers. I also separate both members and subscribers as to whether they are new (no accounting records for this last year) or whether they are renewed (everyone else). I then run a separate...

I have a large Foxpro Windows 2.6 database. I have to pull information from 4 files in the database. I then have to accurately place this in a fifth file so that I can run a report from this. The report was done in Access 97. It works so long as the fifth file is correct. I could get the...

I need to be able to pull information out of a large database (FPW 2.6, 4 different files) and place it very accurately in a fifth file. This fifth file is then used to run Crystal Reports. I can get data out of the large database. I cannot get it to go accurately into the fifth file. I...

I 'inherited' a report that does membership cards. I need to add a counter to this. I don't know how. None of the documentation that I have says anything about it. And, as usual, I needed to do this yesterday. This report is in Crystal 5.

I have used both the ODBC drivers and the Visual FoxPro drivers. Both work fine. A faster way is to link the databases to an Access database and then use 3.51 drivers.

I use Access with a database that is presently about 7 Gig in size. The original database was written in Foxpro 2.5 and it is not normalized. By using Access, I can get a much more efficient arrangement of the data that I actually need to do a particular operation. The whole thing is on a...

Mattie, I agree with Rick. It is the speed of the computer. It is not Win2000. I have a Foxpro 2.6 app that runs fine on Win2000 (with the appropriate slow down patches).

You are so right. And, I know that and just didn't think about it. Is there any possibility of cutting these monsters, perhaps with Access queries into more managable size?

The VFP drivers do support FP 2.x according to the documentation. However, if the files are very big or if there are only a few fields that are wanted and there are a number of variables in the file, DB4 drivers work out a lot better.