General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
There's a view called vValid. This view contains all the legit choices a user can make in any particular combobox. For example the view contains types of credit cards (visa, mastercard, etc) and states (MA, MD, OH, etc) and collection method (web, fax, e-mail, etc). Every one of these records in the view has a unique id. The unique id is stored in the vCustomer or vInvoice or vOrder table. Since this unique id is meaningless to the end user, I have to UDF to the vValid table for the description when building a sql command for reporting. So, I wonder if the UDF should be stored with the views in the view dbc or should the UDF go in the VFP table dbc? My guess would be in the view DBC since all processing is between the views.
Thanks for your help, Erik. Sorry for being long-winded.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only