Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Ship via codes 1
- Thread starter ehojr
- Start date
-
1
- #2
What database platform in the back? Pervasive or SQL.
What I would do is this, in SQL.
From Enterprise manager, create a view and give it a name of xxx_ship_via_codes
The sql for this view should be something like.
SELECT sy_terms_cd, ship_via_desc FROM SYSCDEFIL_SQL WHERE cd_type = 'V'
Keep this view. It will be handy on other reports as well. You can then add it to reports linking on the sy_terms_cd here and having the description.
Andy Baldwin
"Testing is the most overlooked programming language on the books!
What I would do is this, in SQL.
From Enterprise manager, create a view and give it a name of xxx_ship_via_codes
The sql for this view should be something like.
SELECT sy_terms_cd, ship_via_desc FROM SYSCDEFIL_SQL WHERE cd_type = 'V'
Keep this view. It will be handy on other reports as well. You can then add it to reports linking on the sy_terms_cd here and having the description.
Andy Baldwin
"Testing is the most overlooked programming language on the books!
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question