Jay's problem raises an interesting question. Should the table/view create/alter mechanisms give a warning message or possible an error message if you attempt to create or alter a table name, view name or column name with a reserved word? There are so many reserved words that it is easy to slip up and use one of them. Several years back this happened to me with my major address database. Although it didn't seem to give me any problems I only discovered it when I upgraded to v6.1a and received the RSTYLE program. I only spotted it when it made my column name all caps after processing it with RSTYLE.
Any thoughts/ comments from the list. Jim Bentley American Celiac Society Tel: 504-737-3293 [EMAIL PROTECTED] [EMAIL PROTECTED] --- Jay Ward <[EMAIL PROTECTED]> wrote: > Please disregard. I found the issue. I was using a > reserved word for a > table name. It allowed me to use it "owner" was the > word. It seems as if I > should have not been able to use the name at all. > Anyway, changing it > worked well. > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Jay Ward > Sent: Wednesday, June 15, 2005 8:00 PM > To: RBG7-L Mailing List > 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. > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
