Viewing Custom Field in BCM Opportunity using MS Access ODBC and S

[rickl43065]

Help,

I am "almost" there.. I am able to create a SQL link from MS Access and BCM.
All the standard fields are listed. I have several custom fields in the
opportunity page. I have searched the 50+ databases that are found with the
SQL link, and can find all of my data except anything in a custom field. I
have even found the database that contains the custom information about the
fields, (type, name, etc.) BUT the data for these is nowhere to be found.

My report that needs to be created depends upon the data in this custom
field.. It is just a date, and a quote #, (data that could be stored in other
preset fields, but that would cause other issues.. )

PLEASE HELP...................

Rick

 

[Chris Parrish]

Any luck with this? Or can anyone in BCM Dev land help with this one? I
too have custom fields that I need to access via ODBC.

I realize that this wouldn't be a MS supported access but someone out there
has to know (or at least guide) a SQL statement to retrieve/store values from
custom fields.

-Chris

 

[Luther]

Any luck with this?   Or can anyone in BCM Dev land help with this one? I
too have custom fields that I need to access via ODBC.

I realize that this wouldn't be a MS supported access but someone out there
has to know (or at least guide) a SQL statement to retrieve/store values from
custom fields.

-Chris









- Show quoted text -

I don't have BCM on this machine, but I've done this in the past.

The way I recall it, there is a table that describes the custom fields
(the one Rick found), and another table with the data. The table with
the data references at least one column in the first table, to
identify the field, and a column in another table that identifies
record the custom field data belongs to. You can look in the database
for the custom fields tables, or check to see where a view with custom
fields gets its data, or a sproc may reference both custom fields
tables; e.g. to print custom fields in a report.

If that fails, ask me next week.

Luther
http://beyng.blogspot.com