Hi,
Again, I'm not a programmer, but in my VFP programs, when I am attempting to access any record to make changes, I issue a rlock(), then whatever I'm trying to do, i.e., replace, edit, etc. When I'm done, I issue an unlock(). Most of the major things that VFP does automatically lock the...
Interesting discussion above, maybe because my code was from dBaseII and dBaseIII, I never really tried to change the date in any record at the same time. I always placed a rlock() on the record before the edit, and unlock afterwards.
Alan
Wow! You guys are just awesome. I have a lot to think about and to work through (remember, I'm not a programmer, just a user, in the olden days, there were no dBase programmers, everyone was a user, we learned how to build simple programs to get our work done).
I'm going to put some time...
I know I'm probably a bit late to this party, but I'm not a programmer, just a user. I run a small law office with just a few users. I started out using dBase II back on a Kaypro II CPM machine in the early ages of dinosaurs (1980s), and I've developed my office database programs over the...
Hi again,
Sorry to bother you guys but although I've been using Foxpro for many years (since 2.0 and before that dBase II), I've just recently started playing around with reports. The reports are much easier than writing entire programs to do the same thing, but the syntax is arcane.
Anyway...
Thanks Chris and Mike. I'm going to print this off and keep it for the future. Its too late at this point.
These databases (tables!!!) go back to when I originally started using dBaseII (under CPM as the operating system) a million years ago, before we had all these features and functions. In...
I was thinking about the theoretical problem, i.e., 2 records have the same name. This is possible (although I haven't had this occur in quite some time - it was a mess!). So, if I Changed Group 1 band to Lastname+Firstname+Accountno do you think this would resolve the problem? The reason I...
YES!!! Thank you, I think that did it, I just removed the Group 2 band and changed Group 1 as you suggested, ran a sample bill and it looks exactly the same. I don't have any duplicate names this billing cycle, but I am assuming that this is the fix.
Thank you for your kind assistance! It is...
Thanks you Mike. I'll try to modify the report and see how it goes. I'll be back. . .https://files.engineering.com/getfile.aspx?folder=c9e132c2-1765-4171-9a0e-4aaecb678abb&file=VFP_Report.doc
Thanks Mike and Chris. I do definitely have an index file attached to the database file. Its been so long I can't remember whether it is indexed on lastname only or lastname+firstname.
I am attaching what the report looks like and the Print When...
Well, I have some clients that use an account number, some use different types of numbers, so I always used lastname + firstname.
For some reason, this report only uses the lastname to sort and, as discussed above, it merges different accounts with the same lastname.
How would I change this so...
I don't know how to describe my problem. I have a report that I use for billing. Simple fields, Lastname, Firstname. So, this past month I had 2 bills with the same last name, let's call them Jane Cruz and John Cruz.
My Pageheader is ALLT(LASTNAME)-" "ALLT(FIRSTNAME) and in the Field...
I have the program that calls the report form do while idler < 100, store 1 to idler, then I run the report, then idler = idler+1.
report form bills for idler = clientnum
Some idea I think (??) in my old fashioned way.
Again, thanks for your help, it was great and now I have more ideas. ...
Got it, worked great!!! Thanks again for all your help and especially to Mike Lewis for the "heads up" regarding the "print when" in the report.
Now I want to go back and look at all my reports to see how to make them run more efficiently.
Greatly appreciate all the help I get here. [thumbsup]
Thanks, you guys are awesome! This particular client has perhaps 30 different entries on an cumlative invoice with the title portion of the report showing the sum total of all of the separate invoices. So, for whatever reason, they don't want each separate entry to have an invoice number. I...
Well, to tell you the truth, I don't use "stand alone" exe files, I still use VFP the old fashioned way as I've always done. Its a small office and the programs are for our internal use only. So each computer has a version of VFP on it, and the programs are like we always have done - DO...
Hi,
I have a VFP Report that I use to generate bills to my clients, but one of my clients needs a tweak to the report. So, I opened up the MODIFY REPORT command with the name of the report, made the change (it was a slight change, just taking out an invoice number) and then under File, saved...
I am using FPW 2.6 with old dBase/Foxpro handwritten programs, so I am just trying to get them to work under FPW 2.6, hoping to move later to VFP. The programs are hand written, using @say gets, etc, and I will need to hand write all of them.
First, I increased the size of the text in the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.