My apologies. I should have said Business Basic. We were taught bad database design skills. Luckily for me, I had other RDBMS experience before I started. I did have many problems with RPG programmers who designed poor tables in a previous job.
Russel Madere Webmaster 504.832.9835 SunShine Pages by EATEL www.sunshinepages.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 9:00 AM To: CF-Talk Subject: Re: RE: Primary Key Justification I'm not sure I completely agree with that statement about RPG programmers - I began my career doing Relational Database design and programming for OS400 using RPG. Their design and development (if done right) should be completely sound, maybe more so than what's produced by others. One thing you've got to keep in mind is that the old school RPG developers dealt with machines that had serious memory limitations... and so OS400 also had these limitations. For example, variable names couldn't exceed 6 characters... allowing more characters meant using up extra memory. The same line of thought applies to table, procedure, and column names as well. That said, anyone with a lot of experience in RPG needs to do a little reading and get with the times if they want to do database design using modern hardware and/or modern software... and I'd encourage them to do so. Developers that have never worked within the limitations that older systems used to apply don't really appreciate how easy they've got it ;) ~Simon [snip] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183867 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

