Actinic Database

[Classix]

I mannaged to find the table that products are stored in, in the .mdb file. But doesn anyone know where the product attribute information is held in the database?. I also need to know where the attribute choices are stored too, im using v6

Thanks in advance

[imis]

Hi,

You might want to take a look at the ProductProperties table...

Cheers

[Classix]

Great, thanks,
that shows all the attribute choices, eg RED GREEN
but i need to know where to find the attribute name, eg COLOUR

Any ideas?

[imis]

Hi,

Perhaps the nType field deserves closer attention:

Type of the property:
1 - searchable item
2 - additional prompt (not implemented)
3 - HTML Variable
4 - Price schedule
5 - Component
6 - Attribute *
7 - Choice
8 - Permutation
9 - Section Classification

*This could be the one that you're looking for.

Cheers