Function Runtime_Product_Load_Code()

[RayYates]

I need to retreive the Custom Product fields.

1. Will this function return all fields a just the main products fields?

<MvDO FILE = "{ g.Module_Library_DB }" NAME = "l.found" VALUE = "{ Runtime_Product_Load_Code( g.Product_Code, l.settings ) }">

2. If NOT what function do I need to call?

[Kent Multer]

Re: Function Runtime_Product_Load_Code()

According to my copy of the SDK, that function loads the fields from the Products table, and also inventory counts and settings, but not custom fields. I don't think Miva has released any documentation or source code on the custom fields. But I think it would be fairly easy to figure out what you need by creating a couple of fields, and looking at the databases to see the structure.

[MichaelBrock]

Re: Function Runtime_Product_Load_Code()

That function is one of the wonders of MivaSQL. It's a beauty. And of course does what Kent says it does. One downside is that the stock version of the function will not return in-active products so we're using a "fixed" version.

I couldn't find any stock functions in the source to handle the custom fields (it's handled by a module that as far as I know we don't have the source for) so we did what Kent suggests and wrote our own. The relevant tables are s01_CFM_CustValues and s01_CFM_CustFields.

[RayYates]

Re: Function Runtime_Product_Load_Code()

What does the l.settings paramiter refer to?

Runtime_Product_Load_Code( g.Product_Code, l.settings )

[wcw]

Re: Function Runtime_Product_Load_Code()

The return from that function fills the settings variable with the product info, eg settings:name, settings:code, etc

[RayYates]

Re: Function Runtime_Product_Load_Code()

Ok Thank Bill