Hi,
Looking to build a small app in ProIV 5.5 VIP.
I have two tables CUSTOMER and PROJECT.
Each of these two tables has a field DESCRIPTION.
Within Oracle SQL I can separate these 2 fields as
CUSTOMER.DESCRIPTION and
PROJECT.DESCRIPTION
Does this work in ProIV or is there an alternative?
Should I make my database design different to have 2 separate fields e.g. CUST_DESCRIPTION and PROJ_DESCRIPTION?
Thanks
Click the link below to see the new game I'm developing!
Fieldname.tablename
Started by
Guest_Guest_*
, Sep 26 2005 02:44 PM
2 replies to this topic
#2
Neil Hunter
-
- Members
-
- 420 posts
ProIV Guru
- Gender:Male
- Location:Johannesburg, South Africa
Posted 26 September 2005 - 03:06 PM
Logic would tend to say prefix it with something rather, it makes life a bit easier trying to track down which one is which 
Haven't tried to do it, but in theory it should be possible. Take CUSTOMER, make the field name CU_DESCRIPTION and under alternate field put DESCRIPTION.
Haven't tried to do it, but in theory it should be possible. Take CUSTOMER, make the field name CU_DESCRIPTION and under alternate field put DESCRIPTION.
#3
twallis
-
- Members
-
- 19 posts
Member
- Gender:Male
- Location:Edinburgh
Posted 27 September 2005 - 05:44 AM
Neils got the right idea if all fields from a table are prefixed from the beginning it saves trouble in the end.
It will also add a little code at times but that’s the cost of not overwriting things you don't want to overwrite.
It will also add a little code at times but that’s the cost of not overwriting things you don't want to overwrite.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
Click the link below to see the new game I'm developing!
