Thanks, Bernie. I had tried that approach but, of course, because of my using the reserved word nothing worked when I tried to use that table to print from. Sure stopped me cold for a long while.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Wednesday, June 15, 2005 8:15 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Print problems Jay, Try limiting your report to one line of data (print ... where limit=1) If it works then you probably have some bad data in another row. Bernie Lis ----- Original Message ----- From: "Jay Ward" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, June 15, 2005 7:59 PM Subject: [RBG7-L] - Print problems >I am in the middle of creating a very small database for use with a > homeowners association. I have had no problems creating the forms etc. I > have two reports and one label printing routines. One report, a simple > listing of just two columns works just fine. The more complex report has > a > number of variable that are calculated to be printed, i.e., combining > honorifics and names and doing "if exists" to clean up the lack of a > second > line of street address and putting together city, state and zip. I do the > same on the label run. The report preview works fine and the results are > what I desire. However, when I place them in the application and attempt > to > run them my system freezes. I have tried doing a single line list > somewhat > like the one that works but it fails also. Since the two use different > tables I assume that's the problem but an unload and reload failed to > clear > up the problem. Any direction would be appreciated - using 7.1.80.30421 > on > this one. > >
